ASP.Net MVC Error: System.Collections.Generic.IEnumerable does not contain a definition for billing

rajeesh

SOLVED CLOSED ACTIVE ANSWERED
User: rajeesh
Posted: on Jan 31, 2022 10:35 PM
Forum: ASP.Net MVC
Answer: 1
Views: 2462

Dear sir,

I couldn't understand another model.

System.Collections.Generic.IEnumerable does not contain a definition for billing

Actually this existing model is only for creating to insert datas to database. I have need all model properties for insertion. I have mentioned my model class below if you don't mind kindly explain with example.

And I have two dynamic dropdownlist list the existing model(BsaModel). Are you told me below same model create once more have any for that. And if i create same model class can we solve our problems.

Sorry for your valuable times spend with me.

@using ASPMVC.Models
@model IEnumerable<BsaModel>
           
@{
    ViewBag.Title = "BSA";
}
 
<h2>Sales</h2>
 
@using (Html.BeginForm("Insert", "Test",FormMethod.Post))
{
    @Html.AntiForgeryToken()
 
    <div class="bggrdnt">
        <div style="overflow:auto">
           <table id="tblItems" class="table table-responsive" style="background-color:whitesmoke">
               <thead>
                   <tr>
                       <th>Items</th>
                       <th>HSN Code</th>
                       <th>Rate</th>
                       <th>Sgst</th>
                       <th>Cgst</th>
                       <th>Qty</th>
                       <th>Dis</th>
                       <th>Dis Amt</th>
                       <th>Cgst Amt</th>
                       <th>Sgst Amt</th>
                       <th>Amount</th>
                       <th>Total</th>
                       <th>Action</th>
                   </tr>
               </thead>
               <tbody>
                   @foreach(BsaModel products in Model)
                   {
                   <tr> 
                       <td>@products.billing</td>
                       <td>@products.Hsncode</td>
                       <td>@products.Rate</td>
                       <td>@products.Sgst</td>
                       <td>@products.Cgst</td>
                       <td>@products.Discounts</td>
                       <td>@products.Disamt</td>
                       <td>@products.Sgstamt</td>
                       <td>@products.Cgstamt</td>
                       <td>@products.Amount</td>
                       <td>@products.Total</td>
                       <td><input type="button" value="Remove" onclick="Remove(this)" /></td>
                   </tr>                        
                   }
               </tbody>
               <tfoot>
                   <tr>
                      <td>@Html.DropDownListFor(m => m.id, Model.<span style=""color:" #ff0000;"="">billing</span>, "Please select", new { @id = "ddlItems", @class = "form-control" })</td>
                      <td>@Html.TextBoxFor(m => m.<span style=""color:" #ff0000;"="">Hsncode</span>, new { @id = "txthsncode", @class = "form-control" })</td>
                      <td>@Html.TextBoxFor(m => m.<span style=""color:" #ff0000;"="">Rate</span>, new { @id = "txtRate", @class = "form-control" })</td>
                      <td>@Html.TextBoxFor(m => m.<span style=""color:" #ff0000;"="">Sgst</span>, new { @id = "txtSgst", @class = "form-control", onmouseenter = "Sgstpar();" })</td>
                      <td>@Html.TextBoxFor(m => m.<span style=""color:" #ff0000;"="">Cgst</span>, new { @id = "txtCgst", @class = "form-control", onmouseenter = "Cgstpar();" })</td>
                      <td>@Html.TextBoxFor(m => m.<span style=""color:" #ff0000;"="">Quantity</span>, new { @id = "txtqty", @class = "form-control" })</td>
                      <td>@Html.TextBoxFor(m => m.<span style=""color:" #ff0000;"="">Discounts</span>, new { @id = "txtdisc", @class = "form-control" })</td>
                      <td>@Html.TextBoxFor(m => m.<span style=""color:" #ff0000;"="">Disamt</span>, new { @id = "txtdisamt", @class = "form-control" })</td>
                      <td>@Html.TextBoxFor(m => m.<span style=""color:" #ff0000;"="">Sgstamt</span>, new { @id = "txtSgstamt", @class = "form-control", onmouseenter = "Sgstpar();" })</td>
                      <td>@Html.TextBoxFor(m => m.<span style=""color:" #ff0000;"="">Cgstamt</span>, new { @id = "txtCgstamt", @class = "form-control", onmouseenter = "Cgstpar();" })</td>
                      <td>@Html.TextBoxFor(m => m.<span style=""color:" #ff0000;"="">Amount</span>, new { @id = "txtamt", @class = "form-control", onmouseenter = "Calculate();" })</td>
                      <td>@Html.TextBoxFor(m => m.<span style=""color:" #ff0000;"="">Total</span>, new { @id = "txttotal", @class = "form-control" })</td>
                      <td><input type="button" id="" onclick="Add()" value="Add" /></td>
                   </tr>
               </tfoot>
           </table>
       </div> 
    </div>
}

