public IActionResult InsertOwnershipTransfer(CartonOwnershipTransfer cartonOwnership)
{
if (_ownershipRepository.InsertOwnership(cartonOwnership))
{
return(new JsonErrorResult(new { Message = "Ownership Transfered" }, HttpStatusCode.OK));
}
else
{
return(new JsonErrorResult(new { Message = "Ownership Transfer Failed" }, HttpStatusCode.NotFound));
}
}
public bool InsertOwnership(CartonOwnershipTransfer cartonOwnership)
{
List <SqlParameter> parms = new List <SqlParameter>
{
new SqlParameter {
ParameterName = CartonOwnershipTransferStoredProcedure.StoredProcedureParameters[0].ToString(), Value = cartonOwnership.FromCartonNo.AsDbValue()
},
new SqlParameter {
ParameterName = CartonOwnershipTransferStoredProcedure.StoredProcedureParameters[1].ToString(), Value = cartonOwnership.ToCartonNo.AsDbValue()
},
new SqlParameter {
ParameterName = CartonOwnershipTransferStoredProcedure.StoredProcedureParameters[2].ToString(), Value = cartonOwnership.SearchBy.AsDbValue()
},
new SqlParameter {
ParameterName = CartonOwnershipTransferStoredProcedure.StoredProcedureParameters[3].ToString(), Value = cartonOwnership.ToCustomerCode.AsDbValue()
},
new SqlParameter {
ParameterName = CartonOwnershipTransferStoredProcedure.StoredProcedureParameters[4].ToString(), Value = cartonOwnership.UserId.AsDbValue()
}
};
return(_tcContext.Set <BoolReturn>().FromSqlRaw(CartonOwnershipTransferStoredProcedure.Sql, parms.ToArray()).AsEnumerable().First().Value);
}
