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, "MIR"); var MIRheader = MIR_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 = MIRheader; gvView.DataBind(); }
protected void btnSave_Click(object sender, EventArgs e) { MIR_Header_Model MIR_Header_Model = new MIR_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 idMIRheader = MIR_Header.Save(oCon, MIR_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()); MIR_Detail_Model MIR_Detail_Model = new MIR_Detail_Model { idMIRHeader = idMIRheader, Cost = cost, Quantity = qty, idItem = idItem }; int idMIRdetail = MIR_Detail.Save(oCon, MIR_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_Model item_Serial_Model = new Item_Serial_Model { idItem = idItem, Serial_No = dt.Rows[y][0].ToString(), InStock = "Y", PO_Number = "", timestamp = DateTime.Now, Unit_Comp = "", Unit_Cost = cost, user_change = Session["User_Domain"].ToString() }; Item_Serial.Save(oCon, item_Serial_Model); int idSerial = Item_Serial.RetrieveIdSerial(oCon, dt.Rows[y][0].ToString()); MIR_Serial_Model MIR_Serial_Model = new MIR_Serial_Model { idMIRDetail = idMIRdetail, idSerial = idSerial }; MIR_Serial.Save(oCon, MIR_Serial_Model); Trans_History_Model trans_History_Model = new Trans_History_Model { Trans_Code = "MIR", Item_Number = item_number, Site = "WH-JMS", UM = "UT", Doc_No = txtRequestNo.Text, Serial_No = dt.Rows[y][0].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; HttpContext.Current.Response.Write("<script>alert(" + ControlChars.Quote + "MIR Saved!" + ControlChars.Quote + ");</script>"); }