protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName.Equals("AddNew"))
{
TextBox txtproductfooter = (TextBox)GridView1.FooterRow.FindControl("txtproductfooter");
TextBox txtmanufacturefooter = (TextBox)GridView1.FooterRow.FindControl("txtmanufacturefooter");
TextBox txtmodelfooter = (TextBox)GridView1.FooterRow.FindControl("txtmodelfooter");
TextBox txtdevtypefooter = (TextBox)GridView1.FooterRow.FindControl("txtdevtypefooter");
TextBox txtdevclassifooter = (TextBox)GridView1.FooterRow.FindControl("txtdevclassifooter");
TextBox txtsupplyfooter = (TextBox)GridView1.FooterRow.FindControl("txtsupplyfooter");
TextBox txtpowerfooter = (TextBox)GridView1.FooterRow.FindControl("txtpowerfooter");
db1.strCommand = "insert into Product(ProductName,Company,Model,Device_Type,Device_Classification,Supply,PowerRating)values " +
"('" + txtproductfooter.Text.Trim() + "','" + txtmanufacturefooter.Text + "','" + txtmodelfooter.Text + "'," +
"'" + txtdevtypefooter.Text.Trim() + "','" + txtdevclassifooter.Text.Trim() + "','" + txtsupplyfooter.Text.Trim() + "','" + txtpowerfooter.Text.Trim() + "')";
db1.insertqry();
GridProductBind();
lblresult.ForeColor = Color.Green;
lblresult.Text = " Details inserted successfully";
}
//else
//{
// lblresult.ForeColor = Color.Red;
// lblresult.Text = " Details not inserted";
//}
}
public void save_performancetest()
{
db1.strCommand = "insert into check_perftest(PerfID,Perf_TestName) values('" + Session["Perfid37"].ToString() + "','" + Session["performancename37"].ToString() + "')";
db1.insertqry();
perfname = Session["performancename37"].ToString();
}
protected void btnsave_Click(object sender, EventArgs e)
{
save_performancetest();
int count = this.NumberOfControls1;
for (int i = 0; i < count; i++)
{
TextBox txcat = (TextBox)PlaceHolder1.FindControl("txtData" + i.ToString());
TextBox txsubcat = (TextBox)PlaceHolder1.FindControl("txtsubData" + i.ToString());
TextBox txsubcat1 = (TextBox)PlaceHolder1.FindControl("txtsubData_1" + i.ToString());
TextBox txsubcat2 = (TextBox)PlaceHolder1.FindControl("txtsubData_2" + i.ToString());
TextBox txsubcat3 = (TextBox)PlaceHolder1.FindControl("txtsubData_3" + i.ToString());
TextBox txsubcat4 = (TextBox)PlaceHolder1.FindControl("txtsubData_4" + i.ToString());
TextBox txsubcat5 = (TextBox)PlaceHolder1.FindControl("txtsubData_5" + i.ToString());
TextBox txsubcat6 = (TextBox)PlaceHolder1.FindControl("txtsubData_6" + i.ToString());
//Add the Controls to the container of your choice
perf_valueHidden.Value = txcat.Text.Trim().Replace("'", "''") + "," + txsubcat.Text.Trim().Replace("'", "''") + "," +
txsubcat1.Text.Trim().Replace("'", "''") + "," + txsubcat2.Text.Trim().Replace("'", "''") + "," +
txsubcat3.Text.Trim().Replace("'", "''") + "," + txsubcat4.Text.Trim().Replace("'", "''") + "," +
txsubcat5.Text.Trim().Replace("'", "''") + "," + txsubcat6.Text.Trim().Replace("'", "''") + ",";
db1.strCommand = "insert into Performance_Values(PerfID,Perf_Value) values('" + Session["perfid"].ToString() + "','" + perf_valueHidden.Value + "')";
db1.insertqry();
txcat.Text = "";
txsubcat.Text = "";
txsubcat1.Text = "";
txsubcat2.Text = "";
txsubcat3.Text = "";
txsubcat4.Text = "";
txsubcat5.Text = "";
txsubcat6.Text = "";
}
db1.strCommand = "select Top " + count + " ValueID from Performance_Values order by ValueID desc";
DataTable dt_valueid = db1.selecttable();
if (dt_valueid.Rows.Count > 0)
{
for (int i = 0; i < count; i++)
{
db1.strCommand = "insert into perfvaluesplit(PerfID,ValueID)values('" + Session["PerfID"].ToString() + "','" + dt_valueid.Rows[i]["ValueID"].ToString() + "')";
db1.insertqry();
}
}
Removetextbox();
btnadd.Focus();
}
public void PopulateProductdetails()
{
if (usertype == "2")
{
int hpid = Convert.ToInt32(idhospitalhidden.Value);
DataTable dt_result = new DataTable();
db1.strCommand = "select rp.ReportNo,rp.ProductID,rp.Date_of_calibration,hp.HospitalName,dt.Serial_No,dt.Biomedical_ID,dt.Location from Report_Info rp " +
"inner join Hospital hp on hp.HospitalID=rp.HospitalID " +
"inner join DUT_info dt on dt.Report_info_ID=rp.Report_info_ID where rp.HospitalID='" + hpid + "' and rp.Report_info_ID='" + reportidhidden.Value + "'";
DataTable dt = db1.selecttable();
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
hospnamehidden.Value = dt.Rows[i]["HospitalName"].ToString();
db1.strCommand = "select * from Product where ProductID='" + dt.Rows[i]["ProductID"].ToString() + "'";
DataTable dt_prod = db1.selecttable();
if (dt_prod.Rows.Count > 0)
{
for (int j = 0; j < dt_prod.Rows.Count; j++)
{
db1.strCommand = "insert into Prevention(HospitalID,ProductName,Manufacture,Model,DeviceType," +
"DeviceClassi,Supply,Power,Serial_No,BiomedicalID,Location,Description)values" +
"('" + hpid + "','" + dt_prod.Rows[j]["ProductName"].ToString() + "','" + dt_prod.Rows[j]["Company"].ToString() + "'," +
"'" + dt_prod.Rows[j]["Model"].ToString() + "','" + dt_prod.Rows[j]["Device_Type"].ToString() + "'," +
"'" + dt_prod.Rows[j]["Device_Classification"].ToString() + "','" + dt_prod.Rows[j]["Supply"].ToString() + "'," +
"'" + dt_prod.Rows[j]["PowerRating"].ToString() + "','" + dt.Rows[i]["Serial_No"].ToString() + "'," +
"'" + dt.Rows[i]["Biomedical_ID"].ToString() + "','" + dt.Rows[i]["Location"].ToString() + "','" + txtprevent.Text.Replace("'", "''") + "')";
db1.insertqry();
}
}
}
//GridView1.DataSource = dt_result;
//GridView1.DataBind();
}
//}
//}
}
else
{
}
//}
//}
}
protected void btnsave_Click(object sender, EventArgs e)
{
if (lsttrace.SelectedIndex >= 0)
{
tracehidden.Value = "";
foreach (ListItem li in lsttrace.Items)
{
if (li.Selected == true)
{
tracehidden.Value += li.Value + ",";
}
}
db1.strCommand = "update Product set Tracibility_ID='" + tracehidden.Value + "',Remarks='" + txtremarks.Text.Replace("'", "''") + "' where ProductName like '" + drpproduct.SelectedValue + "%'";
db1.insertqry();
txtremarks.Text = "";
lblmsg.Text = "Data Inserted Successfully";
BindProduct();
BindTraceability();
Bindtraceid();
}
else
{
ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Please Select Traceability Details !');", true);
}
}
protected void btnsave_Click(object sender, EventArgs e)
{
if (lstperformance.SelectedIndex >= 0)
{
lnk_perf_hidden.Value = "";
foreach (ListItem li in lstperformance.Items)
{
if (li.Selected == true)
{
lnk_perf_hidden.Value += li.Value + ",";
}
}
db1.strCommand = "update Product set PerfID='" + lnk_perf_hidden.Value + "' where ProductName like '" + drpproduct.SelectedValue + "%'";
db1.insertqry();
lblmsg.Text = "Data Inserted Successfully";
BindProduct();
BindPerformance();
BindPerfid();
}
else
{
ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Please Select Performance Details !');", true);
}
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
int ecmid = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Value.ToString());
//string username = GridView1.DataKeys[e.RowIndex].Values["UserName"].ToString();
TextBox txttemperature = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txttemperature");
TextBox txtRelative_Humidity = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txtRelative_Humidity");
TextBox txtambient = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txtambient");
db1.strCommand = "update Environ_condition set Temperature='" + txttemperature.Text.Trim() + "',Relative_Humidity='" + txtRelative_Humidity.Text.Trim() + "'," +
"Ambient_Barometric_measure='" + txtambient.Text.Trim() + "' where ECM_ID=" + ecmid;
db1.insertqry();
lblresult.ForeColor = Color.Green;
lblresult.Text = " Details Updated successfully";
GridView1.EditIndex = -1;
Gridbind();
}
protected void btnsave_Click(object sender, EventArgs e)
{
string traceid = "";
foreach (ListItem li in lsttrace.Items)
{
if (li.Selected == true)
{
tracehidden.Value = li.Text;
traceid = li.Value;
db1.strCommand = "insert into Link_Product_Trace(Instrument,ProductName,Tracibility_ID) values('" + tracehidden.Value + "','" + drpproduct.SelectedItem.Text + "','" + Convert.ToInt32(traceid) + "')";
db1.insertqry();
}
}
lblmsg.Text = "Data Inserted Successfully";
BindProduct();
BindTraceability();
GridBind();
}
protected void GridViewaddtrace_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
traceidhidden.Value = (GridViewaddtrace.DataKeys[e.RowIndex].Value.ToString());
//string username = GridView1.DataKeys[e.RowIndex].Values["UserName"].ToString();
TextBox txtInstrument = (TextBox)GridViewaddtrace.Rows[e.RowIndex].FindControl("txtInstrument");
TextBox txtMake = (TextBox)GridViewaddtrace.Rows[e.RowIndex].FindControl("txtMake");
TextBox txtModel = (TextBox)GridViewaddtrace.Rows[e.RowIndex].FindControl("txtModel");
TextBox txtSerial_No = (TextBox)GridViewaddtrace.Rows[e.RowIndex].FindControl("txtSerial_No");
TextBox txttracecall = (TextBox)GridViewaddtrace.Rows[e.RowIndex].FindControl("txttracecall");
TextBox txtReference = (TextBox)GridViewaddtrace.Rows[e.RowIndex].FindControl("txtReference");
db1.strCommand = "update Traceability_Info set Instrument='" + txtInstrument.Text.Trim() + "',Make='" + txtMake.Text.Trim() + "'," +
"Model='" + txtModel.Text.Trim() + "',Serial_No='" + txtSerial_No.Text.Trim() + "',Traceability_call_due='" + txttracecall.Text.Trim() + "'," +
"Reference='" + txtReference.Text.Trim() + "' where Tracibility_ID='" + Convert.ToInt32(traceidhidden.Value) + "'";
db1.insertqry();
lblresult.ForeColor = Color.Green;
lblresult.Text = " Details Updated successfully";
GridViewaddtrace.EditIndex = -1;
Gridbind();
}
//save dynamic values of categories to database
protected void btnRead_Click(object sender, EventArgs e)
{
db1.strCommand = "insert into PerformanceTest values('" + txtperfname.Text.Trim().Replace("'", "''") + "')";
db1.insertqry();
retrieve_performancetest();
int count = this.NumberOfControls;
for (int i = 0; i < count; i++)
{
TextBox tx = (TextBox)PlaceHolder1.FindControl("txtData" + i.ToString());
//Add the Controls to the container of your choice
SqlConnection con = new SqlConnection(sqlcon);
con.Open();
SqlCommand cmd = new SqlCommand("insert into Perf_Category(PerfID,CategoryName)values('" + perfid + "','" + tx.Text.Trim().Replace("'", "''") + "')", con);
cmd.ExecuteNonQuery();
tx.Text = "";
txtperfname.Text = "";
select_perftest_name();
}
string path = Page.Request.Url.AbsolutePath;
Response.Redirect(path);
}
protected void btnsave_Click(object sender, EventArgs e)
{
if (btnsave.Text == "Save")
{
db1.strCommand = "select Model from Product where ProductName like '" + txtproname.Text.Trim() + "' and " +
"Company like '" + txtmanu.Text.Trim() + "' and Model like '" + txtmodel.Text.Trim() + "'";
DataTable dt = db1.selecttable();
if (dt.Rows.Count <= 0)
{
db1.strCommand = "insert into Product(ProductName,Company,Model,Device_Type,Device_Classification,Supply,PowerRating)values " +
"('" + txtproname.Text.Trim().Replace("'", "''") + "','" + txtmanu.Text.Trim().Replace("'", "''") + "','" + txtmodel.Text.Trim().Replace("'", "''") + "'," +
"'" + txtdevtype.Text.Trim().Replace("'", "''") + "','" + txtdevclassification.Text.Trim().Replace("'", "''") + "','" + txtsupplydata.Text.Trim().Replace("'", "''") + "'," +
"'" + txtpower.Text.Trim().Replace("'", "''") + "')";
db1.insertqry();
GridProductBind();
clearfield();
}
else
{
ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Model Name already exists !');", true);
}
}
else if (btnsave.Text == "Update")
{
db1.strCommand = "update Product set ProductName='" + txtproname.Text.Trim().Replace("'", "''") + "'," +
"Company='" + txtmanu.Text.Trim().Replace("'", "''") + "',Model='" + txtmodel.Text.Trim().Replace("'", "''") + "'," +
"Device_Type='" + txtdevtype.Text.Trim().Replace("'", "''") + "',Device_Classification='" + txtdevclassification.Text.Trim().Replace("'", "''") + "'," +
"Supply='" + txtsupplydata.Text.Trim().Replace("'", "''") + "',PowerRating='" + txtpower.Text.Trim().Replace("'", "''") + "'" +
" where ProductID='" + productidhidden.Value + "'";
db1.insertqry();
GridProductBind();
btnsave.Text = "Save";
clearfield();
}
}
//save username, password and usertype to Logintb.
protected void btnsave_Click(object sender, EventArgs e)
{
if (btnsave.Text == "Save")
{
string query = "select * from LoginTb where Username='******'", "''") + "'";
SqlDataReader dr = db1.getDataReader(query);
if (dr.HasRows)
{
ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Username already exists!');", true);
}
else
{
db1.strCommand = "insert into LoginTb(Username,Password,Usertype) values('" +
txtusername.Text.Trim().Replace("'", "''") + "','" +
txtpswd.Text.Trim().Replace("'", "''") + "','" +
drpusertype.SelectedValue + "')";
db1.insertqry();
find_logid();
clear();
string path = Page.Request.Url.AbsolutePath;
Response.Redirect(path);
}
}
else if (btnsave.Text == "Update")
{
if (drpusertype.SelectedValue == "2")
{
db1.strCommand = "BEGIN TRANSACTION UPDATE LoginTb SET LoginTb.Username = '******'", "''") + "' , LoginTb.Password='******'", "''") + "' FROM LoginTb T1, Hospital T2 WHERE T1.LoginID = T2.LoginID and T1.LoginID = '" +
logidgrid_hidden.Value + "' UPDATE Hospital SET Hospital.HospitalName = '" +
txtname.Text.Trim().Replace("'", "''") + "', Hospital.Address='" +
txtaddress.Text.Trim().Replace("'", "''") + "' FROM LoginTb T1, Hospital T2 WHERE T1.LoginID = T2.LoginID and T1.LoginID = '" + logidgrid_hidden.Value + "' COMMIT";
db1.insertqry();
PopulateHospitalInfo();
clear();
}
else
{
db1.strCommand = "Update LoginTb set Username='******'", "''") + "',Password='******'", "''") + "',Usertype='" +
drpusertype.SelectedValue + "' where LoginID='" + logidgrid_hidden.Value + "'";
db1.insertqry();
PopulateExecutiveInfo();
clear();
}
}
}
protected void btnsave_Click(object sender, EventArgs e)
{
try
{
if (edit_Reportid == "" || edit_Reportid == null)
{
for (int i = 0; i < 2; i++)
{
if (i == 0)
{
flow_hidden.Value = txtsl1.Text.Trim().Replace("'", "''") + "," + txtdut1.Text.Trim().Replace("'", "''") + "," +
txtstd1.Text.Trim().Replace("'", "''") + "," + txtval1.Text.Trim().Replace("'", "''") + "," +
txtalodev1.Text.Trim().Replace("'", "''") + "," + txtrem1.Text.Trim().Replace("'", "''");
db1.strCommand = "insert into Performance_Values(PerfID,Perf_Value,ReportNo) values('" + Session["Perfid55"].ToString() + "','" + flow_hidden.Value + "','" + Session["ReportNo"].ToString() + "')";
db1.insertqry();
}
}
lblmsg.Text = "Data Inserted Successfully";
lblmsg.Style.Add("color", "green");
}
else
{
db1.strCommand = "select ValueID from Performance_Values where Report_info_ID='" + edit_Reportid + "' and PerfID='55'";
DataTable dt_valueid = db1.selecttable();
if (dt_valueid.Rows.Count > 0)
{
for (int i = 0; i < dt_valueid.Rows.Count; i++)
{
if (i == 0)
{
db1.strCommand = "delete from Performance_Values where ValueID='" + dt_valueid.Rows[i]["ValueID"].ToString() + "' and Report_info_ID='" + edit_Reportid + "'";
db1.insertqry();
flow_hidden.Value = txtsl1.Text.Trim().Replace("'", "''") + "," + txtdut1.Text.Trim().Replace("'", "''") + "," +
txtstd1.Text.Trim().Replace("'", "''") + "," + txtval1.Text.Trim().Replace("'", "''") + "," +
txtalodev1.Text.Trim().Replace("'", "''") + "," + txtrem1.Text.Trim().Replace("'", "''");
db1.strCommand = "insert into Performance_Values(PerfID,Perf_Value,Report_info_ID,ReportNo) values('" + Session["Perfid55"].ToString() + "','" + flow_hidden.Value + "','" + edit_Reportid + "','" + Session["ReportNo"].ToString() + "')";
db1.insertqry();
}
}
}
else
{
for (int i = 0; i < 2; i++)
{
if (i == 0)
{
flow_hidden.Value = txtsl1.Text.Trim().Replace("'", "''") + "," + txtdut1.Text.Trim().Replace("'", "''") + "," +
txtstd1.Text.Trim().Replace("'", "''") + "," + txtval1.Text.Trim().Replace("'", "''") + "," +
txtalodev1.Text.Trim().Replace("'", "''") + "," + txtrem1.Text.Trim().Replace("'", "''");
db1.strCommand = "insert into Performance_Values(PerfID,Perf_Value,ReportNo) values('" + Session["Perfid55"].ToString() + "','" + flow_hidden.Value + "','" + Session["ReportNo"].ToString() + "')";
db1.insertqry();
}
}
}
lblmsg.Text = "Data Updated Successfully";
lblmsg.Style.Add("color", "green");
}
}
catch (Exception ex)
{
lblmsg.Text = "Data not Inserted Successfully " + ex;
lblmsg.Style.Add("color", "red");
}
}
protected void btnsave_Click(object sender, EventArgs e)
{
try
{
if (edit_Reportid == "" || edit_Reportid == null)
{
for (int i = 0; i < 7; i++)
{
if (i == 0)
{
syntime_hidden.Value = txtlam1.Text.Trim();
db1.strCommand = "insert into Performance_Values(PerfID,Perf_Value,ReportNo) values('" + Session["Perfid56"].ToString() + "','" + syntime_hidden.Value + "','" + Session["ReportNo"].ToString() + "')";
db1.insertqry();
}
if (i == 1)
{
syntime_hidden.Value = txtlam2.Text.Trim();
db1.strCommand = "insert into Performance_Values(PerfID,Perf_Value,ReportNo) values('" + Session["Perfid56"].ToString() + "','" + syntime_hidden.Value + "','" + Session["ReportNo"].ToString() + "')";
db1.insertqry();
}
if (i == 2)
{
syntime_hidden.Value = txtlam3.Text.Trim();
db1.strCommand = "insert into Performance_Values(PerfID,Perf_Value,ReportNo) values('" + Session["Perfid56"].ToString() + "','" + syntime_hidden.Value + "','" + Session["ReportNo"].ToString() + "')";
db1.insertqry();
}
if (i == 3)
{
syntime_hidden.Value = txtlam4.Text.Trim();
db1.strCommand = "insert into Performance_Values(PerfID,Perf_Value,ReportNo) values('" + Session["Perfid56"].ToString() + "','" + syntime_hidden.Value + "','" + Session["ReportNo"].ToString() + "')";
db1.insertqry();
}
if (i == 4)
{
syntime_hidden.Value = txtlam5.Text.Trim();
db1.strCommand = "insert into Performance_Values(PerfID,Perf_Value,ReportNo) values('" + Session["Perfid56"].ToString() + "','" + syntime_hidden.Value + "','" + Session["ReportNo"].ToString() + "')";
db1.insertqry();
}
if (i == 5)
{
syntime_hidden.Value = txtlam6.Text.Trim();
db1.strCommand = "insert into Performance_Values(PerfID,Perf_Value,ReportNo) values('" + Session["Perfid56"].ToString() + "','" + syntime_hidden.Value + "','" + Session["ReportNo"].ToString() + "')";
db1.insertqry();
}
if (i == 6)
{
syntime_hidden.Value = txtlam7.Text.Trim();
db1.strCommand = "insert into Performance_Values(PerfID,Perf_Value,ReportNo) values('" + Session["Perfid56"].ToString() + "','" + syntime_hidden.Value + "','" + Session["ReportNo"].ToString() + "')";
db1.insertqry();
}
}
lblmsg.Text = "Data Inserted Successfully";
lblmsg.Style.Add("color", "green");
}
else
{
db1.strCommand = "select ValueID from Performance_Values where Report_info_ID='" + edit_Reportid + "' and PerfID='56'";
DataTable dt_valueid = db1.selecttable();
if (dt_valueid.Rows.Count > 0)
{
for (int i = 0; i < 7; i++)
{
if (i == 0)
{
db1.strCommand = "delete from Performance_Values where ValueID='" + dt_valueid.Rows[i]["ValueID"].ToString() + "' and Report_info_ID='" + edit_Reportid + "'";
db1.insertqry();
syntime_hidden.Value = txtlam1.Text.Trim();
db1.strCommand = "insert into Performance_Values(PerfID,Perf_Value,ReportNo) values('" + Session["Perfid56"].ToString() + "','" + syntime_hidden.Value + "','" + Session["ReportNo"].ToString() + "')";
db1.insertqry();
}
if (i == 1)
{
db1.strCommand = "delete from Performance_Values where ValueID='" + dt_valueid.Rows[i]["ValueID"].ToString() + "' and Report_info_ID='" + edit_Reportid + "'";
db1.insertqry();
syntime_hidden.Value = txtlam2.Text.Trim();
db1.strCommand = "insert into Performance_Values(PerfID,Perf_Value,ReportNo) values('" + Session["Perfid56"].ToString() + "','" + syntime_hidden.Value + "','" + Session["ReportNo"].ToString() + "')";
db1.insertqry();
}
if (i == 2)
{
db1.strCommand = "delete from Performance_Values where ValueID='" + dt_valueid.Rows[i]["ValueID"].ToString() + "' and Report_info_ID='" + edit_Reportid + "'";
db1.insertqry();
syntime_hidden.Value = txtlam3.Text.Trim();
db1.strCommand = "insert into Performance_Values(PerfID,Perf_Value,ReportNo) values('" + Session["Perfid56"].ToString() + "','" + syntime_hidden.Value + "','" + Session["ReportNo"].ToString() + "')";
db1.insertqry();
}
if (i == 3)
{
db1.strCommand = "delete from Performance_Values where ValueID='" + dt_valueid.Rows[i]["ValueID"].ToString() + "' and Report_info_ID='" + edit_Reportid + "'";
db1.insertqry();
syntime_hidden.Value = txtlam4.Text.Trim();
db1.strCommand = "insert into Performance_Values(PerfID,Perf_Value,ReportNo) values('" + Session["Perfid56"].ToString() + "','" + syntime_hidden.Value + "','" + Session["ReportNo"].ToString() + "')";
db1.insertqry();
}
if (i == 4)
{
db1.strCommand = "delete from Performance_Values where ValueID='" + dt_valueid.Rows[i]["ValueID"].ToString() + "' and Report_info_ID='" + edit_Reportid + "'";
db1.insertqry();
syntime_hidden.Value = txtlam5.Text.Trim();
db1.strCommand = "insert into Performance_Values(PerfID,Perf_Value,ReportNo) values('" + Session["Perfid56"].ToString() + "','" + syntime_hidden.Value + "','" + Session["ReportNo"].ToString() + "')";
db1.insertqry();
}
if (i == 5)
{
db1.strCommand = "delete from Performance_Values where ValueID='" + dt_valueid.Rows[i]["ValueID"].ToString() + "' and Report_info_ID='" + edit_Reportid + "'";
db1.insertqry();
syntime_hidden.Value = txtlam6.Text.Trim();
db1.strCommand = "insert into Performance_Values(PerfID,Perf_Value,ReportNo) values('" + Session["Perfid56"].ToString() + "','" + syntime_hidden.Value + "','" + Session["ReportNo"].ToString() + "')";
db1.insertqry();
}
if (i == 6)
{
db1.strCommand = "delete from Performance_Values where ValueID='" + dt_valueid.Rows[i]["ValueID"].ToString() + "' and Report_info_ID='" + edit_Reportid + "'";
db1.insertqry();
syntime_hidden.Value = txtlam7.Text.Trim();
db1.strCommand = "insert into Performance_Values(PerfID,Perf_Value,ReportNo) values('" + Session["Perfid56"].ToString() + "','" + syntime_hidden.Value + "','" + Session["ReportNo"].ToString() + "')";
db1.insertqry();
}
}
}
else
{
for (int i = 0; i < 7; i++)
{
if (i == 0)
{
syntime_hidden.Value = txtlam1.Text.Trim();
db1.strCommand = "insert into Performance_Values(PerfID,Perf_Value,ReportNo) values('" + Session["Perfid56"].ToString() + "','" + syntime_hidden.Value + "','" + Session["ReportNo"].ToString() + "')";
db1.insertqry();
}
if (i == 1)
{
syntime_hidden.Value = txtlam2.Text.Trim();
db1.strCommand = "insert into Performance_Values(PerfID,Perf_Value,ReportNo) values('" + Session["Perfid56"].ToString() + "','" + syntime_hidden.Value + "','" + Session["ReportNo"].ToString() + "')";
db1.insertqry();
}
if (i == 2)
{
syntime_hidden.Value = txtlam3.Text.Trim();
db1.strCommand = "insert into Performance_Values(PerfID,Perf_Value,ReportNo) values('" + Session["Perfid56"].ToString() + "','" + syntime_hidden.Value + "','" + Session["ReportNo"].ToString() + "')";
db1.insertqry();
}
if (i == 3)
{
syntime_hidden.Value = txtlam4.Text.Trim();
db1.strCommand = "insert into Performance_Values(PerfID,Perf_Value,ReportNo) values('" + Session["Perfid56"].ToString() + "','" + syntime_hidden.Value + "','" + Session["ReportNo"].ToString() + "')";
db1.insertqry();
}
if (i == 4)
{
syntime_hidden.Value = txtlam5.Text.Trim();
db1.strCommand = "insert into Performance_Values(PerfID,Perf_Value,ReportNo) values('" + Session["Perfid56"].ToString() + "','" + syntime_hidden.Value + "','" + Session["ReportNo"].ToString() + "')";
db1.insertqry();
}
if (i == 5)
{
syntime_hidden.Value = txtlam6.Text.Trim();
db1.strCommand = "insert into Performance_Values(PerfID,Perf_Value,ReportNo) values('" + Session["Perfid56"].ToString() + "','" + syntime_hidden.Value + "','" + Session["ReportNo"].ToString() + "')";
db1.insertqry();
}
if (i == 6)
{
syntime_hidden.Value = txtlam7.Text.Trim();
db1.strCommand = "insert into Performance_Values(PerfID,Perf_Value,ReportNo) values('" + Session["Perfid56"].ToString() + "','" + syntime_hidden.Value + "','" + Session["ReportNo"].ToString() + "')";
db1.insertqry();
}
}
}
lblmsg.Text = "Data Updated Successfully";
lblmsg.Style.Add("color", "green");
}
}
catch (Exception ex)
{
lblmsg.Text = "Data not Inserted Successfully" + ex;
lblmsg.Style.Add("color", "red");
}
}
public void BindValue()
{
db1.strCommand = "select * from Performance_Values where PerfID='5'";
DataTable dt = db1.selecttable();
int count = dt.Rows.Count;
StringBuilder sb = new StringBuilder();
StringBuilder sbid = new StringBuilder();
string val = "", valid = "";;
string[] value = { }, valueid = { };
string[] splitarray = { };
if (dt.Rows.Count > 0)
{
for (int i = 0; i < count; i++)
{
sb.Append(dt.Rows[i]["Perf_Value"].ToString() + " ");
sbid.Append(dt.Rows[i]["ValueID"].ToString() + " ");
}
val = sb.ToString();
valid = sbid.ToString();
value = val.Split();
valueid = valid.Split();
int validcount = valueid.Count();
int valcount = value.Count();
for (int i = 0; i < valcount - 1; i++)
{
if (i == 0)
{
string value_1 = value[i].ToString();
string valueid_1 = valueid[i].ToString();
string[] value_1array = value_1.Split(',');
int valid_1count = value_1array.Count();
for (int j = 0; j < valid_1count - 1; j++)
{
db1.strCommand = "insert into perfvaluesplit(splitvalues,ValueID)values('" + value_1array[j].ToString() + "','" + valueid_1 + "')";
db1.insertqry();
}
}
if (i == 1)
{
string value_2 = value[i].ToString();
string valueid_2 = valueid[i].ToString();
string[] value_2array = value_2.Split(',');
int valid_2count = value_2array.Count();
for (int j = 0; j < valid_2count - 1; j++)
{
db1.strCommand = "insert into perfvaluesplit(splitvalues,ValueID)values('" + value_2array[j].ToString() + "','" + valueid_2 + "')";
db1.insertqry();
}
}
if (i == 2)
{
string value_3 = value[i].ToString();
string valueid_3 = valueid[i].ToString();
string[] value_3array = value_3.Split(',');
int valid_3count = value_3array.Count();
for (int j = 0; j < valid_3count - 1; j++)
{
db1.strCommand = "insert into perfvaluesplit(splitvalues,ValueID)values('" + value_3array[j].ToString() + "','" + valueid_3 + "')";
db1.insertqry();
}
}
if (i == 3)
{
string value_4 = value[i].ToString();
string valueid_4 = valueid[i].ToString();
string[] value_4array = value_4.Split(',');
int valid_4count = value_4array.Count();
for (int j = 0; j < valid_4count - 1; j++)
{
db1.strCommand = "insert into perfvaluesplit(splitvalues,ValueID)values('" + value_4array[j].ToString() + "','" + valueid_4 + "')";
db1.insertqry();
}
}
if (i == 4)
{
string value_5 = value[i].ToString();
string valueid_5 = valueid[i].ToString();
string[] value_5array = value_5.Split(',');
int valid_5count = value_5array.Count();
for (int j = 0; j < valid_5count - 1; j++)
{
db1.strCommand = "insert into perfvaluesplit(splitvalues,ValueID)values('" + value_5array[j].ToString() + "','" + valueid_5 + "')";
db1.insertqry();
}
}
}
}
}
public void InsertReportinfo()
{
db1.strCommand = "insert into Report_Info(ReportNo,Date_of_calibration,Calibration_Due_on,PerfID) values('" + txtreportno.Text + "','" + txtdateofcalib.Text + "','" + txtduedate.Text + "','" + ddperftestname.SelectedValue + "')";
db1.insertqry();
}
protected void btnsave_Click(object sender, EventArgs e)
{
try
{
if (edit_Reportid == "" || edit_Reportid == null)
{
for (int i = 0; i < 2; i++)
{
if (i == 0)
{
tempmeasure_deepfreezer.Value = txtsl1.Text.Trim().Replace("'", "''") + "," + txttempset1.Text.Trim().Replace("'", "''") + "," +
txttp1_1.Text.Trim().Replace("'", "''") + "," + txttp2_1.Text.Trim().Replace("'", "''") + "," + txttp3_1.Text.Trim().Replace("'", "''") + "," +
txtmean1.Text.Trim().Replace("'", "''") + "," +
txtdev1.Text.Trim().Replace("'", "''") + "," + txtspec1.Text.Trim().Replace("'", "''") + "," + txtrem1.Text.Trim().Replace("'", "''");
db1.strCommand = "insert into Performance_Values(PerfID,Perf_Value,ReportNo) values('" + Session["Perfid57"].ToString() + "','" + tempmeasure_deepfreezer.Value + "','" + Session["ReportNo"].ToString() + "')";
db1.insertqry();
}
if (i == 1)
{
tempmeasure_deepfreezer.Value = txtsl2.Text.Trim().Replace("'", "''") + "," + txttempset2.Text.Trim().Replace("'", "''") + "," +
txttp1_2.Text.Trim().Replace("'", "''") + "," + txttp2_2.Text.Trim().Replace("'", "''") + "," + txttp3_2.Text.Trim().Replace("'", "''") + "," +
txtmean2.Text.Trim().Replace("'", "''") + "," +
txtdev2.Text.Trim().Replace("'", "''") + "," + txtspec2.Text.Trim().Replace("'", "''") + "," + txtrem2.Text.Trim().Replace("'", "''");
db1.strCommand = "insert into Performance_Values(PerfID,Perf_Value,ReportNo) values('" + Session["Perfid57"].ToString() + "','" + tempmeasure_deepfreezer.Value + "','" + Session["ReportNo"].ToString() + "')";
db1.insertqry();
}
}
lblmsg.Text = "Data Inserted Successfully";
lblmsg.Style.Add("color", "green");
}
else
{
db1.strCommand = "select ValueID from Performance_Values where Report_info_ID='" + edit_Reportid + "' and PerfID='57'";
DataTable dt_valueid = db1.selecttable();
if (dt_valueid.Rows.Count > 0)
{
for (int i = 0; i < 2; i++)
{
if (i == 0)
{
db1.strCommand = "delete from Performance_Values where ValueID='" + dt_valueid.Rows[i]["ValueID"].ToString() + "' and Report_info_ID='" + edit_Reportid + "'";
db1.insertqry();
tempmeasure_deepfreezer.Value = txtsl1.Text.Trim().Replace("'", "''") + "," + txttempset1.Text.Trim().Replace("'", "''") + "," +
txttp1_1.Text.Trim().Replace("'", "''") + "," + txttp2_1.Text.Trim().Replace("'", "''") + "," + txttp3_1.Text.Trim().Replace("'", "''") + "," +
txtmean1.Text.Trim().Replace("'", "''") + "," +
txtdev1.Text.Trim().Replace("'", "''") + "," + txtspec1.Text.Trim().Replace("'", "''") + "," + txtrem1.Text.Trim().Replace("'", "''");
db1.strCommand = "insert into Performance_Values(PerfID,Perf_Value,Report_info_ID,ReportNo) values('" + Session["Perfid57"].ToString() + "','" + tempmeasure_deepfreezer.Value + "','" + edit_Reportid + "','" + Session["ReportNo"].ToString() + "')";
db1.insertqry();
}
if (i == 1)
{
tempmeasure_deepfreezer.Value = txtsl2.Text.Trim().Replace("'", "''") + "," + txttempset2.Text.Trim().Replace("'", "''") + "," +
txttp1_2.Text.Trim().Replace("'", "''") + "," + txttp2_2.Text.Trim().Replace("'", "''") + "," + txttp3_2.Text.Trim().Replace("'", "''") + "," +
txtmean2.Text.Trim().Replace("'", "''") + "," +
txtdev2.Text.Trim().Replace("'", "''") + "," + txtspec2.Text.Trim().Replace("'", "''") + "," + txtrem2.Text.Trim().Replace("'", "''");
db1.strCommand = "insert into Performance_Values(PerfID,Perf_Value,ReportNo) values('" + Session["Perfid57"].ToString() + "','" + tempmeasure_deepfreezer.Value + "','" + Session["ReportNo"].ToString() + "')";
db1.insertqry();
}
}
}
else
{
for (int i = 0; i < 2; i++)
{
if (i == 0)
{
tempmeasure_deepfreezer.Value = txtsl1.Text.Trim().Replace("'", "''") + "," + txttempset1.Text.Trim().Replace("'", "''") + "," +
txttp1_1.Text.Trim().Replace("'", "''") + "," + txttp2_1.Text.Trim().Replace("'", "''") + "," + txttp3_1.Text.Trim().Replace("'", "''") + "," +
txtmean1.Text.Trim().Replace("'", "''") + "," +
txtdev1.Text.Trim().Replace("'", "''") + "," + txtspec1.Text.Trim().Replace("'", "''") + "," + txtrem1.Text.Trim().Replace("'", "''");
db1.strCommand = "insert into Performance_Values(PerfID,Perf_Value,ReportNo) values('" + Session["Perfid57"].ToString() + "','" + tempmeasure_deepfreezer.Value + "','" + Session["ReportNo"].ToString() + "')";
db1.insertqry();
}
if (i == 1)
{
tempmeasure_deepfreezer.Value = txtsl2.Text.Trim().Replace("'", "''") + "," + txttempset2.Text.Trim().Replace("'", "''") + "," +
txttp1_2.Text.Trim().Replace("'", "''") + "," + txttp2_2.Text.Trim().Replace("'", "''") + "," + txttp3_2.Text.Trim().Replace("'", "''") + "," +
txtmean2.Text.Trim().Replace("'", "''") + "," +
txtdev2.Text.Trim().Replace("'", "''") + "," + txtspec2.Text.Trim().Replace("'", "''") + "," + txtrem2.Text.Trim().Replace("'", "''");
db1.strCommand = "insert into Performance_Values(PerfID,Perf_Value,ReportNo) values('" + Session["Perfid57"].ToString() + "','" + tempmeasure_deepfreezer.Value + "','" + Session["ReportNo"].ToString() + "')";
db1.insertqry();
}
}
}
lblmsg.Text = "Data Updated Successfully";
lblmsg.Style.Add("color", "green");
}
}
catch
{
lblmsg.Text = "Data not Inserted Successfully";
lblmsg.Style.Add("color", "red");
}
}
