public List <cMeaurements> getMeasurements(int customerID)
{
List <cMeaurements> customers = new List <cMeaurements>();
SqlConnection con = new SqlConnection(Helper.conStr);
if (con.State == System.Data.ConnectionState.Open)
{
con.Close();
}
con.Open();
string query = "select * from Measurement where cId='" + customerID + "' ";
SqlCommand cmd = new SqlCommand(query, con);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
cMeaurements u1 = new cMeaurements();
u1.cId = Convert.ToInt32(reader["cId"]);
u1.mType = reader["mType"].ToString();
customers.Add(u1);
}
reader.Close();
con.Close();
con.Dispose();
cmd.Dispose();
return(customers);
}
protected void Button1_Click(object sender, EventArgs e)
{
cMeaurements m = new cMeaurements();
m.cId = Convert.ToInt32(GridView1.SelectedValue.ToString());
m.mType = d.tempType;
m.mType = type.Text;
new cMeaurementsDAL().InsertMeaurements(m);
//added meausurement
d.mId = new cMeaurementsDAL().getId(m);
foreach (GridViewRow r in GridView2.Rows)
{
var ts = (r.FindControl("valuetxt") as TextBox).Text;
d.field_name = (r.FindControl("namelbl") as Label).Text;
d.field_value = Convert.ToInt32((r.FindControl("valuetxt") as TextBox).Text);
d.tempType = type.Text;
//detailsList.Add(d);
new cMeaurementsDAL().InsertDetails(d);
}
}
public int getId(cMeaurements m)
{
SqlConnection con = new SqlConnection(Helper.conStr);
if (con.State == System.Data.ConnectionState.Open)
{
con.Close();
}
con.Open();
string query = "SELECT mId FROM Measurement WHERE cId = '" + m.cId + "' and mType= '" + m.mType + "'";
SqlCommand cmd = new SqlCommand(query, con);
Int32 count = (Int32)cmd.ExecuteScalar();
/*
* SqlCommand cmd = new SqlCommand(query, con);
* var result = cmd.ExecuteNonQuery();*/
con.Close();
cmd.Dispose();
con.Dispose();
return(count);
}
public int InsertMeaurements(cMeaurements m)
{
SqlConnection con = new SqlConnection(Helper.conStr);
if (con.State.ToString() == "open")
{
con.Close();
}
con.Open();
string query = "INSERT INTO Measurement(cId,mType) values('" + m.cId + "','" + m.mType + "')";
SqlCommand cmd = new SqlCommand(query, con);
var result = cmd.ExecuteNonQuery();
con.Close();
cmd.Dispose();
con.Dispose();
return(result);
}
public int getId(cMeaurements m)
{
return(new TMS.DAL.cMeaurementsDAL().getId(m));
}
public int InsertMeaurements(cMeaurements m)
{
return(new TMS.DAL.cMeaurementsDAL().InsertMeaurements(m));
}
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);
}
}
