protected void btn_add_Click(object sender, EventArgs e)
{
try
{
ds_analytics.m_labsDataTable lab_dt = new ds_analytics.m_labsDataTable();
ds_analytics.m_labsRow lab_row = lab_dt.Newm_labsRow();
lab_row.labname = tb_labname.Text;
lab_row.address = tb_address.Text;
lab_row.city = tb_city.Text;
lab_row.labtype = tb_type.Text;
lab_row.auditstatus = tb_auditstatus.Text;
lab_row.fax = tb_fax.Text;
lab_row.contact_person = tb_cp1.Text;
lab_row.key_acc_person = tb_cp2.Text;
lab_row.email1 = tb_email1.Text;
lab_row.email2 = tb_email2.Text;
lab_row.mbl1 = tb_mbl1.Text;
lab_row.mbl2 = tb_mbl2.Text;
lab_row.phn1 = tb_phn1.Text;
lab_row.phn2 = tb_phn2.Text;
lab_row.isactive = cb_isactive.Checked;
lab_row = m_labs.GetLabRowWithNull(lab_row);
m_labs.insert(lab_row);
string url = "labs.aspx";
ClientScript.RegisterStartupScript(this.GetType(), "callfunction", "alert('Record Added Successfully.');window.location.href = '" + url + "';", true);
}
catch (Exception ex)
{
ClientScript.RegisterStartupScript(this.GetType(), "error", "<script>alert('Error in adding record.');</script>");
}
}
protected void btn_update_Click(object sender, EventArgs e)
{
ds_analytics.m_labsRow lab_row = ((ds_analytics.m_labsRow)(ViewState["lab_row"]));
lab_row.labname = tb_labname.Text;
lab_row.address = tb_address.Text;
lab_row.city = tb_city.Text;
lab_row.labtype = tb_type.Text;
lab_row.auditstatus = tb_auditstatus.Text;
lab_row.fax = tb_fax.Text;
lab_row.contact_person = tb_cp1.Text;
lab_row.key_acc_person = tb_cp2.Text;
lab_row.email1 = tb_email1.Text;
lab_row.email2 = tb_email2.Text;
lab_row.mbl1 = tb_mbl1.Text;
lab_row.mbl2 = tb_mbl2.Text;
lab_row.phn1 = tb_phn1.Text;
lab_row.phn2 = tb_phn2.Text;
lab_row.isactive = cb_isactive.Checked;
m_labs.update(m_labs.GetLabRowWithNull(lab_row));
ds_analytics.m_labsDataTable lab_dt = m_labs.getAllLabs();
gv_labs.DataSource = lab_dt;
gv_labs.DataBind();
ViewState["dtStored"] = lab_dt;
Reset();
}
protected void btn_search_Click(object sender, EventArgs e)
{
ds_analytics.m_labsDataTable lab_dt = m_labs.getAllLabsByName(tb_labname_search.Text);
gv_labs.DataSource = lab_dt;
gv_labs.DataBind();
ViewState["dtStored"] = lab_dt;
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
((MenuItem)((Menu)Master.FindControl("Menu1")).FindItem("Labs")).Selected = true;
ViewState["SortOrder"] = " ASC";
ds_analytics.m_labsDataTable lab_dt = m_labs.getAllLabs();
gv_labs.DataSource = lab_dt;
gv_labs.DataBind();
ViewState["dtStored"] = lab_dt;
btn_add.Visible = true;
}
else
{
}
}
protected void imgbtn_Edit_Click(object sender, ImageClickEventArgs e)
{
GridViewRow gv_row = (GridViewRow)((sender as ImageButton).NamingContainer);
long labid = Convert.ToInt64(gv_labs.DataKeys[gv_row.RowIndex].Value);
ds_analytics.m_labsDataTable thislab_dt = m_labs.getLabByLabid(labid);
if (thislab_dt.Rows.Count > 0)
{
ds_analytics.m_labsRow lab_row = thislab_dt[0];
tb_labname.Text = lab_row.labname;
tb_address.Text = lab_row.address;
tb_city.Text = lab_row.city;
tb_type.Text = lab_row.labtype;
tb_auditstatus.Text = lab_row.auditstatus;
tb_fax.Text = lab_row.fax;
tb_cp1.Text = lab_row.contact_person;
tb_cp2.Text = lab_row.key_acc_person;
tb_email1.Text = lab_row.email1;
tb_email2.Text = lab_row.email2;
tb_mbl1.Text = lab_row.mbl1;
tb_mbl2.Text = lab_row.mbl2;
tb_phn1.Text = lab_row.phn1;
tb_phn2.Text = lab_row.phn2;
cb_isactive.Checked = lab_row.isactive;
ViewState["lab_row"] = lab_row;
btn_add.Visible = false;
btn_update.Visible = true;
btn_cancel.Visible = true;
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "error", "<script>alert('Error in getting Lab details.');</script>");
}
}
