public static AnimalWeightInfoView AnimalWeightViewFormatSingle(AnimalWeight request)
{
AnimalWeightInfoView returnList = new AnimalWeightInfoView();
try
{
using (AnimalInformationContext contex = new AnimalInformationContext())
{
var animalinfo = contex.AnimalInformations.Include("animalType").Where(a => a.PKAnimalId == request.AnimalId).FirstOrDefault();
returnList.animalId = animalinfo.PKAnimalId;
returnList.Date = request.Date;
returnList.animalCodeName = animalinfo.AnimalCodeName;
returnList.gender = animalinfo.Gender;
returnList.animalType = animalinfo.animalType.AnimalTypeName;
returnList.Weight = request.Weight;
returnList.animalTypeId = animalinfo.AnimalTypeId;
return(returnList);
}
}
catch (Exception e)
{
return(null);
}
}
public static string UpdateAnimalWeight(AnimalWeightInfoView editedWeight)
{
try
{
using (AnimalInformationContext dataModel = new AnimalInformationContext())
{
var v = dataModel.AnimalWeight.SingleOrDefault(a => a.AnimalId == editedWeight.animalId && a.Date == editedWeight.Date);
if (v != null)
{
v.Weight = editedWeight.Weight;
dataModel.SaveChanges();
return("OK");
}
return("No Such Record is Found.");
}
}
catch (Exception e)
{
return(e.Message);
}
}