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