public DSIssueBill.DTIssueBillDataTable PrintRecMedBill(RecieveMedicine Obj)
{
DSIssueBill.DTIssueBillDataTable dt = new DSIssueBill.DTIssueBillDataTable();
try
{
string Qry = "select RecievedNumber as IssueNumber,RecieveDate as IssueDate,ItemName as MedicineName,Qty as Quantity,lt.PurchasePrice as Price,GrossAmount,NetAmount from ReceiveMedicine,LabTest lt" +
" where lt.ID=ReceiveMedicine.ItemNumber and ReceiveMedicine.RecievedNumber=" + Obj.RecieveNumber;
//string Qry2 = "select RecievedNumber,RecieveDate,ItemName as MedicineName,Qty as Quantity,lt.RetailPrice as Price,GrossAmount,NetAmount from ReceiveMedicine,LabTest lt"+
// " where lt.ID=ReceiveMedicine.ItemNumber and ReceiveMedicine.RecievedNumber=" + Obj.RecieveNumber;
con = new OleDbConnection();
this.readconfile = new ReadConfigFile();
con.ConnectionString = this.readconfile.ConfigString(ConfigFiles.ProjectConfigFile);
con.Open();
if (con.State == ConnectionState.Open)
{
//if (Retail == true)
// da = new OleDbDataAdapter(Qry2, con);
// else if (Purchase == true)
da = new OleDbDataAdapter(Qry, con);
da.Fill(dt);
}
return(dt);
}
catch (Exception ex)
{
throw ex;
}
finally
{
con.Close();
}
}
public void ClearControlls()
{
txtIssueNo.Text = "";
txtMedName.Text = "";
txtSearchMedicineID.Text = "";
this.Current = null;
}
private void frmItemLedger_Load(object sender, EventArgs e)
{
labtests = new LabTestBLL().GetLabTests();
rm = new RecieveMedicine();
List <LabTest> medicines = labtests.Where(m => m.IsMedicine == true || m.IsRsTenInjection == true || m.IsAlwaysPaid == true).ToList <LabTest>();
labtests = null;
labtests = medicines;
cbxLabTest.DataSource = labtests;
cbxLabTest.DisplayMember = "TestName";
}
private void NewRecipt()
{
rm = new RecieveMedicine();
this.dgvRecieveMedicine.DataSource = null;
txtQty.Text = "";
txtID.Text = "";
txtNetAmount.Text = "";
frm.Current = null;
GetNextReceiptNumber();
}
private void tsEdit_Click_1(object sender, EventArgs e)
{
frm.ShowDialog();
rm.Lines.Clear();
dgvRecieveMedicine.DataSource = null;
dgvRecieveMedicine.DataSource = rm.Lines;
if (frm.Current != null)
{
dtpReceiveDate.Text = frm.Current.RecieveDate.ToShortDateString();
txtRecieveNumber.Text = frm.Current.RecieveNumber.ToString();
txtNetAmount.Text = frm.Current.RefRec.NetAmount.ToString();
txtID.Text = frm.Current.RefRec.LineItem.MedIssuedID.ToString();
LoRec = new LabTestBLL().GetRecieveMedicines(txtRecieveNumber.Text.ToString());
rm = new RecieveMedicine();
rm.RecieveNumber = Convert.ToInt64(txtRecieveNumber.Text);
foreach (var item in LoRec)
{
RecieveLineItem rli = new RecieveLineItem();
rli.LineItem.LabTestId = item.RefRec.LineItem.LabTestId;
rli.LineItem.TestName = item.RefRec.LineItem.TestName;
rli.Quantity = item.Quantity;
rli.Price = item.RefRec.Price;
rli.GrossAmount = item.RefRec.GrossAmount;
cbxbranches.SelectedValue = item.RefBranch.BranchID;
if (!rm.Lines.Contains(rli))
{
rm.Lines.Add(rli);
}
else
{
RecieveLineItem rtemp = rm.Lines[rm.Lines.IndexOf(rli)];
rtemp = rli;
rm.Lines[rm.Lines.IndexOf(rli)] = rtemp;
}
dgvRecieveMedicine.DataSource = null;
dgvRecieveMedicine.DataSource = rm.Lines;
for (int i = 0; i < dgvRecieveMedicine.Columns.Count; i++)
{
dgvRecieveMedicine.Columns[i].Visible = true;
dgvRecieveMedicine.Columns["LineItem"].HeaderText = "Medicine Name";
dgvRecieveMedicine.Columns["LineItem"].Width = 160;
dgvRecieveMedicine.Columns["Quantity"].Width = 100;
dgvRecieveMedicine.Columns["NetAmount"].Visible = false;
}
dgvRecieveMedicine.ClearSelection();
}
}
}
private void NewRecipt()
{
rm = new RecieveMedicine();
this.dgvIssueMedicine.DataSource = null;
txtQty.Text = "";
cbxLabTest.Text = "";
txtPrice.Text = "";
txtID.Text = "";
txtNetAmount.Text = "";
cbxbranches.Text = "";
frm.Current = null;
GetNextReceiptNumber();
}
private void lblSelect_Click(object sender, EventArgs e)
{
int L = Convert.ToInt32(dgvMedicines.CurrentRow.Cells["ID"].Value);
if (dgvMedicines.CurrentRow != null)
{
if (dgvMedicines.CurrentRow.Cells[0].Value != null)
{
this.Current = (RecieveMedicine)LoRec.Where(g => g.RefRec.LineItem.MedIssuedID == L).Single <RecieveMedicine>();
}
}
this.Close();
}
public List <RecieveMedicine> GetRecieveMedicines(string RecieveNumber)
{
List <RecieveMedicine> LoRec = new List <RecieveMedicine>();
try
{
string select = "Select * from ReceiveMedicine where RecievedNumber=" + RecieveNumber;
DataTable dt = new DataTable();
con = new OleDbConnection();
readconfile = new ReadConfigFile();
con.ConnectionString = readconfile.ConfigString(ConfigFiles.ProjectConfigFile);
con.Open();
if (con.State == ConnectionState.Open)
{
da = new OleDbDataAdapter(select, con);
da.Fill(dt);
}
if (dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
RecieveMedicine ObjRec = new RecieveMedicine();
ObjRec.RefRec.LineItem.LabTestId = Convert.ToInt32(row["ItemNumber"]);
ObjRec.RefRec.LineItem.TestName = row["ItemName"].ToString();
//ObjRec.RefRec.LineItem.MedIssuedID = Convert.ToInt32(row["ID"]);
ObjRec.RefRec.Quantity = Convert.ToDecimal(row["Qty"]);
//ObjRec.RecieveDate = Convert.ToDateTime(row["RecieveDate"]);
//ObjRec.RecieveNumber = Convert.ToInt64(row["RecievedNumber"]);
ObjRec.RefRec.Price = row["Price"] == DBNull.Value ? 0 : Convert.ToDouble(row["Price"]);
ObjRec.RefRec.GrossAmount = row["GrossAmount"] == DBNull.Value ? 0 : Convert.ToDouble(row["GrossAmount"]);
ObjRec.RefRec.NetAmount = row["NetAmount"] == DBNull.Value ? 0 : Convert.ToDouble(row["NetAmount"]);
ObjRec.RefBranch.BranchID = row["BranchID"] == DBNull.Value ? 0 : Convert.ToInt16(row["BranchID"]);
LoRec.Add(ObjRec);
}
}
return(LoRec);
}
catch (Exception ex)
{
throw ex;
}
finally
{
con.Close();
}
}
private void frmRecieveMedicine_Load(object sender, EventArgs e)
{
labtests = new LabTestBLL().GetLabTests();
rm = new RecieveMedicine();
//List<LabTest> medicines = labtests.Where(m => m.IsMedicine == true || m.IsRsTenInjection ==true || m.IsAlwaysPaid ==true).ToList<LabTest>();
//labtests = null;
//labtests = medicines;
cbxLabTest.DataSource = labtests;
cbxLabTest.DisplayMember = "TestName";
cbxLabTest.ValueMember = "LabTestId";
GetNextReceiptNumber();
txtID.Text = "";
txtPrice.Text = "";
}
private void frmIsssuedMedicinePrice_Load(object sender, EventArgs e)
{
labtests = new LabTestBLL().GetLabTests();
rm = new RecieveMedicine();
if (labtests.Count > 0)
{
List <LabTest> medicines = labtests.Where(m => m.IsMedicine == true || m.IsRsTenInjection == true || m.IsAlwaysPaid == true).ToList <LabTest>();
labtests = null;
labtests = medicines;
cbxMedicines.DataSource = labtests;
cbxMedicines.DisplayMember = "TestName";
}
rbPurchase.Checked = true;
rbAll.Checked = false;
}
private void frmRecieveMedicine_Load(object sender, EventArgs e)
{
labtests = new LabTestBLL().GetLabTests();
rm = new RecieveMedicine();
//List<LabTest> medicines = labtests.Where(m => m.IsMedicine == true || m.IsRsTenInjection ==true || m.IsAlwaysPaid ==true).ToList<LabTest>();
//labtests = null;
//labtests = medicines;
cbxLabTest.DataSource = labtests;
cbxLabTest.DisplayMember = "TestName";
cbxLabTest.ValueMember = "LabTestId";
cbxbranches.DataSource = new BranchBLL().GetBranchData();
cbxbranches.DisplayMember = "BranchName";
cbxbranches.ValueMember = "BranchID";
NewRecipt();
}
public bool SaveRecieveMedicine(RecieveMedicine rm)
{
try
{
int VID = 0;
con = new OleDbConnection();
this.readconfile = new ReadConfigFile();
con.ConnectionString = this.readconfile.ConfigString(ConfigFiles.ProjectConfigFile);
con.Open();
tran = con.BeginTransaction();
cmd = new OleDbCommand("", con);
//cmd.Connection = con;
cmd.Transaction = tran;
//cmd.CommandType = CommandType.Text;
cmd.CommandText = "delete from ReceiveMedicine where RecievedNumber=" + rm.RecieveNumber;
cmd.ExecuteNonQuery();
OleDbCommand cmdSave = new OleDbCommand();
cmdSave.Connection = con;
cmdSave.Transaction = tran;
foreach (RecieveLineItem item in rm.Lines)
{
//if (rm.RefRec.LineItem.MedIssuedID == 0)
//{
if (item.LineItem.LabTestId > 0)
{
cmdSave.CommandText = "Insert into ReceiveMedicine(RecieveDate,RecievedNumber,ItemNumber,ItemName,Qty,Price,GrossAmount,NetAmount) values (#" +
rm.RecieveDate + "#," + rm.RecieveNumber + "," + item.LineItem.LabTestId + ",'" +
item.LineItem.TestName + "'," + item.Quantity + "," + item.Price + "," + item.GrossAmount + "," + rm.RefRec.NetAmount + ")";
}
cmdSave.ExecuteNonQuery();
}
tran.Commit();
}
catch (Exception ex)
{
tran.Rollback();
throw ex;
}
finally
{ con.Close(); }
return(true);
}
public frmPrintIssueMedByPrices(RecieveMedicine rm)
{
InitializeComponent();
this.r = rm;
}
public frmPrintReceiveMedBill(RecieveMedicine rm)
{
InitializeComponent();
this.r = rm;
}
public DSIssueBill.DTIssueBillDataTable PrintIssueMedBill(RecieveMedicine Obj, bool Retail, bool Purchase)
{
return(new InjectionLabTestDAL().PrintIssueMedBill(Obj, Retail, Purchase));
}
public bool SaveIssuedMedicine(RecieveMedicine rm)
{
return(new InjectionLabTestDAL().SaveIssuedMedicine(rm));
}
public DSIssueBill.DTIssueBillDataTable PrintRecMedBill(RecieveMedicine Obj)
{
return(new LabTestDAL().PrintRecMedBill(Obj));
}
public bool SaveReceivedMedicine(RecieveMedicine rm)
{
return(new LabTestDAL().SaveRecieveMedicine(rm));
}
