private void clearEditForm()
{
txtEditOrderID.Text = "";
dtpEditDate.Value = DateTime.Today;
txtEditCustID.Text = "";
txtEditCustName.Text = "";
txtEditCustTel.Text = "";
txtEditEquipID.Text = "EQ-";
cmbEditEquipName.Text = "";
txtEditPPItem.Text = "";
txtEditQty.Text = " -Please Enter-";
lblEditTCost.Text = "-";
lblEditOutstanding.Text = "-";
dt.Clear();
EditTransDTable.Clear();
int noRows = dsKaizen.Tables["Trans"].Rows.Count;
if (noRows == 0)
{
lblAddTransID.Text = "TR-9000";
}
else
{
getTransID(noRows);
}
errP.Clear();
}
private void btnAddTransD_Click(object sender, EventArgs e)
{
{
DataRow row = dt.NewRow();
DataRow rw = EditTransDTable.NewRow();
try
{
rw["TransDetsID"] = "Temp";
rw["TransID"] = "Temp";
row["StockID"] = txtEditEquipID.Text;
rw["StockID"] = txtEditEquipID.Text;
row["StockDesc"] = cmbEditEquipName.Text.Trim();
row["StartDate"] = dtpEditStartD.Value;
rw["StartDate"] = dtpEditStartD.Value;
row["EndDate"] = dtpEditEndD.Value;
rw["EndDate"] = dtpEditEndD.Value;
row["RPU"] = txtEditRPItem.Text;
row["Qty"] = txtEditQty.Text;
rw["Qty"] = txtEditQty.Text;
row["Months"] = ((DateTime.Parse(row["EndDate"].ToString()).Year - DateTime.Parse(row["StartDate"].ToString()).Year) * 12) + DateTime.Parse(row["EndDate"].ToString()).Month - DateTime.Parse(row["StartDate"].ToString()).Month;
row["Cost"] = Convert.ToDouble(row["RPU"]) * Convert.ToDouble(row["Qty"]) * Convert.ToDouble(row["Months"]);
lblEditOutstanding.Text = (System.Convert.ToDouble(lblEditOutstanding.Text) + System.Convert.ToDouble(row["Cost"])).ToString();
dt.Rows.Add(row);
EditTransDTable.Rows.Add(rw);
dgvEdit.DataSource = dt;
double orderTotal = 0.00;
foreach (DataRow dr in dt.Rows)
{
orderTotal += System.Convert.ToDouble(dr["Cost"]);
}
lblEditTCost.Text = orderTotal.ToString();
AddClearEquip();
newTransDeatilsadded += 1;
}
catch (FormatException ex)
{
MessageBox.Show("Please input correct Equipment details?", "Input", MessageBoxButtons.OK);
}
}
}
void gatherTransDForEdit(string TransID)
{
EditTransDTable.Clear();
using (SqlConnection sqlConnectionEqT = new SqlConnection(@"Data Source = .; Initial Catalog = Kaizen;Integrated Security = true "))
{
SqlCommand sqlCmd = new SqlCommand("SELECT * FROM TransDetails WHERE TransID = '" + TransID + "'", sqlConnectionEqT);
sqlConnectionEqT.Open();
using (SqlDataReader reader = sqlCmd.ExecuteReader())
{
EditTransDTable.Load(reader);
}
sqlConnectionEqT.Close();
}
}
