public bool InactivateSpeciesGroup(FishSpeciesGroup item)
{
bool result = false;
try
{
using (RCID_DWHEntities context = new RCID_DWHEntities())
{
Fish_SpeciesGroup efItem = context.Fish_SpeciesGroup.Where(b => b.SpeciesGroupID == item.SpeciesGroupID).FirstOrDefault();
if (efItem == null)
{
return(result);
}
efItem.SpeciesGroupActive = false;
if (context.SaveChanges() > 0)
{
result = true;
}
}
}
catch (Exception) { }
return(result);
}
public bool CreateSpeciesGroup(FishSpeciesGroup item)
{
bool result = false;
try
{
using (RCID_DWHEntities context = new RCID_DWHEntities())
{
byte newid = context.Fish_SpeciesGroup.OrderByDescending(u => u.SpeciesGroupID).FirstOrDefault().SpeciesGroupID;
newid++;
Fish_SpeciesGroup efItem = new Fish_SpeciesGroup()
{
SpeciesGroupID = newid,
SpeciesGroupActive = true,
SpeciesGroupName = item.SpeciesGroupName
};
context.Fish_SpeciesGroup.Add(efItem);
if (context.SaveChanges() > 0)
{
result = true;
}
}
}
catch (Exception e) { throw e; }
return(result);
}
public string DeleteSpeciesGroup(FishSpeciesGroup item)
{
string msg = string.Empty;
item.SpeciesGroupActive = false;
try
{
if (ModelState.IsValid)
{
_fishSvc.InactivateSpeciesGroup(item);
msg = "SpeciesGroup inactivated succesfully";
}
else
{
msg = "Data validation not successfull";
}
}
catch (Exception e)
{
msg = "Delete Species Group. An error has ocurred";
}
return(msg);
}
public string CreateSpeciesGroup([Bind(Exclude = "SpeciesGroupID")] FishSpeciesGroup item)
{
string msg = string.Empty;
try
{
if (ModelState.IsValid)
{
_fishSvc.CreateSpeciesGroup(item);
msg = "Species Group created succesfully";
}
else
{
msg = "Data validation not successfull";
}
}
catch (Exception e)
{
msg = "Create Species Group. An error has ocurred";
}
return(msg);
}
public string EditSpeciesGroup(FishSpeciesGroup item)
{
string msg = string.Empty;
try
{
if (ModelState.IsValid)
{
_fishSvc.UpdateSpeciesGroup(item);
msg = "Species Group saved succesfully";
}
else
{
msg = "Data validation not successfull";
}
}
catch (Exception e)
{
msg = "Edit Species Group. An error has ocurred";
}
return(msg);
}
public bool InactivateSpeciesGroup(FishSpeciesGroup item)
{
return(_fishRepo.InactivateSpeciesGroup(item));
}
public bool CreateSpeciesGroup(FishSpeciesGroup item)
{
return(_fishRepo.CreateSpeciesGroup(item));
}
public bool UpdateSpeciesGroup(FishSpeciesGroup item)
{
return(_fishRepo.UpdateSpeciesGroup(item));
}
