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);
}
}
