public ActionResult AddNewFunc(Cattle p)
{
CattleModel P = new CattleModel();
P.AId = CattleModel.GetNewCattleID();
model.NewPerson = UserLogin.GetPersonInfo(int.Parse(TempData["UserID"].ToString()));
TempData.Keep("UserID");
P.PName = model.NewPerson.PName;
P.PSurname = model.NewPerson.PSurname;
P.Dob = model.NewPerson.Dob;
P.PGender = model.NewPerson.PGender;
P.PAreaCode = model.NewPerson.PAreaCode;
P.PAddress = model.NewPerson.PAddress;
P.PPhoneNum = model.NewPerson.PPhoneNum;
P.PUserAccess = model.NewPerson.PUserAccess;
P.PProvinceName = model.NewPerson.PProvinceName;
P.PCityName = model.NewPerson.PCityName;
P.PCountryname = model.NewPerson.PCountryname;
P.PContinent = model.NewPerson.PContinent;
P.PGpsCoOrdinatesLat = model.NewPerson.PGpsCoOrdinatesLat;
P.PGpsCoOrdinatesLong = model.NewPerson.PGpsCoOrdinatesLong;
P.PNationAnimalID = model.NewPerson.PNationAnimalID;
ModelState.Clear();
return(PartialView("~/Views/RegDashboard/PartialAddNewCow.cshtml", P));
}
public async Task SaveCattleAsync(Cattle cattle)
{
int result = 0;
try
{
if (string.IsNullOrEmpty(cattle.Identifier))
{
throw new Exception("Informe o identificador");
}
if (cattle.ID != 0)
{
result = await conn.UpdateAsync(cattle);
}
else
{
result = await conn.InsertAsync(new Cattle
{
Identifier = cattle.Identifier,
Specie = cattle.Specie,
BirthDate = cattle.BirthDate,
Sex = cattle.Sex,
});
}
StatusMessage = string.Format("{0} registro(s) adicionados [Nome: {1})", result, cattle.Identifier);
}
catch (Exception ex)
{
StatusMessage = string.Format("Falha ao adicionar {0}. Erro: {1}", cattle.Identifier, ex.Message);
}
}
public ActionResult GetLineXYChartData(int AID)
{
List <ChartData> dataList = new List <ChartData>();
Dictionary <string, int> cpts = new Dictionary <string, int>();
Cattle currentCattle = CattleModel.GetCattleInfo(AID);
for (int i = 0; i < currentCattle.CAdultWeightDateHistory.Count; i++)
{
string y = currentCattle.CAdultWeightDateHistory[i].Year.ToString();
string m = currentCattle.CAdultWeightDateHistory[i].Month.ToString();
string d = currentCattle.CAdultWeightDateHistory[i].Day.ToString();
string full2 = y + "-" + m + "-" + d;
dataList.Add(new ChartData {
label = "Boran", valueWeight = currentCattle.CAdultWeightHistory[i], valuex = full2
});
}
MyViewModel model = new MyViewModel();
model.barChart = dataList;
return(Json(model.barChart, JsonRequestBehavior.AllowGet));
}
public GetCattleDTO(Cattle cattle)
{
Id = cattle.Id;
Name = cattle.Name;
Source = cattle.Source;
Image = cattle.Image;
}
private void comboBoxAnimal_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
selectedAnimal = ((Cattle)comboBoxAnimal.SelectedItem);
string gender = selectedAnimal.Gender.Description;
//Added 14 May 2015 - Talha
var maleSt = from st in allStatusesList
where (st.IsFemale == false)
select st.Description;
var femaleSt = from st in allStatusesList
where (st.IsFemale == true)
select st.Description;
//Writing Distinct in same query is making it in a form in which it is not visible in combobox
var maleStDistinct = maleSt.Distinct();
var femaleStDistinct = femaleSt.Distinct();
if (gender == "M")
{
comboBoxStatus.ItemsSource = maleStDistinct;
comboBoxMilkingStatus.SelectedItem = false; //Be careful - It is false as a boolean item
comboBoxMilkingStatus.IsEnabled = false;
}
else
{
comboBoxStatus.ItemsSource = femaleStDistinct;
}
}
public ActionResult DeleteConfirmed(int id)
{
Cattle cattle = db.Cattle.Find(id);
db.Cattle.Remove(cattle);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public bool AddCattle(Cattle cattle)
{
if (cattleDAL.GetAll().Any(x => x.EarringNumber.ToLower() == cattle.EarringNumber.ToLower()))
{
return(false);
}
return(cattleDAL.Add(cattle) > 0);
}
public ActionResult AddCattle(Cattle cattle)
{
if (!new BLL.CattleController().AddCattle(cattle))
{
return(View("AddCattle", new BLL.CattleTypeController().GetAll(cattle.RanchID)));
}
return(RedirectToAction("Index", new { CattleTypeID = cattle.CattleTypeID }));
}
public ActionResult UpdateCattle(Cattle cattle)
{
if (!new BLL.CattleController().UpdateCattle(cattle))
{
return(HttpNotFound());
}
return(RedirectToAction("Index", new { cattle.CattleTypeID }));
}
public async Task <ActionResult> DeleteConfirmed(int id)
{
Cattle cattle = await db.Cattle.FindAsync(id);
db.Cattle.Remove(cattle);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
private List <AnimalMedicalRecord> selectAnimalMedicalRecords(SqlCommand cmd)
{
cmd.CommandType = CommandType.StoredProcedure;
SqlConnection con = cmd.Connection;
List <AnimalMedicalRecord> listAnimalMedicalRecords = new List <AnimalMedicalRecord>();
con.Open();
using (con)
{
SqlDataReader dr = cmd.ExecuteReader();
// amr.[ID] 0
// ,[Date] 1
// ,[Animal]
//,at.[ID] 3
//,at.[Description]
//,a.[BirthDate] 5
// ,[Diagnosis] 6
// ,[Treatment]
// ,[Prognosis] 8
//a.TagNo 9 Added on 31-March
if (dr.HasRows)
{
listAnimalMedicalRecords = new List <AnimalMedicalRecord>();
while (dr.Read())
{
AnimalType currAnimalType = new AnimalType() //2, 3
{
ID = Convert.ToInt32(dr[3]),
Description = Convert.ToString(dr[4])
};
Cattle currAnimal = new Cattle();
currAnimal.ID = Convert.ToInt32(dr[2]);
currAnimal.TagNo = Convert.ToString(dr[9]);
currAnimal.Type = currAnimalType;
AnimalMedicalRecord currAnimalMedicalRecord = new AnimalMedicalRecord
{
ID = Convert.ToInt32(dr[0]),
Diagnosis = Convert.ToString(dr[6]),
Treatment = Convert.ToString(dr[7]),
Prognosis = Convert.ToString(dr[8])
};
currAnimalMedicalRecord.IllAnimal = currAnimal;
currAnimalMedicalRecord.EntryDate = Convert.ToDateTime(dr[1]);
listAnimalMedicalRecords.Add(currAnimalMedicalRecord);
}
}
}
return(listAnimalMedicalRecords);
}
public void CheckControlDigit_SetCorrectValue_ReturnTrue(string input)
{
Cattle cattle = new Cattle()
{
CattleID = input
};
bool result = cattle.CheckControlDigit();
Assert.IsTrue(result);
}
public CreatedCattleDTO(Cattle cattle)
{
Id = cattle.Id;
Name = cattle.Name;
Description = cattle.Description;
Source = cattle.Source;
Image = cattle.Image;
CreatedAt = cattle.CreatedAt;
UpdatedAt = cattle.UpdatedAt;
}
public Task <int> SaveCattleAsync(Cattle cattle)
{
if (cattle.ID != 0)
{
return(_connection.UpdateAsync(cattle));
}
else
{
return(_connection.InsertAsync(cattle));
}
}
public void CheckControlDigit_SetsIncorectString_ReturnFalse(string input)
{
// string input = "123456111000011";
Cattle cattle = new Cattle()
{
CattleID = input
};
bool result = cattle.CheckControlDigit();
Assert.IsFalse(result);
}
public void Cattle_CheckControlDigit_ExternalIdentificationNumber(string input)
{
// string input = "SK0235232";
Cattle cattle = new Cattle()
{
CattleID = input
};
bool result = cattle.CheckControlDigit();
Assert.IsTrue(result);
}
public Task <int> SaveCattleAsync(Cattle cattle)
{
if (cattle.ID != 0)
{
return(_database.UpdateAsync(cattle));
}
else
{
return(_database.InsertAsync(cattle));
}
}
public ActionResult Edit([Bind(Include = "cattleID,cattleNumber,DairyID,feedlotID,DateRecieved,ShippedDate")] Cattle cattle)
{
if (ModelState.IsValid)
{
db.Entry(cattle).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.DairyID = new SelectList(db.Dairy, "DairyID", "dName", cattle.DairyID);
ViewBag.feedlotID = new SelectList(db.Feedlot, "feedlotID", "fName", cattle.FeedlotID);
return(View(cattle));
}
public bool EditCattle(Cattle cattle)
{
try
{
_db.Entry(cattle).State = EntityState.Modified;
_db.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
void OnListViewItemTapped(object sender, ItemTappedEventArgs e)
{
Cattle tappedItem = e.Item as Cattle;
listViewCattle.IsVisible = false;
ButtonAdd.IsVisible = false;
stackLayoutCattle.IsVisible = true;
identifier.Text = tappedItem.Identifier;
specie.SelectedIndex = (int)tappedItem.Specie;
sex.SelectedIndex = (int)tappedItem.Sex;
birthdate.Date = tappedItem.BirthDate.Date;
}
public int Insert(Cattle cattle)
{
int cmd_success;
SqlConnection con = DALHelper.getConnection();
SqlCommand cmd = new SqlCommand("sp_insertAnimal", con); //This procedure is actually for Cattle. In DB Animal = Front-end Cattle
cmd.CommandType = CommandType.StoredProcedure;
#region Procedure Parameters
//@TagNo,
// @RegistrationDate,
//@AnimalType,
//@Gender,
//@BirthDate,
//@Weight,
//@Height,
//@Length,
//@Width,
//@Price,
//@Source,
//@Breed,
//@Status,
//@OtherDetails
#endregion
cmd.Parameters.AddWithValue("@TagNo", DALHelper.getNullORValue(cattle.TagNo));
cmd.Parameters.AddWithValue("@RegistrationDate", DALHelper.getNullORValue(DateTime.Now));
cmd.Parameters.AddWithValue("@AnimalType", DALHelper.getNullORValue(cattle.Type.ID));
cmd.Parameters.AddWithValue("@Gender", DALHelper.getNullORValue(cattle.Gender.Description[0])); //Changed 31-Mar. Now Gender is direct
cmd.Parameters.AddWithValue("@BirthDate", DALHelper.getNullORValue(cattle.BirthDate));
cmd.Parameters.AddWithValue("@Weight", DALHelper.getNullORValue(cattle.CurrPhysicalAttribs.Weight));
cmd.Parameters.AddWithValue("@Height", DALHelper.getNullORValue(cattle.CurrPhysicalAttribs.CurrentSize.Height));
cmd.Parameters.AddWithValue("@Length", DALHelper.getNullORValue(cattle.CurrPhysicalAttribs.CurrentSize.Length));
cmd.Parameters.AddWithValue("@Width", DALHelper.getNullORValue(cattle.CurrPhysicalAttribs.CurrentSize.Width));
cmd.Parameters.AddWithValue("@Price", DALHelper.getNullORValue(cattle.Price));
cmd.Parameters.AddWithValue("@Source", DALHelper.getNullORValue(cattle.Source.ID));
cmd.Parameters.AddWithValue("@Breed", DALHelper.getNullORValue(cattle.Breed.ID));
cmd.Parameters.AddWithValue("@Status", DALHelper.getNullORValue(cattle.Status.ID));
cmd.Parameters.AddWithValue("@IsCalf", 'N'); //Added 31-March as added IsCalf column. Will be N for cattle and Y for Calf
cmd.Parameters.AddWithValue("@OtherDetails", DALHelper.getNullORValue(cattle.OtherDetails));
con.Open();
using (con)
{
//Modified by Talha: Jan 26th, 2012 - Added Return variable to ensure data inserted successfully
cmd_success = cmd.ExecuteNonQuery();
}
return(cmd_success);
}
public ActionResult GetChartDonutData(int AID)
{
//fix this to get data from database
Cattle currentCattle = CattleModel.GetCattleInfo(AID);
List <ChartData> dataList = new List <ChartData>();
Dictionary <String, int> OffSpringBreedTypes = new Dictionary <string, int>();
ChartData details;
MyViewModel model = new MyViewModel();
//once data is retrived
//check if there is data for this animal
if (currentCattle.COffSpring.Count == 0 || currentCattle.COffSpring == null)
{
OffSpringBreedTypes.Add("No offspring \n on Record ", 0);
}
for (int i = 0; i < currentCattle.COffSpring.Count; i++)
{
if (true == OffSpringBreedTypes.ContainsKey(currentCattle.COffSpring[i].ABreed))
{
OffSpringBreedTypes[currentCattle.COffSpring[i].ABreed]++;
}
else
{
OffSpringBreedTypes.Add(currentCattle.COffSpring[i].ABreed, 1);
}
}
foreach (KeyValuePair <string, int> kp in OffSpringBreedTypes)
{
details = new ChartData();
details.label = kp.Key.ToString();
details.value = kp.Value;
dataList.Add(details);
}
model.barChart = dataList;
return(Json(model.barChart, JsonRequestBehavior.AllowGet));
////oper = null which means its first load.
//var jsonSerializer = new JavaScriptSerializer();
//string data = jsonSerializer.Serialize(dataList);
//return data;
}
public ActionResult Create(CowsViewModel model)
{
model.StateSelectList = selectList;
if (ModelState.IsValid)
{
Cattle cow = mapper.Map <Cattle>(model);
cow.CattleTypeId = (int)CattleTypes.Cow;
cow.Sex = (int)Sex.Female;
db.Repository.Add(cow);
db.Commit();
return(RedirectToAction("Index", "Cows"));
}
return(View(model));
}
public ActionResult Edit(int id, SteersViewModel model)
{
model.StateSelectList = selectList;
if (ModelState.IsValid)
{
Cattle steer = mapper.Map <Cattle>(model);
steer.Id = id;
steer.CattleTypeId = (int)CattleTypes.Steer;
db.Repository.Update(steer);
db.Commit();
return(RedirectToAction("Index", "Steers"));
}
return(View(model));
}
public ActionResult Create(SteersViewModel model)
{
model.StateSelectList = selectList;
if (ModelState.IsValid)
{
Cattle steer = mapper.Map <Cattle>(model);
steer.CattleTypeId = (int)CattleTypes.Steer;
steer.Sex = (int)Sex.Male;
db.Repository.Add(steer);
db.Commit();
return(RedirectToAction("Index", "Steers"));
}
return(View(model));
}
public bool CreateCattle(Cattle cattle)
{
try
{
_db.Cattles.Add(cattle);
_db.SaveChanges();
}
catch (Exception)
{
return(false);
}
return(true);
}
public ActionResult Create(CalvesViewModel model)
{
model.StateSelectList = selectList;
model.SexSelectList = sexSelectList;
if (ModelState.IsValid)
{
Cattle calf = mapper.Map <Cattle>(model);
calf.CattleTypeId = (int)CattleTypes.Calf;
db.Repository.Add(calf);
db.Commit();
return(RedirectToAction("Index", "Calves"));
}
return(View(model));
}
public async Task <ActionResult> Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Cattle cattle = await db.Cattle.FindAsync(id);
if (cattle == null)
{
return(HttpNotFound());
}
return(View(cattle));
}
// GET: Cattle/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Cattle cattle = db.Cattle.Find(id);
if (cattle == null)
{
return(HttpNotFound());
}
return(View(cattle));
}
public ActionResult Edit(int id, CowsViewModel model)
{
model.StateSelectList = selectList;
if (ModelState.IsValid)
{
Cattle cow = mapper.Map <Cattle>(model);
cow.Id = id;
cow.CattleTypeId = (int)CattleTypes.Cow;
db.Repository.Update(cow);
db.Commit();
return(RedirectToAction("Index", "Cows"));
}
return(View(model));
}
