public ApiResponse <long> InsertOrderPart(OrderPartEntity model)
{
var response = new ApiResponse <long>();
try
{
int IsAdmin = model.RoleName == "Administrator" ? 1 : 0;
SqlParameter[] param =
{
new SqlParameter("OrderId", (object)model.OrderId ?? (object)DBNull.Value)
, new SqlParameter("LocID", (object)model.LocID ?? (object)DBNull.Value)
, new SqlParameter("Contact", (object)model.Contact ?? (object)DBNull.Value)
, new SqlParameter("RecType", (object)model.RecordTypeId ?? (object)DBNull.Value)
, new SqlParameter("Notes", (object)model.Notes ?? (object)DBNull.Value)
, new SqlParameter("Scope", (object)model.Scope ?? (object)DBNull.Value)
, new SqlParameter("CreatedBy", (object)model.EmpId ?? (object)DBNull.Value)
, new SqlParameter("IsAdmin", (object)IsAdmin ?? (object)DBNull.Value)
};
var result = _repository.ExecuteSQL <long>("InsertOrderPart", param).FirstOrDefault();
if (result > 0)
{
response.Success = true;
response.str_ResponseData = result.ToString();
}
}
catch (Exception ex)
{
response.Message.Add(ex.Message);
}
return(response);
}
public BaseApiResponse UpdateOrderPart(OrderPartEntity model)
{
var response = new BaseApiResponse();
try
{
SqlParameter[] param =
{
new SqlParameter("OrderId", (object)model.OrderId ?? (object)DBNull.Value)
, new SqlParameter("PartNo", (object)model.PartNo ?? (object)DBNull.Value)
, new SqlParameter("LocID", (object)model.LocID ?? (object)DBNull.Value)
, new SqlParameter("RecType", (object)model.RecordTypeId ?? (object)DBNull.Value)
, new SqlParameter("Notes", (object)model.Notes ?? (object)DBNull.Value)
, new SqlParameter("Scope", (object)model.Scope ?? (object)DBNull.Value)
, new SqlParameter("CreatedBy", (object)model.EmpId ?? (object)DBNull.Value)
};
var result = _repository.ExecuteSQL <int>("UpdateOrderPart", param).FirstOrDefault();
if (result == 1)
{
response.Success = true;
response.str_ResponseData = result.ToString();
}
}
catch (Exception ex)
{
response.Message.Add(ex.Message);
}
return(response);
}
