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; }