public string DeleteDivision(PhytoDivision item)
{
string msg = string.Empty;
item.DivisionActive = false;
try
{
if (ModelState.IsValid)
{
_PhytoSvc.InactivateDivision(item);
msg = "Division inactivated succesfully";
}
else
{
msg = "Data validation not successfull";
}
}
catch (Exception e)
{
msg = "Delete Division. An error has ocurred";
}
return(msg);
}
public bool InactivateDivision(PhytoDivision item)
{
bool result = false;
try
{
using (RCID_DWHEntities context = new RCID_DWHEntities())
{
Phyto_Division efItem = context.Phyto_Division.Where(b => b.DivisionID == item.DivisionID).FirstOrDefault();
if (efItem == null)
{
return(result);
}
efItem.DivisionActive = false;
if (context.SaveChanges() > 0)
{
result = true;
}
}
}
catch (Exception) { }
return(result);
}
public int CreateDivision(PhytoDivision item)
{
byte newid;
try
{
using (RCID_DWHEntities context = new RCID_DWHEntities())
{
newid = context.Phyto_Division.OrderByDescending(u => u.DivisionID).FirstOrDefault().DivisionID;
newid++;
Phyto_Division efItem = new Phyto_Division()
{
DivisionID = newid,
DivisionActive = item.DivisionActive,
DivisionName = item.DivisionName,
DivisionCommonName = item.DivisionCommonName
};
context.Phyto_Division.Add(efItem);
if (context.SaveChanges() > 0)
{
return(newid);
}
}
}
catch (Exception e) { throw e; }
return(newid);
}
public string CreateDivision([Bind(Exclude = "DivisionID")] PhytoDivision item)
{
string msg = string.Empty;
try
{
if (ModelState.IsValid)
{
_PhytoSvc.CreateDivision(item);
msg = "Division created succesfully";
}
else
{
msg = "Data validation not successfull";
}
}
catch (Exception e)
{
msg = "Create Division. An error has ocurred";
}
return(msg);
}
public string EditDivision(PhytoDivision item)
{
string msg = string.Empty;
try
{
if (ModelState.IsValid)
{
_PhytoSvc.UpdateDivision(item);
msg = "Division saved succesfully";
}
else
{
msg = "Data validation not successfull";
}
}
catch (Exception e)
{
msg = "Edit Division. An error has ocurred";
}
return(msg);
}
public bool InactivateDivision(PhytoDivision item)
{
return(_PhytoRepo.InactivateDivision(item));
}
public bool CreateDivision(PhytoDivision item)
{
return(_PhytoRepo.CreateDivision(item) > 0);
}
public bool UpdateDivision(PhytoDivision item)
{
return(_PhytoRepo.UpdateDivision(item));
}
