public IActionResult VoidMoveticket(DataSourceLoadOptions loadOptions, string moveticket, string Model) { var identity = (ClaimsIdentity)User.Identity; IEnumerable <Claim> claims = identity.Claims; var userLogin = claims.FirstOrDefault(); //var status = ""; string txtMoveTicket = ""; string txtDeliveryNote = ""; string txtBoxType = ""; string txtTagType = ""; int txtQtyMT = 0; string txtStatusMT = ""; int txtNumOfBox = 0; int txtQtyExcess = 0; string txtRemarks = ""; DateTime txtCreateDate; //DateTime txtTransDate; //string txtModifyBy = ""; string txtMoveTicketUserDef1 = ""; string txtMoveTicketUserDef2 = ""; string txtMoveTicketUserDef3 = ""; if (moveticket != "" && Model != "") { try { using (var cmd = _context.Database.GetDbConnection().CreateCommand()) { cmd.Parameters.Clear(); cmd.CommandText = "m_sp_Void_Moveticket"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@model", SqlDbType.NVarChar) { Value = Model }); cmd.Parameters.Add(new SqlParameter("@moveticket", SqlDbType.NVarChar) { Value = moveticket }); cmd.Parameters.Add(new SqlParameter("@ModifyBy", SqlDbType.NVarChar) { Value = userLogin.Value }); if (cmd.Connection.State != ConnectionState.Open) { cmd.Connection.Open(); } DataTable dt = new DataTable(); DbDataReader DbReader = cmd.ExecuteReader(); if (DbReader.HasRows) { dt.Load(DbReader); foreach (DataRow dr in dt.Select()) { if (dr["MoveTicket"] != System.DBNull.Value) { txtMoveTicket = (string)dr["MoveTicket"]; } if (dr["DeliveryNote"] != System.DBNull.Value) { txtDeliveryNote = (string)dr["DeliveryNote"]; } if (dr["BoxType"] != System.DBNull.Value) { txtBoxType = (string)dr["BoxType"]; } if (dr["TagType"] != System.DBNull.Value) { txtTagType = (string)dr["TagType"]; } if (dr["QtyMT"] != System.DBNull.Value) { txtQtyMT = (int)dr["QtyMT"]; } if (dr["StatusMT"] != System.DBNull.Value) { txtStatusMT = (string)dr["StatusMT"]; } if (dr["NumOfBox"] != System.DBNull.Value) { txtNumOfBox = (int)dr["NumOfBox"]; } if (dr["QtyExcess"] != System.DBNull.Value) { txtQtyExcess = (int)dr["QtyExcess"]; } if (dr["Remarks"] != System.DBNull.Value) { txtRemarks = (string)dr["Remarks"]; } if (dr["MoveTicketUserDef1"] != System.DBNull.Value) { txtMoveTicketUserDef1 = (string)dr["MoveTicketUserDef1"]; } if (dr["MoveTicketUserDef2"] != System.DBNull.Value) { txtMoveTicketUserDef2 = (string)dr["MoveTicketUserDef2"]; } if (dr["MoveTicketUserDef3"] != System.DBNull.Value) { txtMoveTicketUserDef3 = (string)dr["MoveTicketUserDef3"]; } //txtTransDate = (DateTime)dr["TransDate"]; txtCreateDate = (DateTime)dr["CreateDate"]; //txtModifyBy = (string)dr["ModifyBy"]; move = new MoveTicketViewModel { moveTicket = txtMoveTicket, DeliveryNote = txtDeliveryNote, BoxType = txtBoxType, TagType = txtTagType, QtyMT = txtQtyMT, StatusMT = txtStatusMT, NumOfBox = txtNumOfBox, QtyExcess = txtQtyExcess, Remarks = txtRemarks, //TransDate = txtTransDate, CreateDate = txtCreateDate, //ModifyBy = txtModifyBy, MoveTicketUserDef1 = txtMoveTicketUserDef1, MoveTicketUserDef2 = txtMoveTicketUserDef2, MoveTicketUserDef3 = txtMoveTicketUserDef3, SqlStatus = "Success", SqlErrtext = "" }; } } cmd.Connection.Close(); } } catch (SqlException ex) { move = new MoveTicketViewModel { SqlStatus = "Error", SqlErrtext = ex.Message }; } } return(new JsonResult(move)); }
public IActionResult CallStore(string model, string BoxType, string TagType, int QtyMT, int packQty, int NumOfBox, int QtyExcess) { var identity = (ClaimsIdentity)User.Identity; IEnumerable <Claim> claims = identity.Claims; var userID = claims.FirstOrDefault(); string txtMoveTicket = ""; string txtBoxNo = ""; string txtBarcode = ""; int txtQtyLot = 0; string txtStatusLot = ""; DateTime txtCreateDate; if (TagType == null) { TagType = "NULL"; } try { using (var cmd = _context.Database.GetDbConnection().CreateCommand()) { cmd.Parameters.Clear(); cmd.CommandText = "m_sp_InsertMoveticket"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@model", SqlDbType.NVarChar) { Value = model }); cmd.Parameters.Add(new SqlParameter("@BoxType", SqlDbType.NVarChar) { Value = BoxType }); cmd.Parameters.Add(new SqlParameter("@TagType", SqlDbType.NVarChar) { Value = TagType }); cmd.Parameters.Add(new SqlParameter("@packQty", SqlDbType.Int) { Value = packQty }); cmd.Parameters.Add(new SqlParameter("@QtyMT", SqlDbType.Int) { Value = QtyMT }); cmd.Parameters.Add(new SqlParameter("@NumOfBox", SqlDbType.Int) { Value = NumOfBox }); cmd.Parameters.Add(new SqlParameter("@QtyExcess", SqlDbType.Int) { Value = QtyExcess }); cmd.Parameters.Add(new SqlParameter("@userID", SqlDbType.NVarChar) { Value = userID.Value }); if (cmd.Connection.State != ConnectionState.Open) { cmd.Connection.Open(); } DataTable dt = new DataTable(); //dt.Columns.Add("SqlStatus", typeof(System.String)); //dt.Columns.Add("SqlErrtext", typeof(System.String)); DbDataReader DbReader = cmd.ExecuteReader(); //foreach (DataRow row in dt.Rows) //{ // row["SqlStatus"] = ""; // row["SqlErrtext"] = ""; //} if (DbReader.HasRows) { dt.Load(DbReader); foreach (DataRow dr in dt.Select()) { var wp = _context.WeeklyPlan.FirstOrDefault(w => w.BarCode == (string)dr["Barcode"]); wp.QtyPacked = wp.QtyPacked + (int)dr["QtyLot"]; wp.UpdateDate = (DateTime)dr["CreateDate"]; _context.WeeklyPlan.Update(wp); _context.SaveChanges(); if (dr["MoveTicket"] != System.DBNull.Value) { txtMoveTicket = (string)dr["MoveTicket"]; } if (dr["BoxNo"] != System.DBNull.Value) { txtBoxNo = (string)dr["BoxNo"]; } if (dr["Barcode"] != System.DBNull.Value) { txtBarcode = (string)dr["Barcode"]; } if (dr["QtyLot"] != System.DBNull.Value) { txtQtyLot = (int)dr["QtyLot"]; } if (dr["StatusLot"] != System.DBNull.Value) { txtStatusLot = (string)dr["StatusLot"]; } //if (dr["CreateDate"] != System.DBNull.Value) //{ // txtStatusMT = (DateTime)dr["CreateDate"]; //} ////txtTransDate = (DateTime)dr["TransDate"]; txtCreateDate = (DateTime)dr["CreateDate"]; //move.SqlStatus = "Success"; //move.SqlErrtext = ""; //txtModifyBy = (string)dr["ModifyBy"]; move = new MoveTicketViewModel { moveTicket = txtMoveTicket, BoxNo = txtBoxNo, Barcode = txtBarcode, QtyLot = txtQtyLot, StatusLot = txtStatusLot, CreateDate = txtCreateDate, //ModifyBy = txtModifyBy, SqlStatus = "Success", SqlErrtext = "" }; } } cmd.Connection.Close(); } } catch (SqlException ex) { move = new MoveTicketViewModel { SqlStatus = "Error", SqlErrtext = ex.Message }; } return(new JsonResult(move)); // _context.Database.ExecuteSqlCommand("dbo.m_sp_Model_Moveticket @model,@BoxType,@TagType,@QtyMT,@packQty,@NumOfBox,@QtyExcess", parameters: new[] { "KPPA INT", "B2", "T1", "850", "200", "5", "50" }); }