protected void btnDelete_Click(object sender, EventArgs e)
{
ArrayList arrObj = new ArrayList();
for (int i = 0; i < grdDocs.Items.Count; i++)
{
CheckBox chk = (CheckBox)grdDocs.Items[i].FindControl("ChkDelete");
if (chk.Checked)
{
EmployerVisitDO objEmployerVisitDO = new EmployerVisitDO();
objEmployerVisitDO.CompanyID = txtCompanyID.Text;
objEmployerVisitDO.ImageId = grdDocs.Items[i].Cells[0].Text.ToString();
objEmployerVisitDO.VisitId = grdDocs.Items[i].Cells[3].Text.ToString();
arrObj.Add(objEmployerVisitDO);
}
}
EmployerBO objEmployerBO = new EmployerBO();
string sReturn = objEmployerBO.DeleteDocs(arrObj);
if (sReturn == "deleted")
{
lblMsg.Text = "Document deleted successfully";
}
else
{
lblMsg.Text = sReturn;
}
lblMsg.Visible = true;
BindData();
}
public DataSet GetDocumnets(EmployerVisitDO EmployerVisitDO)
{
sqlCon = new SqlConnection(strConn);
try
{
sqlCon.Open();
sqlCmd = new SqlCommand("proc_view_jfk_visit_document", sqlCon);
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.Parameters.AddWithValue("@i_visit_id", EmployerVisitDO.VisitId);
sqlCmd.Parameters.AddWithValue("@sz_company_id", EmployerVisitDO.CompanyID);
sqlda = new SqlDataAdapter(sqlCmd);
ds = new DataSet();
sqlda.Fill(ds);
}
catch (SqlException ex)
{
Elmah.ErrorSignal.FromCurrentContext().Raise(ex);
}
finally
{
if (sqlCon.State == ConnectionState.Open)
{
sqlCon.Close();
}
}
return(ds);
}
protected void UploadButton_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
{
EmployerVisitDO objEmployerVisitDO = new EmployerVisitDO();
objEmployerVisitDO.CaseID = txtCaseID.Text;
objEmployerVisitDO.CompanyID = txtCompanyID.Text;
objEmployerVisitDO.CompanyName = txtCompanyName.Text;
objEmployerVisitDO.UserID = txtUserID.Text;
objEmployerVisitDO.UserName = txtUserName.Text;
objEmployerVisitDO.VisitId = txtVisitId.Text;
objEmployerVisitDO.FileName = ReportUpload.FileName;
EmployerBO objEmployerBO = new EmployerBO();
string sPath = objEmployerBO.SaveVisitDocument(objEmployerVisitDO);
string sBasePath = ConfigurationManager.AppSettings["BASEPATH"].ToString();
if (!Directory.Exists(sBasePath + sPath))
{
Directory.CreateDirectory(sBasePath + sPath);
}
if (sPath != "")
{
ReportUpload.SaveAs(sBasePath + sPath + ReportUpload.FileName);
lblmsg.Text = "File saved successfully";
lblmsg.Visible = true;
}
else
{
lblmsg.Text = "unable to save file";
lblmsg.Visible = true;
}
}
catch (Exception ex)
{
lblmsg.Text = ex.ToString();
lblmsg.Visible = true;
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 BindGrid()
{//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
{
EmployerVisitDO objEmployerdo = new EmployerVisitDO();
objEmployerdo.EmploerID = extddlEmployer.Text;
objEmployerdo.CompanyID = txtCompanyID.Text;
string cases = "";
if (txtCaseNo.Text != "")
{
string[] spiltcases = txtCaseNo.Text.Trim().Split(',');
for (int i = 0; i < spiltcases.Length; i++)
{
if (cases == "")
{
cases = "'" + spiltcases[i].ToString() + "'";
}
else
{
cases += ",'" + spiltcases[i].ToString() + "'";
}
}
}
objEmployerdo.CaseNO = cases;
objEmployerdo.From_Visit_Date = txtFromDate.Text;
objEmployerdo.To_Visit_Date = txtToDate.Text;
EmployerBO objBillSysPatientBO = new EmployerBO();
DataSet ds = objBillSysPatientBO.GetVisit(objEmployerdo);
grdVisits.DataSource = ds;
grdVisits.DataBind();
}
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 void BindData()
{
EmployerVisitDO objEmployerVisitDO = new EmployerVisitDO();
objEmployerVisitDO.CompanyID = txtCompanyID.Text;
objEmployerVisitDO.VisitId = txtvisitId.Text;
EmployerBO objEmployerBO = new EmployerBO();
DataSet ds = objEmployerBO.GetDocumnets(objEmployerVisitDO);
grdDocs.DataSource = ds;
grdDocs.DataBind();
}
public string SaveVisitDocument(EmployerVisitDO objEmployerVisitDO)
{
string visitID = "";
sqlCon = new SqlConnection(strConn);
sqlCon.Open();
SqlTransaction tr;
tr = sqlCon.BeginTransaction();
try
{
sqlCmd = new SqlCommand("proc_save_jfk_visit_documents", sqlCon);
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.Transaction = tr;
sqlCmd.CommandTimeout = 0;
sqlCmd.Parameters.AddWithValue("@SZ_CASE_ID", objEmployerVisitDO.CaseID);
sqlCmd.Parameters.AddWithValue("@SZ_COMPANY_ID", objEmployerVisitDO.CompanyID);
sqlCmd.Parameters.AddWithValue("@SZ_COMPANY_NAME", objEmployerVisitDO.CompanyName);
sqlCmd.Parameters.AddWithValue("@SZ_USER_ID", objEmployerVisitDO.UserID);
sqlCmd.Parameters.AddWithValue("@SZ_USER_NAME", objEmployerVisitDO.UserName);
sqlCmd.Parameters.AddWithValue("@SZ_FILE_NAME", objEmployerVisitDO.FileName);
sqlCmd.Parameters.AddWithValue("@I_visit_id", objEmployerVisitDO.VisitId);
SqlDataReader dr = sqlCmd.ExecuteReader();
while (dr.Read())
{
visitID = dr[0].ToString();
}
dr.Close();
tr.Commit();
}
catch (Exception ex)
{
Elmah.ErrorSignal.FromCurrentContext().Raise(ex);
visitID = "";
tr.Rollback();
}
finally
{
if (sqlCon.State == ConnectionState.Open)
{
sqlCon.Close();
}
}
return(visitID);
}
public string DeleteDocs(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("proc_delete_jfk_visit_document", sqlCon);
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.Transaction = tr;
sqlCmd.Parameters.AddWithValue("@sz_company_id", objEmployerVisitDO.CompanyID);
sqlCmd.Parameters.AddWithValue("@i_visit_id", objEmployerVisitDO.VisitId);
sqlCmd.Parameters.AddWithValue("@i_image_id", objEmployerVisitDO.ImageId);
sqlCmd.ExecuteNonQuery();
}
tr.Commit();
returnSave = "deleted";
}
catch (Exception ex)
{
Elmah.ErrorSignal.FromCurrentContext().Raise(ex);
returnSave = ex.ToString();;
tr.Rollback();
}
finally
{
if (sqlCon.State == ConnectionState.Open)
{
sqlCon.Close();
}
}
return(returnSave);
}
public DataSet GetVisit(EmployerVisitDO EmployerVisitDO)
{
sqlCon = new SqlConnection(strConn);
try
{
sqlCon.Open();
sqlCmd = new SqlCommand("SP_GET_EMPLOYER_VISIT", sqlCon);
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.Parameters.AddWithValue("@SZ_EMPLOYER", EmployerVisitDO.EmploerID);
sqlCmd.Parameters.AddWithValue("@SZ_COMPANY_ID", EmployerVisitDO.CompanyID);
if (EmployerVisitDO.CaseNO != "")
{
sqlCmd.Parameters.AddWithValue("@SZ_CASE_NO", EmployerVisitDO.CaseNO);
}
if (EmployerVisitDO.From_Visit_Date != "" && EmployerVisitDO.To_Visit_Date != "")
{
sqlCmd.Parameters.AddWithValue("@DT_FROM_DATE", EmployerVisitDO.From_Visit_Date);
sqlCmd.Parameters.AddWithValue("@DT_TO_DATE", EmployerVisitDO.To_Visit_Date);
}
sqlda = new SqlDataAdapter(sqlCmd);
ds = new DataSet();
sqlda.Fill(ds);
}
catch (SqlException ex)
{
Elmah.ErrorSignal.FromCurrentContext().Raise(ex);
}
finally
{
if (sqlCon.State == ConnectionState.Open)
{
sqlCon.Close();
}
}
return(ds);
}
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());
}
}
protected void btnDeleteVisit_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
{
for (int i = 0; i < grdVisits.Items.Count; i++)
{
CheckBox chk = (CheckBox)grdVisits.Items[i].FindControl("chkSelect");
if (chk.Checked)
{
if (grdVisits.Items[i].Cells[17].Text.ToLower() == "true")
{
ScriptManager.RegisterClientScriptBlock(this, GetType(), "Done", "alert('Please select visit(s) for which invoice is not generated.');", true);
return;
}
}
}
ArrayList arrList = new ArrayList();
for (int i = 0; i < grdVisits.Items.Count; i++)
{
CheckBox chk = (CheckBox)grdVisits.Items[i].FindControl("chkSelect");
if (chk.Checked)
{
EmployerVisitDO objEmployerVisitDO = new EmployerVisitDO();
objEmployerVisitDO.VisitId = grdVisits.Items[i].Cells[3].Text;
objEmployerVisitDO.CompanyID = txtCompanyID.Text;
arrList.Add(objEmployerVisitDO);
}
}
EmployerBO objEmployerBO = new EmployerBO();
string returnVal = objEmployerBO.DeleteVisit(arrList);
if (returnVal != "")
{
this.usrMessage.PutMessage("Visit Deleted successfully.");
this.usrMessage.SetMessageType(UserControl_ErrorMessageControl.DisplayType.Type_UserMessage);
this.usrMessage.Show();
}
else
{
this.usrMessage.PutMessage("Error to delete visit.");
this.usrMessage.SetMessageType(UserControl_ErrorMessageControl.DisplayType.Type_ErrorMessage);
this.usrMessage.Show();
}
GetData();
}
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)
{
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());
}
}
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);
}
