Data repository

I am using my repository layer to add items from a datagridview into my database. Some of the data are product ordered, the orders are table number, user, date, total expenditure. But with the code I have, I don’t get all the product that are the datagridview. The data gridview contains 6 of 9 parameters that is to complete the columns in the database table . The 6 are products and its corresponding details. In this case multiple orders are placed into the datagridview but it only saves one items for the table regardless of the number of items in the datagridviewHow do I go about it ?

private void btnsend_Click(object sender, EventArgs e) {
var iscorrect = kk.isvaliduser(Int32.Parse(libtabsno.Text));
if (!iscorrect) {
foreach(DataGridViewRow dr in dataGridView2.Rows) {
ck.category = dr.Cells[4].Value.ToString();
ck.productname = dr.Cells[2].Value.ToString();
string price = (dr.Cells[3].Value.ToString());
ck.productprice = double.Parse(price);
string ip = (dr.Cells[6].Value.ToString());
ck.tprice = double.Parse(ip);
ck.productid = Int32.Parse(dr.Cells[1].Value.ToString());
ck.quantity = Int32.Parse(dr.Cells[5].Value.ToString());
}
ck.tabel_sno_ = Int32.Parse(libtabsno.Text);
ck.tabel_no_ = Int32.Parse(libtno.Text.ToString());
ck.total = Int32.Parse(libt2.Text);
ck.date = DateTime.Now;
ck.user = libuser.Text;
kk.addunpaid(ck);
}
}

what do you want to achieve?

Do you want to send all rows from aspx.cs (UI layer) To Data Access Layer, and want to save all records at a time, please share your Data Repository layer code.

Then your code should be like below

private void btnsend_Click(object sender, EventArgs e)
{
var iscorrect = kk.isvaliduser(Int32.Parse(libtabsno.Text));
if (!iscorrect)
{
List ListItems = new List();
foreach (DataGridViewRow dr in dataGridView2.Rows)
{
DataModel ck = new DataModel();
ck.category = dr.Cells[4].Value.ToString();
ck.productname = dr.Cells[2].Value.ToString();
string price = (dr.Cells[3].Value.ToString());
ck.productprice = double.Parse(price);
string ip = (dr.Cells[6].Value.ToString());
ck.tprice = double.Parse(ip);
ck.productid = Int32.Parse(dr.Cells[1].Value.ToString());
ck.quantity = Int32.Parse(dr.Cells[5].Value.ToString());
ck.tabel_sno_ = Int32.Parse(libtabsno.Text);
ck.tabel_no_ = Int32.Parse(libtno.Text.ToString());
ck.total = Int32.Parse(libt2.Text);
ck.date = DateTime.Now;
ck.user = libuser.Text;
ListItems.Add(ck);
}
dal.InsertDataToDb(ListItems); // send to data access layer
}
}
public void InsertDataToDb(List items)
{
string connectionString = ConfigurationManager.ConnectionStrings["connection"].
ConnectionString;
var records = items;
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
SqlCommand cmd =
new SqlCommand(
"INSERT INTO TableName (param1, param2, param3) " +
" VALUES (@param1, @param2, @param3)");
cmd.CommandType = CommandType.Text;
cmd.Connection = conn;
cmd.Parameters.Add("@param1", DbType.String);
cmd.Parameters.Add("@param2", DbType.String);
cmd.Parameters.Add("@param3", DbType.String);
foreach (var item in records)
{
cmd.Parameters[0].Value = item.param1;
cmd.Parameters[1].Value = item.param2;
cmd.Parameters[2].Value = item.param3;
cmd.ExecuteNonQuery();
}
conn.Close();
}
}
public class DataModel
{
public string Category { get; set; }
public string productname { get; set; }
public double productprice { get; set; }
public string ip { get; set; }
public double tprice { get; set; }
public int productid { get; set; }
public int quantity { get; set; }
public int tabel_sno_ { get; set; }
public int tabel_no_ { get; set; }
public DateTime date { get; set; }
public string user { get; set; }
}

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Sachin Singh5y ago
Accepted answer
what do you want to achieve?
Do you want to send all rows from aspx.cs (UI layer) To Data Access Layer, and want to save all records at a time, please share your Data Repository layer code.
Then your code should be like below
private void btnsend_Click(object sender, EventArgs e)
{


    var iscorrect = kk.isvaliduser(Int32.Parse(libtabsno.Text));
    if (!iscorrect)
    {
        List ListItems = new List();
        foreach (DataGridViewRow dr in dataGridView2.Rows)
    {

        DataModel ck = new DataModel();
        ck.category = dr.Cells[4].Value.ToString();
        ck.productname = dr.Cells[2].Value.ToString();
        string price = (dr.Cells[3].Value.ToString());
        ck.productprice = double.Parse(price);
        string ip = (dr.Cells[6].Value.ToString());
        ck.tprice = double.Parse(ip);
        ck.productid = Int32.Parse(dr.Cells[1].Value.ToString());
        ck.quantity = Int32.Parse(dr.Cells[5].Value.ToString());
        ck.tabel_sno_ = Int32.Parse(libtabsno.Text);
        ck.tabel_no_ = Int32.Parse(libtno.Text.ToString());
        ck.total = Int32.Parse(libt2.Text);
        ck.date = DateTime.Now;
        ck.user = libuser.Text;
        ListItems.Add(ck);
        }

        dal.InsertDataToDb(ListItems);  // send to data access layer
    }
}


public void InsertDataToDb(List items)
{
    string connectionString = ConfigurationManager.ConnectionStrings["connection"].
        ConnectionString;
    var records = items;

    using (SqlConnection conn = new SqlConnection(connectionString))
    {
        conn.Open();

        SqlCommand cmd =
            new SqlCommand(
                "INSERT INTO TableName (param1, param2, param3) " +
                " VALUES (@param1, @param2, @param3)");
        cmd.CommandType = CommandType.Text;
        cmd.Connection = conn;
        cmd.Parameters.Add("@param1", DbType.String);
        cmd.Parameters.Add("@param2", DbType.String);
        cmd.Parameters.Add("@param3", DbType.String);

        foreach (var item in records)
        {
            cmd.Parameters[0].Value = item.param1;
            cmd.Parameters[1].Value = item.param2;
            cmd.Parameters[2].Value = item.param3;

            cmd.ExecuteNonQuery();
        }

        conn.Close();
    }
}




    public class DataModel
    {
        public string Category { get; set; }
        public string productname { get; set; }
        public double productprice { get; set; }
        public string ip { get; set; }

        public double tprice { get; set; }
        public int productid { get; set; }
        public int quantity { get; set; }
        public int tabel_sno_ { get; set; }
        public int tabel_no_ { get; set; }
        public DateTime date { get; set; }

        public string user { get; set; }

    }