protected void btnSave_Click(object sender, EventArgs e)
{
string id = string.Format("Id: {0} Uri: {1}", Guid.NewGuid(), HttpContext.Current.Request.Url);
using (Utils utility = new Utils())
{
utility.MethodStart(id, System.Reflection.MethodBase.GetCurrentMethod());
}
try
{
ArrayList arrCases = new ArrayList();
for (int i = 0; i < grdCaseMaster.Items.Count; i++)
{
CheckBox chk = (CheckBox)grdCaseMaster.Items[i].Cells[0].FindControl("chkSelect");
if (chk.Checked)
{
EmployerVisitDO objCases = new EmployerVisitDO();
objCases.CaseID = grdCaseMaster.Items[i].Cells[2].Text.ToString();
objCases.CompanyID = txtCompanyID.Text;
objCases.UserID = ((Bill_Sys_UserObject)this.Session["USER_OBJECT"]).SZ_USER_ID.ToString();
objCases.EmploerID = extddlEmployer.Text;
objCases.VisitDate = txtAppointdate.Text;
objCases.EmployerVisitProcedure = new List <EmployerVisitProcedure>();
foreach (ListItem lstitem in this.lstProcedureCode.Items)
{
if (lstitem.Selected)
{
string lstVal = lstitem.Value;
string[] spiltVal = lstVal.Split('~');
EmployerVisitProcedure objEmployerVisitProcedure = new EmployerVisitProcedure();
objEmployerVisitProcedure.ProcedureCode = spiltVal[0].ToString();
objEmployerVisitProcedure.ProcedureGroupId = spiltVal[1].ToString();
objCases.EmployerVisitProcedure.Add(objEmployerVisitProcedure);
}
}
arrCases.Add(objCases);
}
}
EmployerBO objEmployerBO = new EmployerBO();
string returnSave = objEmployerBO.SaveVisit(arrCases);
if (returnSave != "")
{
this.usrMessage.PutMessage("Visit save Sucessfully.");
this.usrMessage.SetMessageType(UserControl_ErrorMessageControl.DisplayType.Type_UserMessage);
this.usrMessage.Show();
}
else
{
this.usrMessage.PutMessage("can not save the visit");
this.usrMessage.SetMessageType(UserControl_ErrorMessageControl.DisplayType.Type_ErrorMessage);
this.usrMessage.Show();
}
}
catch (Exception ex)
{
Elmah.ErrorSignal.FromCurrentContext().Raise(ex);
using (Utils utility = new Utils())
{
utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod());
}
string str2 = "Error Request=" + id + ".Please share with Technical support.";
base.Response.Redirect("Bill_Sys_ErrorPage.aspx?ErrMsg=" + str2);
}
//Method End
using (Utils utility = new Utils())
{
utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod());
}
}
protected void btnSave_Click(object sender, EventArgs e)
{//Logging Start
string id = string.Format("Id: {0} Uri: {1}", Guid.NewGuid(), HttpContext.Current.Request.Url);
using (Utils utility = new Utils())
{
utility.MethodStart(id, System.Reflection.MethodBase.GetCurrentMethod());
}
try
{
ArrayList arrayLists = new ArrayList();
for (int i = 0; i < this.grdCaseMaster.Items.Count; i++)
{
if (((CheckBox)this.grdCaseMaster.Items[i].Cells[0].FindControl("chkSelect")).Checked)
{
EmployerVisitDO employerVisitDO = new EmployerVisitDO()
{
CaseID = this.grdCaseMaster.Items[i].Cells[2].Text.ToString(),
CompanyID = this.txtCompanyID.Text,
UserID = ((Bill_Sys_UserObject)this.Session["USER_OBJECT"]).SZ_USER_ID.ToString(),
EmploerID = this.extddlEmployer.Text,
VisitDate = this.txtAppointdate.Text,
EmployerVisitProcedure = new List <EmployerVisitProcedure>()
};
foreach (ListItem item in this.lstProcedureCode.Items)
{
if (!item.Selected)
{
continue;
}
string value = item.Value;
string[] strArrays = value.Split(new char[] { '~' });
EmployerVisitProcedure employerVisitProcedure = new EmployerVisitProcedure()
{
ProcedureCode = strArrays[0].ToString(),
ProcedureGroupId = strArrays[1].ToString()
};
employerVisitDO.EmployerVisitProcedure.Add(employerVisitProcedure);
}
arrayLists.Add(employerVisitDO);
}
}
if ((new EmployerBO()).SaveVisit(arrayLists) == "")
{
this.usrMessage.PutMessage("can not save the visit");
this.usrMessage.SetMessageType(UserControl_ErrorMessageControl.DisplayType.Type_ErrorMessage);
this.usrMessage.Show();
}
else
{
this.usrMessage.PutMessage("Visit save Sucessfully.");
this.usrMessage.SetMessageType(UserControl_ErrorMessageControl.DisplayType.Type_UserMessage);
this.usrMessage.Show();
}
}
catch (Exception ex)
{
Elmah.ErrorSignal.FromCurrentContext().Raise(ex);
using (Utils utility = new Utils())
{
utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod());
}
string str2 = "Error Request=" + id + ".Please share with Technical support.";
base.Response.Redirect("../Bill_Sys_ErrorPage.aspx?ErrMsg=" + str2);
}
//Method End
using (Utils utility = new Utils())
{
utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod());
}
}
public string SaveVisit(ArrayList arrCases)
{
string returnSave = "";
sqlCon = new SqlConnection(strConn);
sqlCon.Open();
SqlTransaction tr;
tr = sqlCon.BeginTransaction();
try
{
for (int i = 0; i < arrCases.Count; i++)
{
EmployerVisitDO objEmployerVisitDO = new EmployerVisitDO();
objEmployerVisitDO = (EmployerVisitDO)arrCases[i];
sqlCmd = new SqlCommand("SP_SAVE_EMPLOYER_VISIT", sqlCon);
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.Transaction = tr;
sqlCmd.Parameters.AddWithValue("@sz_case_id", objEmployerVisitDO.CaseID);
sqlCmd.Parameters.AddWithValue("@dt_visit_date", objEmployerVisitDO.VisitDate);
sqlCmd.Parameters.AddWithValue("@sz_company_id", objEmployerVisitDO.CompanyID);
sqlCmd.Parameters.AddWithValue("@sz_user_id", objEmployerVisitDO.UserID);
sqlCmd.Parameters.AddWithValue("@sz_employer_id", objEmployerVisitDO.EmploerID);
SqlDataReader dr = sqlCmd.ExecuteReader();
string visitID = "";
while (dr.Read())
{
visitID = dr[0].ToString();
}
dr.Close();
for (int j = 0; j < objEmployerVisitDO.EmployerVisitProcedure.Count; j++)
{
EmployerVisitProcedure objEmployerVisitProcedure = objEmployerVisitDO.EmployerVisitProcedure[j];
sqlCmd = new SqlCommand("SP_SAVE_VISIT_PROCEDURE_CODE", sqlCon);
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.Transaction = tr;
sqlCmd.Parameters.AddWithValue("@sz_case_id", objEmployerVisitDO.CaseID);
sqlCmd.Parameters.AddWithValue("@i_visit_id", visitID);
sqlCmd.Parameters.AddWithValue("@sz_company_id", objEmployerVisitDO.CompanyID);
sqlCmd.Parameters.AddWithValue("@sz_user_id", objEmployerVisitDO.UserID);
sqlCmd.Parameters.AddWithValue("@sz_employer_id", objEmployerVisitDO.EmploerID);
sqlCmd.Parameters.AddWithValue("@i_procedure_id", objEmployerVisitProcedure.ProcedureCode);
sqlCmd.Parameters.AddWithValue("@sz_procedure_group_id", objEmployerVisitProcedure.ProcedureGroupId);
sqlCmd.ExecuteNonQuery();
}
}
tr.Commit();
returnSave = "Save";
}
catch (Exception ex)
{
Elmah.ErrorSignal.FromCurrentContext().Raise(ex);
returnSave = "";
tr.Rollback();
}
finally
{
if (sqlCon.State == ConnectionState.Open)
{
sqlCon.Close();
}
}
return(returnSave);
}
