public int?Save(tblOTMedicineBill tblins, List <EntityOTMedicineBillDetails> lst)
{
int?BillNo = 0;
try
{
objData.STP_Insert_tblOTMedicineBill(Convert.ToInt32(tblins.AdmitId), Convert.ToDateTime(tblins.Bill_Date), tblins.TotalAmount, ref BillNo);
foreach (EntityOTMedicineBillDetails item in lst)
{
tblOTMedicineBillDetail tbl = new tblOTMedicineBillDetail()
{
TabletId = Convert.ToInt32(item.TabletId),
Quantity = item.Quantity,
Price = item.Price,
Amount = item.Quantity * item.Price,
BillNo = Convert.ToInt32(BillNo),
IsDelete = false
};
objData.tblOTMedicineBillDetails.InsertOnSubmit(tbl);
}
objData.SubmitChanges();
}
catch (Exception ex)
{
throw ex;
}
return(BillNo);
}
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 = ddlPatient.Items.FindByText(Convert.ToString(row.Cells[1].Text));
if (item != null)
{
ddlPatient.SelectedValue = item.Value;
DateTime MDate = Convert.ToDateTime(row.Cells[2].Text);
txtBillDate.Text = string.Format("{0:MM/dd/yyyy}", MDate);
txtTotal.Text = Convert.ToString(row.Cells[3].Text);
tblOTMedicineBill objPresc = MobjClaim.GetPrescriptionInfo(Convert.ToInt32(Session["PrescriptionId"]));
BindPrescription(Convert.ToInt32(Session["PrescriptionId"]));
//InjectionPara(false);
MultiView1.SetActiveView(View2);
}
else
{
lblMessage.Text = "Patient Already Discharged";
}
}
protected void BtnUpdate_Click(object sender, EventArgs e)
{
try
{
ddlPatient.Enabled = false;
tblOTMedicineBill tblins = new tblOTMedicineBill();
tblins.BillNo = Convert.ToInt32(Session["PrescriptionId"]);
tblins.AdmitId = Convert.ToInt32(ddlPatient.SelectedValue);
tblins.Bill_Date = Convert.ToDateTime(txtBillDate.Text);
tblins.TotalAmount = Convert.ToDecimal(txtTotal.Text);
List <EntityOTMedicineBillDetails> inslst = (List <EntityOTMedicineBillDetails>)Session["Prescript"];
MobjClaim.Update(tblins, inslst);
lblMessage.Text = "Record Updated Successfully.....";
Clear();
List <EntityOTMedicineBillDetails> lst = new List <EntityOTMedicineBillDetails>();
dgvChargeDetails.DataSource = lst;
dgvChargeDetails.DataBind();
BindPrescription();
Session["Charges"] = null;
MultiView1.SetActiveView(View1);
}
catch (Exception ex)
{
lblMsg.Text = ex.Message;
}
}
protected void BtnSave_Click(object sender, EventArgs e)
{
tblOTMedicineBill tblins = new tblOTMedicineBill();
tblins.AdmitId = Convert.ToInt32(ddlPatient.SelectedValue);
tblins.Bill_Date = Convert.ToDateTime(txtBillDate.Text);
tblins.TotalAmount = Convert.ToDecimal(txtTotal.Text);
tblPatientAdmitDetail objFac = MobjClaim.GetEmployee(Convert.ToInt32(ddlPatient.SelectedValue));
if (objFac != null)
{
List <EntityOTMedicineBillDetails> inslst = (List <EntityOTMedicineBillDetails>)Session["Charges"];
int ClaimId = Convert.ToInt32(MobjClaim.Save(tblins, inslst));
lblMessage.Text = "Record Saved Successfully.....";
Session["Charges"] = null;
Clear();
inslst = new List <EntityOTMedicineBillDetails>();
dgvChargeDetails.DataSource = inslst;
dgvChargeDetails.DataBind();
lblMsg.Text = string.Empty;
}
else
{
lblMsg.Text = "Invalid Patient";
}
Session["Charges"] = new List <EntityOTMedicineBillDetails>();
BindPrescription();
MultiView1.SetActiveView(View1);
}
public void Update(tblOTMedicineBill obj, List <EntityOTMedicineBillDetails> lst)
{
try
{
tblOTMedicineBill objcurrent = (from tbl in objData.tblOTMedicineBills
where tbl.BillNo == obj.BillNo
select tbl).FirstOrDefault();
if (objcurrent != null)
{
objcurrent.AdmitId = obj.AdmitId;
objcurrent.Bill_Date = obj.Bill_Date;
objcurrent.TotalAmount = obj.TotalAmount;
}
foreach (EntityOTMedicineBillDetails item in lst)
{
tblOTMedicineBillDetail objsal = new tblOTMedicineBillDetail();
objsal = (from tbl in objData.tblOTMedicineBillDetails
where tbl.BillDetailId == item.BillDetailId &&
tbl.BillNo == item.BillNo && tbl.TabletId == item.TabletId &&
tbl.IsDelete == false
select tbl).FirstOrDefault();
if (objsal != null)
{
objsal.TabletId = Convert.ToInt32(item.TabletId);
objsal.Quantity = item.Quantity;
objsal.Price = item.Price;
objsal.Amount = item.Quantity * item.Price;
objsal.IsDelete = item.IsDelete;
}
else
{
objsal = new tblOTMedicineBillDetail()
{
TabletId = item.TabletId,
Quantity = item.Quantity,
Price = item.Price,
Amount = item.Quantity * item.Price,
BillNo = Convert.ToInt32(obj.BillNo),
IsDelete = false
};
objData.tblOTMedicineBillDetails.InsertOnSubmit(objsal);
}
}
objData.SubmitChanges();
}
catch (Exception ex)
{
throw ex;
}
}
public tblOTMedicineBill GetPrescriptionInfo(int BillNo)
{
tblOTMedicineBill obj = null;
try
{
obj = (from tbl in objData.tblOTMedicineBills
where tbl.IsDelete == false &&
tbl.BillNo == BillNo
select tbl).FirstOrDefault();
}
catch (Exception ex)
{
throw ex;
}
return(obj);
}
public bool ValidateAllocation(tblOTMedicineBill sal)
{
try
{
var res = (from tbl in objData.tblOTMedicineBills
where tbl.AdmitId == sal.AdmitId
select tbl).FirstOrDefault();
if (res != null)
{
return(false);
}
else
{
return(true);
}
}
catch (Exception ex)
{
throw ex;
}
}
