public static bool UpdateAnimal(AnimalUpdate editedAnimal) { try { using (AnimalInformationContext databaseModel = new AnimalInformationContext()) { var v = databaseModel.AnimalInformations.SingleOrDefault(a => a.PKAnimalId == editedAnimal.PKAnimalId); if (v != null) { v.AnimalCodeName = editedAnimal.AnimalCodeName; v.AnimalTypeId = editedAnimal.AnimalType; v.Comments = editedAnimal.Comments; v.DateofEntry = editedAnimal.DateofEntry; v.DateofExit = editedAnimal.DateofExit; v.Gender = editedAnimal.Gender; v.IsDeleted = editedAnimal.IsDeleted; databaseModel.SaveChanges(); return(true); } return(false); } } catch (Exception ec) { return(false); } }
//-------------------- Animal Vaccine ------------------------------------- #region public static bool AddAnimalVaccine(AnimalVaccineAdd newentry, string operatorname) { try { using (AnimalInformationContext datamodel = new AnimalInformationContext()) { var animal = AnimalInformationDBAcces.GetAnimalInfoByID(newentry.AnimalId); if (animal != null) { Vaccination add = new Vaccination(); add.AnimalId = newentry.AnimalId; add.VaccinationDate = newentry.VaccinationDate; add.VaccineName = newentry.VaccineName; add.NextVaccationDate = newentry.NextVaccationDate; add.Comments = newentry.Comments; add.IsApplied = true; add.OperatorName = operatorname; datamodel.Vaccinations.Add(add); datamodel.SaveChanges(); return(true); } return(false); } } catch (Exception ex) { return(false); } }
public static bool CowHeatUpdate(CowHeat updatedHeatInfo) { try { using (AnimalInformationContext databaseModel = new AnimalInformationContext()) { var v = databaseModel.CowHeat.SingleOrDefault(a => a.AnimalId == updatedHeatInfo.AnimalId && a.HeatDate == updatedHeatInfo.HeatDate.Date); if (v != null) { v.ActualDeliveryDate = updatedHeatInfo.ActualDeliveryDate; v.AnimalId = updatedHeatInfo.AnimalId; v.DeliveryStatus = updatedHeatInfo.DeliveryStatus; v.ExpectedDeliveryDate = updatedHeatInfo.ExpectedDeliveryDate; v.HeatDate = updatedHeatInfo.HeatDate; v.HeatSummary = updatedHeatInfo.HeatSummary; v.HeatTime = updatedHeatInfo.HeatTime; v.InjectedDate = updatedHeatInfo.InjectedDate; v.InjectedTime = updatedHeatInfo.InjectedTime; v.NextHeatDate = updatedHeatInfo.NextHeatDate; v.OperatorName = updatedHeatInfo.OperatorName; databaseModel.SaveChanges(); return(true); } else { return(false); } } } catch (Exception ec) { return(false); } }
//-------------------- Milk Production ------------------------------------- #region public static bool AddOrUpdateMilkProduction(List <MilkProduction> ProductionList) { try { using (AnimalInformationContext dataModel = new AnimalInformationContext()) { foreach (var milk in ProductionList) { var v = dataModel.MilkProduction.SingleOrDefault(a => a.Date == milk.Date && a.AnimalId == milk.AnimalId); if (v != null) { v.MorningAmount = milk.MorningAmount; v.AfternoonAmount = milk.AfternoonAmount; v.OperatorName = milk.OperatorName; dataModel.SaveChanges(); } else { MilkProduction tmp = new MilkProduction(); tmp.Date = milk.Date; tmp.AnimalId = milk.AnimalId; tmp.AfternoonAmount = milk.AfternoonAmount; tmp.MorningAmount = milk.MorningAmount; tmp.OperatorName = milk.OperatorName; dataModel.MilkProduction.Add(tmp); dataModel.SaveChanges(); } } return(true); } } catch (Exception e) { return(false); } }
public static bool AddHeat(CowHeat newHeatInfo) { try { using (AnimalInformationContext datamodel = new AnimalInformationContext()) { datamodel.CowHeat.Add(newHeatInfo); datamodel.SaveChanges(); return(true); } } catch (Exception ex) { return(false); } }
public static bool AddAnimalType(AnimalType animalType) { try { using (AnimalInformationContext databaseModel = new AnimalInformationContext()) { databaseModel.AnimalTypes.Add(animalType); databaseModel.SaveChanges(); return(true); } } catch (Exception ex) { return(false); } }
public static bool AddMedicationDose(MedicineCourse newentry) { try { using (AnimalInformationContext datamodel = new AnimalInformationContext()) { datamodel.MedicineCourses.Add(newentry); datamodel.SaveChanges(); return(true); } } catch (Exception ex) { return(false); } }
public static bool AddVaccination(AnimalVaccinationInfoAdd newentry, string operatorname) { try { using (AnimalInformationContext datamodel = new AnimalInformationContext()) { foreach (var item in newentry.VaccinationInfo) { Vaccination add = new Vaccination(); add.AnimalId = item.AnimalId; add.VaccinationDate = newentry.VaccinationDate; add.VaccineName = newentry.VaccineName; add.NextVaccationDate = newentry.NextVaccationDate; add.Comments = item.Comments; add.IsApplied = item.isNotApplied ? false : true; add.OperatorName = operatorname; datamodel.Vaccinations.Add(add); datamodel.SaveChanges(); } if (newentry.GetNotiFication) { List <Notification> NotificationInfo = new List <Notification>(); var typeinf = datamodel.AnimalTypes.Where(a => a.PKAnimalTypeId == newentry.AnimalTypeId).FirstOrDefault(); for (int i = -3; i < 1; i++) { NotificationInfo.Add(new Notification { Date = newentry.NextVaccationDate.Date.AddDays(i), NotificationMessage = "Animal type: " + typeinf.AnimalTypeName + ", next Vaccination Date of: " + newentry.VaccineName + " is " + newentry.NextVaccationDate.ToString("dddd, dd MMMM yyyy"), GroupID = "Vaccine" + newentry.VaccineName + newentry.VaccinationDate.ToString("MM/dd/yyyy") }); } AgroExpressDBAccess.AddNotificationList(NotificationInfo); } return(true); } } catch (Exception ex) { return(false); } }
public static bool DeleteMedicationCourse(int id, DateTime date) { try { using (AnimalInformationContext datamodel = new AnimalInformationContext()) { var v = datamodel.MedicineCourses.Where(a => a.medicationId == id && a.MedicationDate == date).SingleOrDefault(); if (v != null) { datamodel.MedicineCourses.Remove(v); datamodel.SaveChanges(); return(true); } return(false); } } catch (Exception ex) { return(false); } }
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); } }
public static bool EnableAnimal(int animalID) { try { using (AnimalInformationContext databaseModel = new AnimalInformationContext()) { var v = databaseModel.AnimalInformations.SingleOrDefault(a => a.PKAnimalId == animalID); if (v != null) { v.IsDeleted = false; databaseModel.SaveChanges(); return(true); } return(false); } } catch (Exception ec) { return(false); } }
public static string AddAnimalWeightList(List <AnimalWeight> requestList) { try { using (AnimalInformationContext databaseModel = new AnimalInformationContext()) { if (requestList != null) { foreach (var insert in requestList) { databaseModel.AnimalWeight.AddOrUpdate(insert); databaseModel.SaveChanges(); } return("OK"); } return("not inserted"); } } catch (Exception ec) { return(ec.Message); } }
public static bool UpdateVaccination(AnimalVaccineEdit editentry, string operatorname) { try { using (AnimalInformationContext datamodel = new AnimalInformationContext()) { var vaccine = datamodel.Vaccinations.SingleOrDefault(a => a.PKVaccinationId == editentry.PKVaccinationId); if (vaccine != null) { vaccine.NextVaccationDate = editentry.NextVaccationDate; vaccine.Comments = editentry.Comments; vaccine.OperatorName = operatorname; datamodel.SaveChanges(); return(true); } return(false); } } catch (Exception ex) { return(false); } }
public static bool DisableAnimalType(int typeID) { try { using (AnimalInformationContext datamodel = new AnimalInformationContext()) { var v = datamodel.AnimalTypes.Where(a => a.PKAnimalTypeId == typeID).FirstOrDefault(); if (v != null) { v.IsDeleted = true; datamodel.SaveChanges(); return(true); } else { return(false); } } } catch (Exception ex) { return(false); } }
//-------------------- Animal Medication ------------------------------------- #region public static bool AddAnimalMedication(AnimalMdicationAdd newentry, string operatorname) { try { using (AnimalInformationContext datamodel = new AnimalInformationContext()) { var animal = AnimalInformationDBAcces.GetAnimalInfoByID((int)newentry.AnimalId); if (animal != null) { Medication add = new Medication(); add.AnimalId = (int)newentry.AnimalId; add.MedicationDate = newentry.MedicationDate; add.MedicineName = newentry.MedicineName; add.Comments = newentry.Comments; add.OperatorName = operatorname; datamodel.Medication.Add(add); datamodel.SaveChanges(); var medicineid = datamodel.Medication.SingleOrDefault(a => a.MedicationDate == newentry.MedicationDate && a.MedicineName == newentry.MedicineName && a.AnimalId == newentry.AnimalId); bool isinserted = false; if (medicineid.PKMedicationId != 0) { var animalInfo = datamodel.AnimalInformations.Where(a => a.PKAnimalId == newentry.AnimalId).FirstOrDefault(); var medicationdates = newentry.SelectedCourseDates; Char delimiter = ','; string[] split = medicationdates.Split(delimiter); string dates; List <Notification> NotificationInfo = new List <Notification>(); for (var i = 0; i < split.Length; i++) { MedicineCourse addnew = new MedicineCourse(); addnew.medicationId = medicineid.PKMedicationId; addnew.Dose = newentry.Dose; addnew.status = true; dates = split[i]; var sourcedater = DateTime.Parse(dates); var date = sourcedater.ToString("M/d/yyyy"); DateTime outputdater; DateTime.TryParseExact(date.ToString(), "M/d/yyyy", CultureInfo.InvariantCulture, DateTimeStyles.None, out outputdater); addnew.MedicationDate = outputdater; if (AnimalInformationDBAcces.AddMedicationDose(addnew)) { if (newentry.GetNotiFication) { var typeinf = datamodel.AnimalTypes.Where(a => a.PKAnimalTypeId == newentry.AnimalTypeId).FirstOrDefault(); for (int index = -1; index < 1; index++) { NotificationInfo.Add(new Notification { Date = addnew.MedicationDate.Date.AddDays(index), NotificationMessage = "Animal code name: " + animalInfo.AnimalCodeName + ", Medicine Name: " + newentry.MedicineName + ", Date: " + addnew.MedicationDate.ToString("dddd, dd MMMM yyyy"), GroupID = "Medicine" + newentry.MedicineName + newentry.MedicationDate.ToString("MM/dd/yyyy") }); } } isinserted = true; } } if (newentry.GetNotiFication) { AgroExpressDBAccess.AddNotificationList(NotificationInfo); } } if (isinserted == true) { return(true); } } return(false); } } catch (Exception ex) { return(false); } }