protected void BtnSave_Click(object sender, EventArgs e)
{
tblPrescription tblins = new tblPrescription();
tblins.DeptCategory = Convert.ToInt32(ddlDeptCategory.SelectedValue);
tblins.DeptDoctor = txtDeptCat.Text;
tblins.AdmitId = Convert.ToInt32(ddlPatient.SelectedValue);
tblins.Prescription_Date = Convert.ToDateTime(txtPrescriptionDate.Text);
tblins.IsDressing = chkDress.Checked;
tblins.IsInjection = chkInject.Checked;
if (chkInject.Checked)
{
tblins.InjectionName = txtInjection.Text;
}
tblins.Investigation = Convert.ToString(txtInvestigation.Text);
tblins.Impression = Convert.ToString(txtImpression.Text);
tblins.AdviceNote = Convert.ToString(txtAdviceNote.Text);
tblins.Remarks = Convert.ToString(txtRemarks.Text);
tblPatientAdmitDetail objFac = MobjClaim.GetEmployee(Convert.ToInt32(ddlPatient.SelectedValue));
if (objFac != null)
{
List <EntityPrescriptionDetails> inslst = (List <EntityPrescriptionDetails>)Session["Charges"];
int ClaimId = Convert.ToInt32(MobjClaim.Save(tblins, inslst));
lblMessage.Text = "Record Saved Successfully.....";
Session["Charges"] = null;
chkDress.Checked = false;
chkInject.Checked = false;
txtInjection.Text = string.Empty;
txtInvestigation.Text = string.Empty;
txtImpression.Text = string.Empty;
txtAdviceNote.Text = string.Empty;
txtRemarks.Text = string.Empty;
InjectionPara(chkInject.Checked);
Clear();
inslst = new List <EntityPrescriptionDetails>();
dgvChargeDetails.DataSource = inslst;
dgvChargeDetails.DataBind();
lblMsg.Text = string.Empty;
InjectionPara(chkInject.Checked);
}
else
{
lblMsg.Text = "Invalid Patient";
}
Session["Charges"] = new List <EntityPrescriptionDetails>();
BindPrescription();
MultiView1.SetActiveView(View1);
}
public tblPrescription GetPrescriptionInfo(int PrescriptionId)
{
tblPrescription obj = null;
try
{
obj = (from tbl in objData.tblPrescriptions
where tbl.IsDelete == false &&
tbl.Prescription_Id == PrescriptionId
select tbl).FirstOrDefault();
}
catch (Exception ex)
{
throw ex;
}
return(obj);
}
public int?Save(tblPrescription tblins, List <EntityPrescriptionDetails> lst)
{
int?PrescriptionId = 0;
try
{
objData.STP_Insert_tblPrescription(Convert.ToInt32(tblins.AdmitId), Convert.ToInt32(tblins.DeptCategory), tblins.DeptDoctor, Convert.ToDateTime(tblins.Prescription_Date),
tblins.IsDressing, tblins.IsInjection, tblins.InjectionName, tblins.Investigation, tblins.Impression, tblins.AdviceNote, tblins.Remarks, ref PrescriptionId);
foreach (EntityPrescriptionDetails item in lst)
{
tblPrescriptionDetail tbl = new tblPrescriptionDetail()
{
ProductId = Convert.ToInt32(item.ProductId),
Morning = item.Morning,
Afternoon = item.Afternoon,
Night = item.Night,
NoOfDays = item.NoOfDays,
Quantity = item.Quantity,
Prescription_Id = Convert.ToInt32(PrescriptionId),
IsDelete = false
};
objData.tblPrescriptionDetails.InsertOnSubmit(tbl);
tblStockDetail stock = new tblStockDetail()
{
ProductId = Convert.ToInt32(item.ProductId),
OpeningQty = 0,
InwardQty = 0,
InwardPrice = 0,
InwardAmount = 0,
OutwardQty = Convert.ToInt32(item.Quantity),
TransactionType = "Issue",
DocumentNo = PrescriptionId,
};
objData.tblStockDetails.InsertOnSubmit(stock);
}
objData.SubmitChanges();
}
catch (Exception ex)
{
throw ex;
}
return(PrescriptionId);
}
protected void BtnUpdate_Click(object sender, EventArgs e)
{
try
{
ddlPatient.Enabled = false;
tblPrescription tblins = new tblPrescription();
tblins.Prescription_Id = Convert.ToInt32(Session["PrescriptionId"]);
tblins.AdmitId = Convert.ToInt32(ddlPatient.SelectedValue);
tblins.DeptCategory = Convert.ToInt32(ddlDeptCategory.SelectedValue);
tblins.DeptDoctor = txtDeptCat.Text;
tblins.Prescription_Date = Convert.ToDateTime(txtPrescriptionDate.Text);
tblins.InjectionName = txtInjection.Text;
tblins.IsDressing = chkDress.Checked;
tblins.IsInjection = chkInject.Checked;
tblins.AdviceNote = txtAdviceNote.Text;
tblins.Investigation = txtInvestigation.Text;
tblins.Impression = Convert.ToString(txtImpression.Text);
tblins.Remarks = Convert.ToString(txtRemarks.Text);
List <EntityPrescriptionDetails> inslst = (List <EntityPrescriptionDetails>)Session["Prescript"];
MobjClaim.Update(tblins, inslst);
lblMessage.Text = "Record Updated Successfully.....";
chkDress.Checked = false;
chkInject.Checked = false;
txtInjection.Text = string.Empty;
txtInvestigation.Text = string.Empty;
txtImpression.Text = string.Empty;
txtAdviceNote.Text = string.Empty;
txtRemarks.Text = string.Empty;
InjectionPara(chkInject.Checked);
Clear();
List <EntityPrescriptionDetails> lst = new List <EntityPrescriptionDetails>();
dgvChargeDetails.DataSource = lst;
dgvChargeDetails.DataBind();
BindPrescription();
Session["Charges"] = null;
MultiView1.SetActiveView(View1);
}
catch (Exception ex)
{
lblMsg.Text = ex.Message;
}
}
public bool ValidateAllocation(tblPrescription sal)
{
try
{
var res = (from tbl in objData.tblPrescriptions
where tbl.AdmitId == sal.AdmitId
select tbl).FirstOrDefault();
if (res != null)
{
return(false);
}
else
{
return(true);
}
}
catch (Exception ex)
{
throw ex;
}
}
protected void BtnEdit_Click(object sender, EventArgs e)
{
btnAdd.Visible = true;
btnUpdatecharge.Visible = false;
BtnSave.Visible = false;
btnUpdate.Visible = true;
Session["MyFlag"] = "Edit";
GetDeptCategory();
ImageButton imgEdit = (ImageButton)sender;
GridViewRow row = (GridViewRow)imgEdit.NamingContainer;
Session["PrescriptionId"] = Convert.ToInt32(dgvClaim.DataKeys[row.RowIndex].Value);
ListItem item1 = ddlDeptCategory.Items.FindByText(Convert.ToString(row.Cells[3].Text));
if (item1 != null)
{
ddlDeptCategory.SelectedValue = item1.Value;
ListItem item = ddlPatient.Items.FindByText(Convert.ToString(row.Cells[1].Text));
ddlPatient.SelectedValue = item.Value;
DateTime MDate = Convert.ToDateTime(row.Cells[2].Text);
txtPrescriptionDate.Text = string.Format("{0:MM/dd/yyyy}", MDate);
txtDeptCat.Text = Convert.ToString(row.Cells[4].Text);
tblPrescription objPresc = MobjClaim.GetPrescriptionInfo(Convert.ToInt32(Session["PrescriptionId"]));
chkDress.Checked = Convert.ToBoolean(objPresc.IsDressing);
chkInject.Checked = Convert.ToBoolean(objPresc.IsInjection);
txtInvestigation.Text = Convert.ToString(objPresc.Investigation);
txtImpression.Text = Convert.ToString(objPresc.Impression);
txtAdviceNote.Text = Convert.ToString(objPresc.AdviceNote);
txtRemarks.Text = Convert.ToString(objPresc.Remarks);
InjectionPara(objPresc.IsInjection.Value);
txtInjection.Text = objPresc.InjectionName;
BindPrescription(Convert.ToInt32(Session["PrescriptionId"]));
//InjectionPara(false);
MultiView1.SetActiveView(View2);
}
else
{
lblMessage.Text = "Patient Already Discharged";
}
}
public void Update(tblPrescription obj, List <EntityPrescriptionDetails> lst)
{
try
{
tblPrescription objcurrent = (from tbl in objData.tblPrescriptions
where tbl.Prescription_Id == obj.Prescription_Id
select tbl).FirstOrDefault();
if (objcurrent != null)
{
objcurrent.AdmitId = obj.AdmitId;
objcurrent.DeptCategory = obj.DeptCategory;
objcurrent.DeptDoctor = obj.DeptDoctor;
objcurrent.Prescription_Date = obj.Prescription_Date;
objcurrent.InjectionName = obj.InjectionName;
objcurrent.IsDressing = obj.IsDressing;
objcurrent.IsInjection = obj.IsInjection;
objcurrent.Investigation = obj.Investigation;
objcurrent.Impression = obj.Impression;
objcurrent.AdviceNote = obj.AdviceNote;
objcurrent.Remarks = obj.Remarks;
}
foreach (EntityPrescriptionDetails item in lst)
{
tblPrescriptionDetail objsal = new tblPrescriptionDetail();
objsal = (from tbl in objData.tblPrescriptionDetails
where tbl.PrescriptionDetailId == item.PrescriptionDetailId &&
tbl.Prescription_Id == item.Prescription_Id && tbl.ProductId == item.ProductId &&
tbl.IsDelete == false
select tbl).FirstOrDefault();
if (objsal != null)
{
objsal.ProductId = Convert.ToInt32(item.ProductId);
objsal.Morning = item.Morning;
objsal.Afternoon = item.Afternoon;
objsal.Night = item.Night;
objsal.NoOfDays = item.NoOfDays;
objsal.Quantity = item.Quantity;
objsal.IsDelete = item.IsDelete;
}
else
{
objsal = new tblPrescriptionDetail()
{
ProductId = item.ProductId,
Morning = item.Morning,
Afternoon = item.Afternoon,
Night = item.Night,
NoOfDays = item.NoOfDays,
Quantity = item.Quantity,
Prescription_Id = Convert.ToInt32(obj.Prescription_Id),
IsDelete = false
};
objData.tblPrescriptionDetails.InsertOnSubmit(objsal);
}
tblStockDetail stock = (from tbl in objData.tblStockDetails
where tbl.IsDelete == false &&
tbl.DocumentNo == item.Prescription_Id &&
tbl.ProductId == item.ProductId &&
tbl.TransactionType.Equals("Issue")
select tbl).FirstOrDefault();
if (stock != null)
{
stock.ProductId = Convert.ToInt32(item.ProductId);
stock.OpeningQty = 0;
stock.InwardQty = 0;
stock.InwardPrice = 0;
stock.InwardAmount = 0;
stock.OutwardQty = Convert.ToInt32(item.Quantity);
stock.IsDelete = item.IsDelete;
}
else
{
tblStockDetail stock1 = new tblStockDetail()
{
ProductId = Convert.ToInt32(item.ProductId),
OpeningQty = 0,
InwardQty = 0,
InwardPrice = 0,
InwardAmount = 0,
OutwardQty = Convert.ToInt32(item.Quantity),
TransactionType = "Issue",
IsDelete = false,
};
objData.tblStockDetails.InsertOnSubmit(stock1);
}
}
objData.SubmitChanges();
}
catch (Exception ex)
{
throw ex;
}
}
