protected void btnSave_Click(object sender, EventArgs e)
{
MIS_Header_Model mIS_Header_Model = new MIS_Header_Model
{
RequestNo = txtRequestNo.Text,
ReferenceNo = txtRefNo.Text,
POCMNumber = txtPOCMNum.Text,
PreparedBy = txtPreparedBy.Text,
Remarks = txtRemarks.Text,
RequestDate = Convert.ToDateTime(txtDate.Text, System.Globalization.CultureInfo.InvariantCulture),
Requestor = txtRequestor.Text
};
int idmisheader = MIS_Header.Save(oCon, mIS_Header_Model);
DataTable dtTempData = (DataTable)Session["TempData"];
for (int x = 0; x <= dtTempData.Rows.Count - 1; x++)
{
int idItem = Convert.ToInt32(dtTempData.Rows[x][0].ToString());
string item_number = dtTempData.Rows[x][1].ToString();
int qty = Convert.ToInt32(dtTempData.Rows[x][2].ToString());
decimal cost = Convert.ToDecimal(dtTempData.Rows[x][3].ToString());
MIS_Detail_Model mIS_Detail_Model = new MIS_Detail_Model
{
idMISHeader = idmisheader,
Cost = cost,
Quantity = qty,
idItem = idItem
};
int idmisdetail = MIS_Detail.Save(oCon, mIS_Detail_Model);
string dtname = "Ser" + idItem.ToString() + "-" + item_number;
var dt = (DataTable)Session[dtname];
for (int y = 0; y <= dt.Rows.Count - 1; y++)
{
Item_Serial.UpdateStockStatus(oCon, dt.Rows[y][1].ToString(), "N");
MIS_Serial_Model mIS_Serial_Model = new MIS_Serial_Model
{
idMISDetail = idmisdetail,
idSerial = Convert.ToInt32(dt.Rows[y][0].ToString())
};
MIS_Serial.Save(oCon, mIS_Serial_Model);
Trans_History_Model trans_History_Model = new Trans_History_Model
{
Trans_Code = "MIS",
Item_Number = item_number,
Site = "WH-JMS",
UM = "UT",
Doc_No = txtRequestNo.Text,
Serial_No = dt.Rows[y][1].ToString(),
Reason_Code = "",
Trans_Date = DateTime.Now,
Order_No = "",
Invoice_No = "",
Reference_No = txtRefNo.Text,
Trans_Qty = -1,
Trans_Amt = cost,
Remarks = txtRemarks.Text,
user_domain = Session["User_Domain"].ToString()
};
Trans_History.Save(oCon, trans_History_Model);
}
}
Item_Master.InventoryCheckForError(oCon);
clearAll();
dvView.Visible = true;
dvCreate.Visible = false;
GetView();
HttpContext.Current.Response.Write("<script>alert(" + ControlChars.Quote + "MIS Saved!" + ControlChars.Quote + ");</script>");
}
protected void gvView_SelectedIndexChanged(object sender, EventArgs e)
{
Session["WorkMode"] = "View";
dvView.Visible = false;
dvCreate.Visible = true;
GridViewRow row = gvView.SelectedRow;
int idMISHeader = Convert.ToInt32(row.Cells[0].Text.Trim());
txtRequestNo.Text = row.Cells[1].Text.Trim();
txtRequestor.Text = row.Cells[2].Text.Trim();
txtRefNo.Text = row.Cells[3].Text.Trim();
txtPOCMNum.Text = row.Cells[4].Text.Trim();
txtDate.Text = Convert.ToDateTime(row.Cells[5].Text.Trim()).ToShortDateString();
txtPreparedBy.Text = row.Cells[6].Text.Trim();
txtRemarks.Text = row.Cells[7].Text.Trim();
var source = new DataTable();
source.Columns.Add("idItem");
source.Columns.Add("Item Number");
source.Columns.Add("Qty");
source.Columns.Add("Cost");
var detail = MIS_Detail.RetrieveData(oCon, idMISHeader, 0);
for (int x = 0; x <= detail.Count - 1; x++)
{
int iditem = detail[x].idItem;
var master = Item_Master.RetrieveData(oCon, iditem);
string itemnumber = master[0].ItemNumber;
DataRow dr = source.NewRow();
dr[0] = iditem;
dr[1] = itemnumber;
dr[2] = detail[x].Quantity;
dr[3] = detail[x].Cost;
source.Rows.Add(dr);
var serial = MIS_Serial.RetrieveData(oCon, detail[x].idMISDetail, 0);
var serialList = new DataTable();
serialList.Columns.Add("Serial Number");
for (int y = 0; y <= serial.Count - 1; y++)
{
var dtSerial = Item_Serial.RetrieveData(oCon, serial[y].idSerial);
DataRow dr2 = serialList.NewRow();
dr2[0] = dtSerial[0].Serial_No;
serialList.Rows.Add(dr2);
}
string dtName = "Ser" + iditem + "-" + itemnumber;
Session[dtName] = serialList;
}
gvTempGv.DataSource = source;
gvTempGv.DataBind();
btnSave.Visible = false;
btnCancel.Visible = false;
btnAddItemModal.Visible = false;
}