public class BsaModel
{
    public List<SelectListItem> customerlist { get; set; }
    public string Customer { get; set; }
    public string BillNo { get; set; }
    public double Balanceamt { get; set; }
    public DateTime Date { get; set; }
    public List<SelectListItem> billing { get; set; }
    public int id { get; set; }
    public int Companyid { get; set; }
    public string Itemname { get; set; }
    public int Rate { get; set; }
    public int Sgst { get; set; }
    public int Cgst { get; set; }
    public int Quantity { get; set; }
    public int Discounts { get; set; }
    public double Disamt { get; set; }
    public double Sgstamt { get; set; }
    public double Cgstamt { get; set; }
    public double Amount { get; set; }
    public double Total { get; set; }
    public string Hsncode { get; set; }
    public double SubTotal { get; set; }
}

Thanks & Regards

Rajeesh

Download FREE API for Word, Excel and PDF in ASP.Net

arjunv

0 6

Reply
ANSWER
User: arjunv
Replied: on Feb 03, 2022 02:51 AM
Modified: on Feb 03, 2022 02:52 AM
Report

Hi Rajeesh,

Please refer below sample.

Database

For this example I have used of Northwind database that you can download using the link given below.

Download Northwind Database

Model

ProductModel

public class ProductModel
{
    public int ProductID { get; set; }
    public string ProductName { get; set; }
    public decimal UnitPrice { get; set; }
    public List<CategoryModel> Categories { get; set; }
}

CategoryModel

public class CategoryModel
{
    public int CategoryID { get; set; }
    public string CategoryName { get; set; }
    public string Description { get; set; }
}

Controller

public class HomeController : Controller
{
    // GET: Home
    public ActionResult Index()
    {
        ProductModel products = GetProduct();
        products.Categories= GetCategories();
        return View(products);
    }

    private ProductModel GetProduct()
    {
        ProductModel product = new ProductModel();
        string conString = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
        string query = "SELECT TOP 1 ProductID,ProductName,UnitPrice,CategoryID FROM Products ORDER BY NEWID()";
        using (SqlConnection con = new SqlConnection(conString))
        {
            using (SqlCommand cmd = new SqlCommand(query, con))
            {
                con.Open();
                SqlDataReader sdr = cmd.ExecuteReader();
                if (sdr.Read())
                {
                    product.ProductID = Convert.ToInt32(sdr["ProductID"]);
                    product.ProductName = sdr["ProductName"].ToString();
                    product.UnitPrice = Convert.ToDecimal(sdr["UnitPrice"]);
                }

                con.Close();
            }
        }

        return product;
    }

    private List<CategoryModel> GetCategories()
    {
        List<CategoryModel> categories = new List<CategoryModel>();
        string conString = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
        string query = "SELECT TOP 5 CategoryID,CategoryName,Description FROM Categories";
        using (SqlConnection con = new SqlConnection(conString))
        {
            using (SqlCommand cmd = new SqlCommand(query, con))
            {
                con.Open();
                SqlDataReader sdr = cmd.ExecuteReader();
                while (sdr.Read())
                {
                    CategoryModel category = new CategoryModel();
                    category.CategoryID = Convert.ToInt32(sdr["CategoryID"]);
                    category.CategoryName = sdr["CategoryName"].ToString();
                    category.Description = sdr["Description"].ToString();
                    categories.Add(category);
                }
                con.Close();
            }
        }

        return categories;
    }
}

View

@model Model_List_MVC.Models.ProductModel
@using Model_List_MVC.Models;
@{
    Layout = null;
}

<!DOCTYPE html>

<html>
<head>
    <meta name="viewport" content="width=device-width" />
    <title>Index</title>  
</head>
<body>
    <div class="bggrdnt">
        <div style="overflow:auto">
            <table id="tblItems" class="table table-responsive" style="background-color:whitesmoke">
                <thead>
                    <tr>
                        <th>CategoryID</th>
                        <th>CategoryName</th>
                        <th>Description</th>
                        <th></th>
                    </tr>
                </thead>
                <tbody>
                    @foreach (CategoryModel category in Model.Categories)
                    {
                        <tr>
                            <td>@category.CategoryID</td>
                            <td>@category.CategoryName</td>
                            <td>@category.Description</td>
                            <td><input type="button" value="Remove" onclick="Remove(this)" /></td>
                        </tr>
                    }
                </tbody>
                <tfoot>
                    <tr>
                        <td>@Html.TextBoxFor(m => m.ProductID, new { @id = "txtId", @class = "form-control" })</td>
                        <td>@Html.TextBoxFor(m => m.ProductName, new { @id = "txtname", @class = "form-control" })</td>
                        <td>@Html.TextBoxFor(m => m.UnitPrice, new { @id = "txtprice", @class = "form-control" })</td>
                        <td><input type="button" id="" onclick="Add()" value="Add" /></td>
                    </tr>
                </tfoot>
            </table>
        </div>
    </div>
</body>
</html>

Screenshot

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

ASP.Net MVC Error: System.Collections.Generic.IEnumerable does not contain a definition for billing

Insert multiple row in database in ASP.Net MVC using jQuery Ajax

Company

Explore

Follow us

Contact Us