private void subtractAmountFromOldInventory(MedAndOrder mao)
{
string query = "";
int newNumOfTabs = mao.Medicen.Oldmed.RemainingAmount - mao.NumOfTabes;
if (newNumOfTabs > 0)
{
query = "UPDATE OldMeds SET {0} = {1} WHERE {2} = {3}";
query = string.Format(query,
DatabaseVars.REMAINING_AMOUNT, newNumOfTabs,
DatabaseVars.ID, mao.Medicen.Oldmed.Id1);
}
else if (newNumOfTabs == 0)
{
query = "DELETE FROM OldMeds WHERE {0} ='{1}' AND {2} = {3};";
query = string.Format(query,
DatabaseVars.PARCODE, mao.Medicen.Oldmed.PareCode,
DatabaseVars.ID, mao.Medicen.Oldmed.Id1);
}
else
{
subtractAmountFromOldMeds(newNumOfTabs * -1, mao);
return;
}
inserUpdatetObj.inserUpdatetData(query);
}
private void checkNewAmountAvaliablity(MedAndOrder mao)
{
mo.getOldMeds(mao.Medicen);
ArrayList oldMeds = mao.Medicen.OldmedsList;
if (oldMeds.Count == 0)
{
updateMedAmount(mao, true);
}
int totalOld = getOldSum(oldMeds);
int newAmount = mao.Medicen.NumOfTabes - totalOld;
int remaingAmount = newAmount - mao.NumOfTabes;
if (remaingAmount > 0)
{
updateMedAmount(mao, true);
}
else if (remaingAmount == 0)
{
deletOldMed((OldMed)oldMeds[oldMeds.Count - 1]);
updateMedAmount(mao, true);
}
else
{
subtractAmountFromNewAndOld(remaingAmount * -1, mao);
}
}
public void getOrderMedsInfo(Orders order)
{
string query = "SELECT * FROM OrderDetails WHERE {0} = {1} ;";
query = string.Format(query, DatabaseVars.ORDER_ID, order.OrderId);
MedAndOrder mao = new MedAndOrder();
mao.setMedOpj();
OleDbConnection dbConnection = dbManager.openDb();
this.comand.Connection = dbConnection;
comand.CommandText = query;
OleDbDataReader result = comand.ExecuteReader();
while (result.Read())
{
mao.OrderId = result.GetInt32(0);
mao.Medicen.MedName = result.GetString(1);
mao.Medicen.Parecode = result.GetString(2);
mao.NumOfTabes = result.GetInt16(3);
mao.TotalPrice = (double)result.GetDecimal(4);
order.ListOfMeds.Add(mao);
mao = new MedAndOrder();
mao.setMedOpj();
}
result.Close();
dbManager.closeDb();
}
private void orderMedsDetails_CellMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
{
currentSelectedIndex = orderMedsDetails.CurrentCell.RowIndex;
mao = (MedAndOrder)order.ListOfMeds[currentSelectedIndex];
showMedInfoToUpdate(mao.Medicen);
}
private void resetOpjects()
{
order = new Orders();
mao = new MedAndOrder();
med = new Medicine();
totalPrice = 0;
resetFields();
}
private int subtractAmountFromOldMeds(int newNumOfTabs, MedAndOrder mao)
{
// doda the right hand side is done :)
int temp;
string query;
ArrayList oldMeds = new ArrayList();
newNumOfTabs *= -1;
if (deletOldMed(mao.Medicen.Oldmed))
{
oldMeds = mao.Medicen.OldmedsList;
}
else
{
return(-1);
}
foreach (OldMed om in oldMeds)
{
#region loop body
temp = om.RemainingAmount - newNumOfTabs;
if (temp > 0)
{
query = "UPDATE OldMeds SET {0} = {1} WHERE {2} = {3}";
query = string.Format(query,
DatabaseVars.REMAINING_AMOUNT, newNumOfTabs,
DatabaseVars.ID, mao.Medicen.Oldmed.Id1);
inserUpdatetObj.inserUpdatetData(query);
return(0);
}
else if (temp == 0)
{
query = "DELETE FROM OldMeds WHERE {0} ='{1}' AND {2} = {3};";
query = string.Format(query,
DatabaseVars.PARCODE, mao.Medicen.Oldmed.PareCode,
DatabaseVars.ID, mao.Medicen.Oldmed.Id1);
inserUpdatetObj.inserUpdatetData(query);
return(0);
}
else
{
query = "DELETE FROM OldMeds WHERE {0} ='{1}' AND {2} = {3};";
query = string.Format(query,
DatabaseVars.PARCODE, mao.Medicen.Oldmed.PareCode,
DatabaseVars.ID, mao.Medicen.Oldmed.Id1);
inserUpdatetObj.inserUpdatetData(query);
newNumOfTabs = temp * -1;
}
#endregion
}
return(newNumOfTabs);
}
private void setMedOrderObj()
{
mao = new MedAndOrder();
mao.Medicen = this.med;
mao.MedicenId = this.med.MedID;
mao.NumOfTabes = int.Parse(amoutTextBox.Text.ToString());
mao.TotalPrice = this.med.TabPrice * mao.NumOfTabes;
mao.NumOfPackages = (double)(mao.NumOfTabes / mao.Medicen.TabPerPackage);
totalPrice += mao.TotalPrice;
this.order.addMedOrdToList(mao);
}
private void setObjcts()
{
table = new DataTable();
medOp = new MedicienOperations();
order = new Orders();
med = new Medicine();
mao = new MedAndOrder();
ordersOp = new OrdersOperations();
mao.Medicen = med;
}
private void updateMedAmount(MedAndOrder mao, bool skip)
{
int newNumOfTabs = mao.Medicen.NumOfTabes - mao.NumOfTabes;
if (!mao.Medicen.IsItOld && !skip)
{
checkNewAmountAvaliablity(mao);
return;
}
string query =
"UPDATE Meds SET {0} = {1} WHERE {2} = '{3}'";
query = string.Format(query,
DatabaseVars.NUMBER_OF_TABES, newNumOfTabs,
DatabaseVars.PARCODE, mao.Medicen.Parecode);
inserUpdatetObj.inserUpdatetData(query);
}
private void saveUpdateButton_Click(object sender, EventArgs e)
{
if (Companies.isEmpty(amoutTextBox) ||
!Companies.isNum(amoutTextBox.Text.ToString()))
{
MessageBox.Show("Invalid value in Amount field");
return;
}
this.table.Rows.RemoveAt(currentSelectedIndex);
MedAndOrder t = (MedAndOrder)this.order.ListOfMeds[currentSelectedIndex];
totalPrice -= t.TotalPrice;
this.order.ListOfMeds.RemoveAt(currentSelectedIndex);
setMedOrderObj();
addMedDetailsToSideTabel();
resetFields();
}
private bool searchOrdersMeds(string pareCode)
{
// MedAndOrder m = order.ListOfMeds[currentSelectedIndex]
int index = 0;
foreach (MedAndOrder m in order.ListOfMeds)
{
if (pareCode.Equals(m.Medicen.Parecode))
{
currentSelectedIndex = index;
mao = m;
showMedInfoToUpdate(m.Medicen);
return(true);
}
index++;
}
return(false);
}
private void addToMedsAndOrds(MedAndOrder mao, int orderId)
{
double numOfPackages = (double)mao.NumOfTabes / (double)mao.Medicen.TabPerPackage;
string query = "INSERT INTO MedsAndOrds ({0},{1},{2},{3},{4}) VALUES('{5}',{6},{7},{8},{9});";
query = string.Format(query,
DatabaseVars.PARCODE,
DatabaseVars.ORDER_ID,
DatabaseVars.NUMBER_OF_TABES,
DatabaseVars.NUMBER_OF_PACKAGES,
DatabaseVars.TYPE_TOTAL_PRICE,
mao.Medicen.Parecode,
orderId,
mao.NumOfTabes,
numOfPackages,
mao.TotalPrice);
inserUpdatetObj.inserUpdatetData(query);
}
private void subtractAmountFromNewAndOld(int reqiredAmount, MedAndOrder mao)
{
int temp;
int counter = 0;
// int newNumOfTabs = mao.NumOfTabes;
foreach (OldMed om in mao.Medicen.OldmedsList)
{
#region loop body
temp = om.RemainingAmount - reqiredAmount;
if (temp > 0)
{
deletOldMed(om);
updateMedAmount(mao, true);
return;
}
else if (temp == 0)
{
deletOldMed(om);
try
{
deletOldMed((OldMed)mao.Medicen.OldmedsList[counter + 1]);
}
catch (Exception e) {
}
updateMedAmount(mao, true);
return;
}
else
{
deletOldMed(om);
reqiredAmount = temp * -1;
}
counter++;
#endregion
}
}
private void updateMedAmountInOldMed(MedAndOrder mao)
{
string query;
int newNumOfTabs = mao.Medicen.Oldmed.RemainingAmount - mao.NumOfTabes;
if (newNumOfTabs <= 0)
{
query = "DELETE FROM OldMeds WHERE {0} ='{1}' AND {2} = {3};";
query = string.Format(query,
DatabaseVars.PARCODE, mao.Medicen.Oldmed.PareCode,
DatabaseVars.ID, mao.Medicen.Oldmed.Id1);
}
else
{
query = "UPDATE OldMeds SET {0} = {1} WHERE {2} = {3}";
query = string.Format(query,
DatabaseVars.REMAINING_AMOUNT, newNumOfTabs,
DatabaseVars.ID, mao.Medicen.Oldmed.Id1);
}
inserUpdatetObj.inserUpdatetData(query);
}
