public int InsertDetails(cDetails d) { SqlConnection con = new SqlConnection(Helper.conStr); if (con.State.ToString() == "open") { con.Close(); } con.Open(); string query = "INSERT INTO mDetails(mId,dFieldName,dFieldvalue) values('" + d.mId + "','" + d.field_name + "','" + d.field_value + "')"; SqlCommand cmd = new SqlCommand(query, con); var result = cmd.ExecuteNonQuery(); con.Close(); cmd.Dispose(); con.Dispose(); return(result); }
public int InsertDetails(cDetails d) { return(new TMS.DAL.cMeaurementsDAL().InsertDetails(d)); }
private void button1_Click(object sender, EventArgs e) { cCustomer customer = new cCustomer(); customer.cFullName = txtFullname.Text.Trim(); customer.cCNIC = txtCNIC.Text.Trim(); customer.cAddress = txtAddress.Text.Trim(); customer.cMobileNo = txtMobile.Text.Trim(); customer.cRemarks = txtRemarks.Text.Trim(); if (customer.cFullName != "") { if (customer.cCNIC != "") { if (customer.cAddress != "") { if (customer.cMobileNo != "") { if (customer.cRemarks != "") { if (new cCustomerBLL().InsertCustomer(customer) > 0) { //valid record or user /**/ var cid = new cCustomerBLL().getId(customer);//recently added customer cMeaurements m = new cMeaurements(); cDetails d = new cDetails(); foreach (var mes in mList) { m.cId = cid; m.mType = mes[0].tempType; new cMeaurementsBLL().InsertMeaurements(m); var mid = new cMeaurementsBLL().getId(m); foreach (var details in mes) { d.mId = mid; d.field_name = details.field_name; d.field_value = details.field_value; new cMeaurementsBLL().InsertDetails(d); } } MessageBox.Show("Data stored...!!!", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information); txtFullname.Text = ""; txtCNIC.Text = ""; txtAddress.Text = ""; txtMobile.Text = ""; txtRemarks.Text = ""; } else { MessageBox.Show("Data cannot be stored...!!!", "Alert", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } else { MessageBox.Show("Remarks Must be entered...!!!", "Alert", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } else { MessageBox.Show("Mobile No should be selected...!!!", "Alert", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } else { MessageBox.Show("Address should be filled...!!!", "Alert", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } else { MessageBox.Show("CNIC should be filled...!!!", "Alert", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } else { MessageBox.Show("Full Name should be filled...!!!", "Alert", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }