private void btnSave_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
DataTable dtMrrData = new DataTable();
dtMrrData.Clear();
dtMrrData.Columns.Add("MrrNo");
dtMrrData.Columns.Add("StoreKeeper");
dtMrrData.Columns.Add("Date");
dtMrrData.Columns.Add("DelNoteNo");
dtMrrData.Columns.Add("ReqNo");
dtMrrData.Columns.Add("PoNo");
dtMrrData.Rows.Add(new object[] { txtMRR_no.Text, txtStoreKeeper.Text, dtMRR_date.Text, txtDel_note_no.Text, txtReq_no.Text, txtPO_no.Text });
gridView1.RefreshData();
DataTable MRRGrid = gridControl1.DataSource as DataTable;
MRRGrid.Columns.Remove("slno");
if (btnSave.Caption == "Save")
{
MRRData MRR = new MRRData(dtMrrData, MRRGrid);
MRR.FnConn();
MRR.fnTransactionData("I");
MRR.PoStatus = "MRR Created";
MRR.FnTrans();
if (MRR.Result == "Success")
{
MessageBox.Show("MRR Created", "ALERT", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("MRR Creation failed", "ALERT", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
for (int i = 0; i < MRRGrid.Rows.Count; i++)
{
Int16 FOrderQty = Convert.ToInt16(MRRGrid.Rows[i]["forderqty"]);
Int16 DelQty = Convert.ToInt16(MRRGrid.Rows[i]["deliveredQuantity"]);
MRRGrid.Rows[i]["deliveredQuantity"] = (FOrderQty + DelQty) + "";
}
MRRGrid.Columns.Remove("forderqty");
MRRData MRR = new MRRData(dtMrrData, MRRGrid);
MRR.FnConn();
MRR.fnTransactionData("U");
MRR.FnTrans();
if (MRR.Result == "Success")
{
MessageBox.Show("MRR Updated", "ALERT", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
private void LoadMRR(bool MRRDetails)
{
DataTable dtMrrData = null, dtMrrGrid = null;
MRRData mrr = new MRRData(null, null);
mrr.FnConn();
if (!MRRDetails)
{
gridView1.Columns["forderqty"].Visible = false;
dtMrrData = mrr.GetRow("PO", PO_No);
dtMrrGrid = mrr.GetRow("POGRID", PO_No);
dtMrrGrid.Columns.Add("deliveredQuantity", Type.GetType("System.Int32"));
dtMrrGrid.Columns.Add("balanceQuantity", Type.GetType("System.Int32"));
dtMrrGrid.Columns.Add("remark", Type.GetType("System.String"));
if (dtMrrData.Rows.Count > 0)
{
txtMRR_no.Text = "MRR-N0:00000" + (Convert.ToInt16(mrr.GetMaxValue()) + 1);
dtMRR_date.EditValue = DateTime.Now;
txtDel_note_no.Text = "";
txtReq_no.Text = dtMrrData.Rows[0]["purchaseRequestNo"] + "";
txtPO_no.Text = dtMrrData.Rows[0]["OrderNo"] + "";
}
}
else
{
btnSave.Caption = "Update";
Commen_Form.Functions.DateConverter dtc = new Commen_Form.Functions.DateConverter();
dtMrrData = mrr.GetRow("SMRR", MrrNo);
dtMrrGrid = mrr.GetRow("SMRRGRID", MrrNo);
if (dtMrrData.Rows.Count > 0)
{
txtStoreKeeper.Text = dtMrrData.Rows[0]["storeKeeper"] + "";
txtMRR_no.Text = dtMrrData.Rows[0]["mrrNo"] + "";
dtMRR_date.EditValue = dtc.dateconverter(dtMrrData.Rows[0]["date"] + "");
txtDel_note_no.Text = dtMrrData.Rows[0]["delivaryNoteNo"] + "";
txtReq_no.Text = dtMrrData.Rows[0]["requestNo"] + "";
txtPO_no.Text = dtMrrData.Rows[0]["purchaseOrderNo"] + "";
dtMrrGrid.Columns.Add("forderqty", Type.GetType("System.Int32")).SetOrdinal(5);
for (int i = 0; i < dtMrrGrid.Rows.Count; i++)
{
dtMrrGrid.Rows[i]["forderqty"] = dtMrrGrid.Rows[i]["deliveredQuantity"];
}
for (int i = 0; i < dtMrrGrid.Rows.Count; i++)
{
dtMrrGrid.Rows[i]["balanceQuantity"] = "0.00";
dtMrrGrid.Rows[i]["deliveredQuantity"] = "0.00";
}
}
}
dtMrrGrid.Columns.Add("slno", Type.GetType("System.Int32"));
for (int count = 0; count < dtMrrGrid.Rows.Count; count++)
{
dtMrrGrid.Rows[count]["slno"] = count + 1;
}
gridControl1.DataSource = dtMrrGrid;
mrr.FnTrans();
}
