protected void BtnEdit_Click(object sender, EventArgs e)
{
btnAdd.Visible = true;
btnUpdatecharge.Visible = false;
BtnSave.Visible = false;
btnUpdate.Visible = true;
Session["MyFlag"] = "Edit";
ImageButton imgEdit = (ImageButton)sender;
GridViewRow row = (GridViewRow)imgEdit.NamingContainer;
Session["PrescriptionId"] = Convert.ToInt32(dgvClaim.DataKeys[row.RowIndex].Value);
ListItem item = ddlCategoryName.Items.FindByText(Convert.ToString(row.Cells[2].Text));
ListItem itemDoc = ddlConsultDoctor.Items.FindByText(Convert.ToString(row.Cells[3].Text));
if (item != null && itemDoc != null)
{
ddlCategoryName.SelectedValue = item.Value;
ddlConsultDoctor.SelectedValue = itemDoc.Value;
DateTime MDate = Convert.ToDateTime(row.Cells[1].Text);
txtConsultDate.Text = string.Format("{0:MM/dd/yyyy}", MDate);
txtConsultCharge.Text = Convert.ToString(row.Cells[4].Text);
tblAllocConsultDoctor objPresc = MobjClaim.GetPrescriptionInfo(Convert.ToInt32(Session["PrescriptionId"]));
BindPrescription(Convert.ToInt32(Session["PrescriptionId"]));
//InjectionPara(false);
MultiView1.SetActiveView(View2);
}
else
{
lblMessage.Text = "Category Name Not Found";
}
}
protected void BtnUpdate_Click(object sender, EventArgs e)
{
try
{
//ddlPatient.Enabled = false;
tblAllocConsultDoctor tblins = new tblAllocConsultDoctor();
tblins.SrNo = Convert.ToInt32(Session["PrescriptionId"]);
tblins.CategoryId = Convert.ToInt32(ddlCategoryName.SelectedValue);
tblins.ConsultDocId = Convert.ToInt32(ddlConsultDoctor.SelectedValue);
tblins.ConsultCharges = Convert.ToDecimal(txtConsultCharge.Text);
tblins.Consult_Date = Convert.ToDateTime(txtConsultDate.Text);
//tblins.TotalAmount = Convert.ToDecimal(txtTotal.Text);
List <EntityAllocaConDocDetails> inslst = (List <EntityAllocaConDocDetails>)Session["Prescript"];
MobjClaim.Update(tblins, inslst);
lblMessage.Text = "Record Updated Successfully.....";
Clear();
List <EntityAllocaConDocDetails> lst = new List <EntityAllocaConDocDetails>();
dgvChargeDetails.DataSource = lst;
dgvChargeDetails.DataBind();
BindAllocateDocToPatient();
Session["Charges"] = null;
MultiView1.SetActiveView(View1);
}
catch (Exception ex)
{
lblMsg.Text = ex.Message;
}
}
protected void BtnSave_Click(object sender, EventArgs e)
{
tblAllocConsultDoctor tblins = new tblAllocConsultDoctor();
tblins.CategoryId = Convert.ToInt32(ddlCategoryName.SelectedValue);
tblins.ConsultDocId = Convert.ToInt32(ddlConsultDoctor.SelectedValue);
tblins.ConsultCharges = Convert.ToDecimal(txtConsultCharge.Text);
tblins.Consult_Date = Convert.ToDateTime(txtConsultDate.Text);
////tblins.TotalAmount = Convert.ToDecimal(txtTotal.Text);
//tblPatientAdmitDetail objFac = MobjClaim.GetEmployee(Convert.ToInt32(ddlPatient.SelectedValue));
//if (objFac != null)
//{
List <EntityAllocaConDocDetails> inslst = (List <EntityAllocaConDocDetails>)Session["Charges"];
int ClaimId = Convert.ToInt32(MobjClaim.Save(tblins, inslst));
lblMessage.Text = "Record Saved Successfully.....";
Session["Charges"] = null;
Clear();
inslst = new List <EntityAllocaConDocDetails>();
dgvChargeDetails.DataSource = inslst;
dgvChargeDetails.DataBind();
lblMsg.Text = string.Empty;
//}
//else
//{
// lblMsg.Text = "Invalid Patient";
//}
Session["Charges"] = new List <EntityAllocaConDocDetails>();
BindAllocateDocToPatient();
MultiView1.SetActiveView(View1);
}
public int?Save(tblAllocConsultDoctor tblins, List <EntityAllocaConDocDetails> lst)
{
int?SrNo = 0;
try
{
objData.STP_Insert_tblAllocaConsultDoc(Convert.ToInt32(tblins.CategoryId), Convert.ToInt32(tblins.ConsultDocId), Convert.ToDecimal(tblins.ConsultCharges), Convert.ToDateTime(tblins.Consult_Date), ref SrNo);
foreach (EntityAllocaConDocDetails item in lst)
{
tblAllocConsultDoctorDetail tbl = new tblAllocConsultDoctorDetail()
{
AdmitId = Convert.ToInt32(item.AdmitId),
CategoryId = Convert.ToInt32(tblins.CategoryId),
ConsultDocId = Convert.ToInt32(tblins.ConsultDocId),
Consult_Date = Convert.ToDateTime(tblins.Consult_Date),
ConsultCharges = Convert.ToDecimal(tblins.ConsultCharges),
SrNo = Convert.ToInt32(SrNo),
IsDelete = false
};
objData.tblAllocConsultDoctorDetails.InsertOnSubmit(tbl);
}
objData.SubmitChanges();
}
catch (Exception ex)
{
throw ex;
}
return(SrNo);
}
public void Update(tblAllocConsultDoctor obj, List <EntityAllocaConDocDetails> lst)
{
try
{
tblAllocConsultDoctor objcurrent = (from tbl in objData.tblAllocConsultDoctors
where tbl.SrNo == obj.SrNo
select tbl).FirstOrDefault();
if (objcurrent != null)
{
objcurrent.CategoryId = obj.CategoryId;
objcurrent.ConsultDocId = obj.ConsultDocId;
objcurrent.Consult_Date = obj.Consult_Date;
objcurrent.ConsultCharges = obj.ConsultCharges;
}
foreach (EntityAllocaConDocDetails item in lst)
{
tblAllocConsultDoctorDetail objsal = new tblAllocConsultDoctorDetail();
objsal = (from tbl in objData.tblAllocConsultDoctorDetails
where tbl.SrDetailId == item.SrDetailId &&
tbl.SrNo == item.SrNo && tbl.AdmitId == item.AdmitId &&
tbl.IsDelete == false
select tbl).FirstOrDefault();
if (objsal != null)
{
objsal.AdmitId = Convert.ToInt32(item.AdmitId);
objsal.CategoryId = obj.CategoryId;
objsal.ConsultDocId = obj.ConsultDocId;
objsal.Consult_Date = obj.Consult_Date;
objsal.ConsultCharges = obj.ConsultCharges;
objsal.IsDelete = item.IsDelete;
}
else
{
objsal = new tblAllocConsultDoctorDetail()
{
AdmitId = item.AdmitId,
CategoryId = obj.CategoryId,
ConsultDocId = obj.ConsultDocId,
Consult_Date = obj.Consult_Date,
ConsultCharges = obj.ConsultCharges,
SrNo = Convert.ToInt32(obj.SrNo),
IsDelete = false
};
objData.tblAllocConsultDoctorDetails.InsertOnSubmit(objsal);
}
}
objData.SubmitChanges();
}
catch (Exception ex)
{
throw ex;
}
}
public tblAllocConsultDoctor GetPrescriptionInfo(int SrNo)
{
tblAllocConsultDoctor obj = null;
try
{
obj = (from tbl in objData.tblAllocConsultDoctors
where tbl.IsDelete == false &&
tbl.SrNo == SrNo
select tbl).FirstOrDefault();
}
catch (Exception ex)
{
throw ex;
}
return(obj);
}
