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