private void btnAddCompleteOrder_Click(object sender, EventArgs e)
{
MyTrans myTrans = new MyTrans();
bool ok = true;
errP.Clear();
try
{
myTrans.TransID = lblAddTransID.Text.Trim();
}
catch (MyException MyEx)
{
ok = false;
errP.SetError(lblAddTransID, MyEx.toString());
}
try
{
myTrans.CustID = txtAddCustID.Text.Trim();
}
catch (MyException MyEx)
{
ok = false;
errP.SetError(txtAddCustID, MyEx.toString());
}
try
{
myTrans.TransOn = dtpAddDate.Value;
}
catch (MyException MyEx)
{
ok = false;
errP.SetError(dtpAddDate, MyEx.toString());
}
try
{
myTrans.TransTotal = Convert.ToDouble(lblAddTCost.Text.Trim());
}
catch (MyException MyEx)
{
ok = false;
errP.SetError(lblAddTCost, MyEx.toString());
}
catch (FormatException frmex)
{
ok = false;
MessageBox.Show("Please Input Order Details Before Adding", "Order");
}
// try
{
if (ok)
{
drTrans = dsKaizen.Tables["Trans"].NewRow();
drTrans["TransID"] = myTrans.TransID;
drTrans["TransType"] = "Purchase";
drTrans["CustID"] = myTrans.CustID;
drTrans["TransDate"] = myTrans.TransOn;
drTrans["TransTotal"] = myTrans.TransTotal;
drTrans["BalanceOwed"] = myTrans.TransTotal;
drTrans["Paid"] = 'N';
dsKaizen.Tables["Trans"].Rows.Add(drTrans);
daTrans.Update(dsKaizen, "Trans");
// getTransDetailsID(dsKaizen.Tables["TransDetails"].Rows.Count);
getTransDetsnum();
int utdDetsNumber = seperateNumber(findTransID);
foreach (DataRow dr in dt.Rows)
{
MyTransDetails myTransDetails = new MyTransDetails();
utdDetsNumber += 1;
TansDIDString = "TD-" + utdDetsNumber;
try
{
myTransDetails.TransDetsID = TansDIDString;
}
catch (MyException MyEx)
{
ok = false;
}
try
{
myTransDetails.TransID = lblAddTransID.Text.Trim();
}
catch (MyException MyEx)
{
ok = false;
}
try
{
myTransDetails.StockID = dr["StockID"].ToString();
}
catch (MyException MyEx)
{
ok = false;
}
try
{
myTransDetails.Qty = Convert.ToInt32(dr["Qty"]);
}
catch (MyException MyEx)
{
ok = false;
}
if (ok)
{
drTransDets = dsKaizen.Tables["TransDetails"].NewRow();
drTransDets["TransDetsID"] = myTransDetails.TransDetsID;
drTransDets["TransID"] = myTransDetails.TransID;
drTransDets["StockID"] = myTransDetails.StockID;
GetCurrentStock(myTransDetails.StockID);
drTransDets["Qty"] = myTransDetails.Qty;
drTransDets["StartDate"] = DBNull.Value;
drTransDets["EndDate"] = DBNull.Value;
dsKaizen.Tables["TransDetails"].Rows.Add(drTransDets);
newQty = currentQty - myTransDetails.Qty;
string constr = @"Data Source = .; Initial Catalog = Kaizen;Integrated Security = true ";
SqlConnection con = new SqlConnection(constr);
DataSet ds = new DataSet();
con.Open();
SqlCommand cmd = new SqlCommand(" UPDATE Stock SET QtyInStock = " + newQty + " WHERE StockID ='" + myTransDetails.StockID + "'", con);
cmd.ExecuteNonQuery();
con.Close();
new SqlCommandBuilder(daTransD);
daTransD.Update(dsKaizen, "TransDetails");
}
}
MessageBox.Show("Purchase Order Added");
if (MessageBox.Show("Do you wish to Make another Order?", "Add Stock", MessageBoxButtons.YesNo) == System.Windows.Forms.DialogResult.Yes)
{
clearAddForm();
getTransID(dsKaizen.Tables["Trans"].Rows.Count);
}
else
{
tabEquip.SelectedIndex = 0;
}
}
}
// catch (Exception ex)
{
// MessageBox.Show("" + ex.TargetSite + "" + ex.Message, "Error !", MessageBoxButtons.AbortRetryIgnore,
// MessageBoxIcon.Error);
}
}
private void btnEditTrans_Click(object sender, EventArgs e)
{
daTransD.Update(dsKaizen, "TransDetails");
if (btnEditTrans.Text == "EDIT ORDER")
{
enableEdittxtB();
btnEditTrans.Text = "SAVE";
}
else
{
gatherTransDForEdit(txtEditOrderID.Text);
bool ok = true;
for (int i = 0; i < ogTransDrows; i++)
{
if (string.Equals(dt.Rows[i][1].ToString(), "Deleted"))
{
string deleteID = EditTransDTable.Rows[i][0].ToString();
deleteTranDets(deleteID);
daTransD.Update(dsKaizen, "TransDetails");
}
if (!Equals(dt.Rows[i][3], EditTransDTable.Rows[i][3]) || !Equals(dt.Rows[i][0], EditTransDTable.Rows[i][2]))
{
drTransDets = dsKaizen.Tables["TransDetails"].Rows.Find(EditTransDTable.Rows[i][0].ToString());
MyTransDetails myTransDetails = new MyTransDetails();
errP.Clear();
try
{
myTransDetails.StockID = drTransDets["StockID"].ToString();
}
catch (MyException MyEx)
{
ok = false;
}
try
{
myTransDetails.Qty = Convert.ToInt32(drTransDets["Qty"]);
}
catch (MyException MyEx)
{
ok = false;
}
try
{
if (ok)
{
drTransDets.BeginEdit();
drTransDets["StockID"] = myTransDetails.StockID;
drTransDets["Qty"] = myTransDetails.Qty;
drTransDets.EndEdit();
daTransD.Update(dsKaizen, "TransDetails");
}
}
catch (Exception ex)
{
MessageBox.Show("" + ex.TargetSite + "" + ex.Message, "Error !", MessageBoxButtons.AbortRetryIgnore,
MessageBoxIcon.Error);
}
}
}
if (ogTransDrows < dt.Rows.Count)
{
getTransDetsnum();
int utdDetsNumber = seperateNumber(findTransID);
// for (int i = 0; i < (dt.Rows.Count - ogTransDrows); i++)
foreach (DataRow dr in dt.Rows)
{
if (dt.Rows.IndexOf(dr) < ogTransDrows)
{
}
else
{
MyTransDetails myTransDetails = new MyTransDetails();
utdDetsNumber += 1;
TansDIDString = "TD-" + utdDetsNumber;
try
{
myTransDetails.TransDetsID = TansDIDString;
}
catch (MyException MyEx)
{
ok = false;
}
try
{
myTransDetails.TransID = txtEditOrderID.Text.Trim();
}
catch (MyException MyEx)
{
ok = false;
}
try
{
myTransDetails.StockID = dr["StockID"].ToString();
}
catch (MyException MyEx)
{
ok = false;
}
try
{
myTransDetails.Qty = Convert.ToInt32(dr["Qty"]);
}
catch (MyException MyEx)
{
ok = false;
}
if (ok)
{
drTransDets = dsKaizen.Tables["TransDetails"].NewRow();
drTransDets["TransDetsID"] = myTransDetails.TransDetsID;
drTransDets["TransID"] = myTransDetails.TransID;
drTransDets["StockID"] = myTransDetails.StockID;
drTransDets["Qty"] = myTransDetails.Qty;
drTransDets["StartDate"] = DBNull.Value;
drTransDets["EndDate"] = DBNull.Value;
dsKaizen.Tables["TransDetails"].Rows.Add(drTransDets);
new SqlCommandBuilder(daTransD);
daTransD.Update(dsKaizen, "TransDetails");
}
}
}
}
MyTrans myTrans = new MyTrans();
errP.Clear();
drTrans = dsKaizen.Tables["Trans"].Rows.Find(txtEditOrderID.Text);
try
{
myTrans.CustID = txtEditCustID.Text.Trim();
}
catch (MyException MyEx)
{
ok = false;
errP.SetError(txtEditCustID, MyEx.toString());
}
try
{
myTrans.TransOn = dtpEditDate.Value;
}
catch (MyException MyEx)
{
ok = false;
errP.SetError(dtpEditDate, MyEx.toString());
}
try
{
myTrans.TransTotal = Convert.ToDouble(lblEditTCost.Text.Trim());
}
catch (MyException MyEx)
{
ok = false;
errP.SetError(lblEditTCost, MyEx.toString());
}
try
{
myTrans.BalOwed = Convert.ToDouble(lblEditOutstanding.Text.Trim());
}
catch (MyException MyEx)
{
ok = false;
errP.SetError(lblEditOutstanding, MyEx.toString());
}
try
{
if (ok)
{
drTrans.BeginEdit();
drTrans["CustID"] = myTrans.CustID;
drTrans["TransDate"] = myTrans.TransOn;
drTrans["TransTotal"] = myTrans.TransTotal;
drTrans["BalanceOwed"] = myTrans.BalOwed;
if (myTrans.BalOwed <= 0)
{
drTrans["Paid"] = 'Y';
}
else
{
drTrans["Paid"] = 'N';
}
drTrans.EndEdit();
daTrans.Update(dsKaizen, "Trans");
MessageBox.Show("Purchase Details Updated", "Order");
disableEdittxtB();
btnEditTrans.Text = "EDIT ORDER";
tabEquip.SelectedIndex = 0;
}
}
catch (Exception ex)
{
MessageBox.Show("" + ex.TargetSite + "" + ex.Message, "Error !", MessageBoxButtons.AbortRetryIgnore,
MessageBoxIcon.Error);
}
}
}
private void btnAddCompleteOrder_Click(object sender, EventArgs e)
{
MyTrans myTrans = new MyTrans();
bool ok = true;
errP.Clear();
try
{
myTrans.TransID = lblAddTransID.Text.Trim();
}
catch (MyException MyEx)
{
ok = false;
errP.SetError(lblAddTransID, MyEx.toString());
}
try
{
myTrans.CustID = txtAddCustID.Text.Trim();
}
catch (MyException MyEx)
{
ok = false;
errP.SetError(lblAddTransID, MyEx.toString());
}
try
{
myTrans.CustID = txtAddCustID.Text.Trim();
}
catch (MyException MyEx)
{
ok = false;
errP.SetError(lblAddTransID, MyEx.toString());
}
try
{
myTrans.TransOn = dtpAddDate.Value;
}
catch (MyException MyEx)
{
ok = false;
errP.SetError(dtpAddDate, MyEx.toString());
}
try
{
myTrans.TransTotal = Convert.ToDouble(lblAddTCost.Text.Trim());
}
catch (MyException MyEx)
{
ok = false;
errP.SetError(lblAddTCost, MyEx.toString());
}
try
{
if (ok)
{
drTrans = dsKaizen.Tables["Trans"].NewRow();
drTrans["TransID"] = myTrans.TransID;
drTrans["TransType"] = "Service";
drTrans["CustID"] = myTrans.CustID;
drTrans["TransDate"] = myTrans.TransOn;
drTrans["TransTotal"] = myTrans.TransTotal;
drTrans["BalanceOwed"] = myTrans.TransTotal;
drTrans["Paid"] = 'N';
dsKaizen.Tables["Trans"].Rows.Add(drTrans);
daTrans.Update(dsKaizen, "Trans");
// getTransDetailsID(dsKaizen.Tables["TransDetails"].Rows.Count);
getTransDetsnum();
int utdDetsNumber = seperateNumber(findTransID);
foreach (DataRow dr in dt.Rows)
{
MyTransDetails myTransDetails = new MyTransDetails();
utdDetsNumber += 1;
TansDIDString = "TD-" + utdDetsNumber;
try
{
myTransDetails.TransDetsID = TansDIDString;
}
catch (MyException MyEx)
{
ok = false;
}
try
{
myTransDetails.TransID = lblAddTransID.Text.Trim();
}
catch (MyException MyEx)
{
ok = false;
}
try
{
myTransDetails.StockID = dr["StockID"].ToString();
}
catch (MyException MyEx)
{
ok = false;
}
try
{
myTransDetails.Qty = Convert.ToInt32(dr["Qty"]);
}
catch (MyException MyEx)
{
ok = false;
}
if (ok)
{
drTransDets = dsKaizen.Tables["TransDetails"].NewRow();
drTransDets["TransDetsID"] = myTransDetails.TransDetsID;
drTransDets["TransID"] = myTransDetails.TransID;
drTransDets["StockID"] = myTransDetails.StockID;
drTransDets["Qty"] = myTransDetails.Qty;
drTransDets["StartDate"] = DBNull.Value;
drTransDets["EndDate"] = DBNull.Value;
dsKaizen.Tables["TransDetails"].Rows.Add(drTransDets);
new SqlCommandBuilder(daTransD);
daTransD.Update(dsKaizen, "TransDetails");
}
}
MessageBox.Show("Purchase Order Added");
if (MessageBox.Show("Do you wish to Make another Order?", "Add Stock", MessageBoxButtons.YesNo) == System.Windows.Forms.DialogResult.Yes)
{
clearAddForm();
getTransID(dsKaizen.Tables["Trans"].Rows.Count);
}
else
{
tabService.SelectedIndex = 0;
}
}
}
catch (Exception ex)
{
MessageBox.Show("" + ex.TargetSite + "" + ex.Message, "Error !", MessageBoxButtons.AbortRetryIgnore,
MessageBoxIcon.Error);
}
}
