protected void btnStock_Click(object sender, EventArgs e)
{
UA = (ClinicDAL.UserAuthendication)Session[Const.LoginSession];
// CHECKING MEDICINE ALREADY EXITS condition...
string Name = Request.Form["txtSearch"];
if (Name != "")
{
DataTable dt = stok.GetMedcineDetails(Name);
if (dt.Rows.Count == 0)
{
stok.ClinicID = UA.ClinicID.ToString();
stok.CategoryID = ddlCategory.SelectedValue;
stok.Name = Name;
stok.Qty = 0;
stok.Unit = txtUnit.Text;
stok.CreatedBy = UA.userName;
stok.ReOrderQty = 10;
stok.MedCode ="med";
//calling medicine insertion
stok.InsertMedicines();
HiddenFieldMedicineID.Value = stok.MedicineID.ToString();
}
}
//Receipt Header
rpt.RefNo1 = txtReference1.Text;
rpt.RefNo2 = txtReference2.Text;
rpt.Date = Convert.ToDateTime(txtDate.Text);
rpt.ClinicID = UA.ClinicID.ToString();
rpt.CreatedBy = UA.userName;
//rpt.InsertReceiptHeader();
//Receipt Details MUST BE IN LOOP
ReceiptDetails rptdt = new ReceiptDetails();
rptdt.QTY = Convert.ToInt32(txtQty.Text);
rptdt.Unit =txtUnit.Text;
rptdt.MedicineID = HiddenFieldMedicineID.Value;
rptdt.ClinicID = UA.ClinicID.ToString();
rptdt.CreatedBy =UA.userName;
//Calling insert functions
//passing foreign key value
rptdt.ReceiptID = rpt.ReceiptID;
rptdt.InsertReceiptDetails();
}
protected void btnReceipt_Click(object sender, EventArgs e)
{
UA = (ClinicDAL.UserAuthendication)Session[Const.LoginSession];
rpt.CreatedBy = UA.userName;
rpt.Date = Convert.ToDateTime(txtDate.Text);
rpt.RefNo1 = txtBillNo.Text;
rpt.RefNo2 = txtRefNo2.Text;
rpt.ClinicID = UA.ClinicID.ToString();
rpt.InsertReceiptHeader();
string values = HiddenField1.Value;
string[] Invalue = values.Split('|');
int len= Invalue.Length;
len = len - 1;
for (int i = 0; i <len ; i = i + 5)
{
ReceiptDetails rptdt = new ReceiptDetails();
rptdt.MedicineName = Invalue[i];
rptdt.QTY= Convert.ToInt32(Invalue[i + 4]);
rptdt.Unit = Invalue[i+1];
rptdt.CreatedBy = UA.userName;
rptdt.ClinicID = UA.ClinicID.ToString();
rptdt.ReceiptID = rpt.ReceiptID;
rptdt.InsertReceiptDetails();
}
// to reLOad added DAta To fields
string str = rpt.ReceiptID.ToString();
ReloadInsertFields(str);
}
