public ActionResult _FatherAdd(int id)
{
// Load Male Animals
ViewData["MaleParents"] = commonRep.GetMaleAnimalsDropDown(id);
AnimalRelationship ins = new AnimalRelationship(id);
return PartialView(ins);
}
public AnimalRelationship InsertAnimalRelationship(AnimalRelationship ins)
{
AnimalRelationship ReturnObject = new AnimalRelationship();
int ModifiedBy = (int)HttpContext.Current.Session["UserNo"];
DataBaseConnection dbConn = new DataBaseConnection();
SqlConnection con = dbConn.SqlConn();
con.Open();
SqlCommand cmdI = con.CreateCommand();
SqlTransaction trx = con.BeginTransaction(CommonStrings.InsertTransaction);
cmdI.Connection = con;
cmdI.Transaction = trx;
try
{
cmdI.Parameters.Clear();
cmdI.CommandText = CommonStrings.InsertAnimalRelationship;
cmdI.CommandType = System.Data.CommandType.StoredProcedure;
cmdI.Parameters.AddWithValue("@ParentId", ins.ParentAnimalId);
cmdI.Parameters.AddWithValue("@ChildId", ins.ChildAnimalId);
cmdI.Parameters.AddWithValue("@ModifiedDate", DateTime.Now);
cmdI.Parameters.AddWithValue("@ModifiedBy", ModifiedBy);
cmdI.Parameters.AddWithValue("@Removed", false);
ins.RelationshipId = (int)cmdI.ExecuteScalar();
trx.Commit();
cmdI.Connection.Close();
}
catch (SqlException ex)
{
if (trx != null)
{
trx.Rollback();
}
}
finally
{
if (con.State != ConnectionState.Closed)
{
con.Close();
}
con.Dispose();
cmdI.Dispose();
trx.Dispose();
}
return(ins);
}
public JsonResult _InsertBirthHistory(BirthHistory ins)
{
ins = aiRep.InsertBirthHistory(ins);
if((ins.HistoryId != 0) && (ins.ChildId != 0))
{
AnimalRelationship father = new AnimalRelationship();
father.ParentAnimalId = ins.MaleParentId;
father.ChildAnimalId = ins.ChildId;
father = animalRep.InsertAnimalRelationship(father);
AnimalRelationship mother = new AnimalRelationship();
mother.ParentAnimalId = ins.FemaleParentId;
mother.ChildAnimalId = ins.ChildId;
mother = animalRep.InsertAnimalRelationship(mother);
}
return Json(new GridModel(commonRep.GetBirthHistories()));
}
public AnimalRelationship InsertAnimalRelationshipSim(AnimalRelationship ins)
{
AnimalRelationship ReturnObject = new AnimalRelationship();
DataBaseConnection dbConn = new DataBaseConnection();
SqlConnection con = dbConn.SqlConn();
con.Open();
SqlCommand cmdI = con.CreateCommand();
SqlTransaction trx = con.BeginTransaction(CommonStrings.InsertTransaction);
cmdI.Connection = con;
cmdI.Transaction = trx;
try
{
cmdI.Parameters.Clear();
cmdI.CommandText = CommonStrings.InsertAnimalRelationship;
cmdI.CommandType = System.Data.CommandType.StoredProcedure;
cmdI.Parameters.AddWithValue("@ParentId", ins.ParentAnimalId);
cmdI.Parameters.AddWithValue("@ChildId", ins.ChildAnimalId);
cmdI.Parameters.AddWithValue("@ModifiedDate", ins.ModiefiedDate);
cmdI.Parameters.AddWithValue("@ModifiedBy", ins.ModifiedBy);
cmdI.Parameters.AddWithValue("@Removed", false);
ins.RelationshipId = (int)cmdI.ExecuteScalar();
trx.Commit();
cmdI.Connection.Close();
}
catch (SqlException ex)
{
if (trx != null) trx.Rollback();
}
finally
{
if (con.State != ConnectionState.Closed)
{
con.Close();
}
con.Dispose();
cmdI.Dispose();
trx.Dispose();
}
return ins;
}
public ActionResult _AddParent(AnimalRelationship ins)
{
ins = animalRep.InsertAnimalRelationship(ins);
return RedirectToAction("Tag", new { id = ins.ChildAnimalId });
}
public JsonResult AddBirthScenario(int FemaleId, int MaleId, int ChildId, int TubeId, int BirthTypeId, int Success, int CompanyId, int UserKey, DateTime ModifiedDate)
{
//...Check if Tube was used
if(TubeId != 0)
{
//...Tube was used, save history record
InseminationHistory insem = new InseminationHistory();
insem.AnimalId = FemaleId;
insem.TubeId = TubeId;
insem.CompanyId = CompanyId;
insem.ModifiedBy = UserKey;
insem.ModifiedDate = ModifiedDate.AddDays(-274);
insem = aiRep.InsertInseminationHistorySim(insem);
if(insem.HistoryId == 0)
{
return Json(insem.HistoryId, JsonRequestBehavior.AllowGet);
}
}
//...Insert Birth History
BirthHistory birth = new BirthHistory();
birth.BirthTypeId = BirthTypeId;
birth.ChildId = ChildId;
birth.CompanyId = CompanyId;
birth.FemaleParentId = FemaleId;
birth.MaleParentId = MaleId;
birth.ModifiedBy = UserKey;
birth.Success = (Success == 1) ? true : false;
birth.TubeId = TubeId;
birth.ModifiedDate = ModifiedDate;
birth = aiRep.InsertBirthHistorySim(birth);
if ((birth.HistoryId != 0) && (birth.ChildId != 0))
{
AnimalRelationship father = new AnimalRelationship();
father.ParentAnimalId = birth.MaleParentId;
father.ChildAnimalId = birth.ChildId;
father.ModiefiedDate = ModifiedDate;
father.ModifiedBy = UserKey;
father = aniRep.InsertAnimalRelationshipSim(father);
AnimalRelationship mother = new AnimalRelationship();
mother.ParentAnimalId = birth.FemaleParentId;
mother.ChildAnimalId = birth.ChildId;
mother.ModiefiedDate = ModifiedDate;
mother.ModifiedBy = UserKey;
mother = aniRep.InsertAnimalRelationshipSim(mother);
}
return Json(birth.HistoryId, JsonRequestBehavior.AllowGet);
}
