public List <getConsumeRequirementById> GetConsumeRequirement(getConsumeRequirement objContract)
{
List <getConsumeRequirementById> contract = new List <getConsumeRequirementById>();
using (DbLayer dbLayer = new DbLayer())
{
SqlCommand SqlCmd = new SqlCommand("spSelectConsumableRequirement");
SqlCmd.CommandType = CommandType.StoredProcedure;
SqlCmd.Parameters.AddWithValue("@ContractId", objContract.ContractId);
SqlCmd.Parameters.AddWithValue("@ActionBy", objContract.ActionBy);
contract = dbLayer.GetEntityList <getConsumeRequirementById>(SqlCmd);
}
return(contract);
}
public HttpResponseMessage GetAllConsumeById(getConsumeRequirement objContract)
{
HttpResponseMessage message;
try
{
// ContractDetailsDataAccessLayer dal = new ContractDetailsDataAccessLayer();
var dynObj = new { result = _obj.GetConsumeRequirement(objContract) };
message = Request.CreateResponse(HttpStatusCode.OK, dynObj);
}
catch (Exception ex)
{
message = Request.CreateResponse(HttpStatusCode.BadRequest, new { msgText = "Somthing wrong, Try Again!" });
ErrorLog.CreateErrorMessage(ex, "ContractDetails", "GetAllConsumeById");
}
return(message);
}