private void GetView() { //var dt = new DataTable(); //dt.Columns.Add("Trans Code"); //dt.Columns.Add("Item Number"); //dt.Columns.Add("Site"); //dt.Columns.Add("Doc Number"); //dt.Columns.Add("Serial Number"); //dt.Columns.Add("Transaction Date"); //var mdl = Trans_History.RetrieveData(oCon, "MIS"); var misheader = MIS_Header.RetrieveData(oCon, txtSearchRequest.Text); //for (int x = 0; x <= mdl.Count - 1; x++) //{ // DataRow dr = dt.NewRow(); // dr[0] = mdl[x].Trans_Code; // dr[1] = mdl[x].Item_Number; // dr[2] = mdl[x].Site; // dr[3] = mdl[x].Doc_No; // dr[4] = mdl[x].Serial_No; // dr[5] = mdl[x].Trans_Date; // dt.Rows.Add(dr); //} gvView.DataSource = misheader; gvView.DataBind(); }
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>"); }