public string ReceiptStatusBack(AddReceiptAndReceiptDetailRequest request, int ToStatus)
{
using (SqlConnection conn = new SqlConnection(BaseAccessor._dataBase.ConnectionString))
{
string message = "";
try
{
if (request.Receipts.Count() == 1)
{
SqlCommand cmd = new SqlCommand("[Proc_WMS_ReceiptReceivingStatusBack]", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ID", request.Receipts.Select(m => m.ID).FirstOrDefault().ObjectToInt64());
cmd.Parameters[0].SqlDbType = SqlDbType.BigInt;
cmd.Parameters.AddWithValue("@ToStatus", ToStatus);
cmd.Parameters[1].SqlDbType = SqlDbType.Int;
cmd.Parameters.AddWithValue("@message", message);
cmd.Parameters[2].SqlDbType = SqlDbType.NVarChar;
cmd.Parameters[2].Direction = ParameterDirection.Output;
cmd.Parameters[2].Size = 50;
cmd.CommandTimeout = 300;
conn.Open();
DataSet ds = new DataSet();
SqlDataAdapter sda = new SqlDataAdapter();
sda.SelectCommand = cmd;
sda.Fill(ds);
message = sda.SelectCommand.Parameters["@message"].Value.ToString();
conn.Close();
return(message);
}
else
{
SqlCommand cmd = new SqlCommand("[Proc_WMS_ReceiptReceivingStatusBack_Batch]", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Receipt", request.Receipts.Select(receipt => new WMSReceiptToDb(receipt)));
cmd.Parameters[0].SqlDbType = SqlDbType.Structured;
cmd.Parameters.AddWithValue("@ToStatus", ToStatus);
cmd.Parameters[1].SqlDbType = SqlDbType.Int;
cmd.Parameters.AddWithValue("@message", message);
cmd.Parameters[2].SqlDbType = SqlDbType.NVarChar;
cmd.Parameters[2].Direction = ParameterDirection.Output;
cmd.Parameters[2].Size = 50;
cmd.CommandTimeout = 300;
conn.Open();
DataSet ds = new DataSet();
SqlDataAdapter sda = new SqlDataAdapter();
sda.SelectCommand = cmd;
sda.Fill(ds);
message = sda.SelectCommand.Parameters["@message"].Value.ToString();
conn.Close();
return(message);
}
}
catch (Exception ex)
{
return(message + "(" + ex.Message + ")");
}
}
}
public Response <string> ReceiptStatusBack(AddReceiptAndReceiptDetailRequest request, int ToStatus)
{
Response <string> response = new Response <string>();
string message = "";
if (request == null || request.Receipts == null || !request.Receipts.Any())
{
ArgumentNullException ex = new ArgumentNullException("AddReceiptAndReceiptDetail request");
LogError(ex);
response.ErrorCode = ErrorCode.Argument;
response.Exception = ex;
return(response);
}
try
{
message = new ReceiptManagementAccessor().ReceiptStatusBack(request, ToStatus);
if (message == "")
{
response.Result = message;
response.IsSuccess = true;
}
else
{
response.Result = message;
response.IsSuccess = false;
}
return(response);
}
catch (Exception ex)
{
LogError(ex);
response.IsSuccess = false;
response.ErrorCode = ErrorCode.Technical;
response.Result = message + ex.Message;
}
return(response);
}
public Response <string> AddReceiptAndReceiptDetail_ScanSKU(AddReceiptAndReceiptDetailRequest request, long CustomerID, string Creator)
{
Response <string> response = new Response <string>();
string message = "";
if (request == null)
{
ArgumentNullException ex = new ArgumentNullException("AddReceiptAndReceiptDetail_ScanSKU request");
LogError(ex);
response.ErrorCode = ErrorCode.Argument;
response.Exception = ex;
return(response);
}
try
{
message = new ReceiptManagementAccessor().AddReceiptAndReceiptDetail_ScanSKU(request, CustomerID, Creator);
if (message == "")
{
response.Result = message;
response.IsSuccess = true;
}
else
{
response.Result = message;
response.IsSuccess = false;
}
return(response);
}
catch (Exception ex)
{
LogError(ex);
response.IsSuccess = false;
response.ErrorCode = ErrorCode.Technical;
response.Result = message + ex.Message;
}
return(response);
}
