public static int DeleteT_ATTAINS_ASSESS(int aSSESS_IDX)
{
try
{
TAttainsAssess r = (from c in _db.TAttainsAssess
where c.AttainsAssessIdx == aSSESS_IDX
select c).FirstOrDefault();
_db.TAttainsAssess.Remove(r);
_db.SaveChanges();
return(1);
}
catch
{
return(0);
}
}
public static int InsertOrUpdateATTAINS_ASSESS(int?aTTAINS_ASSESS_IDX, string rEPORTING_CYCLE, string rEPORT_STATUS, int aTTAINS_ASSESS_UNIT_IDX,
string aGENCY_CODE, string cYCLE_LAST_ASSESSED, string cYCLE_LAST_MONITORED, string tROPHIC_STATUS_CODE, String cREATE_USER = "******")
{
Boolean insInd = false;
try
{
if (aTTAINS_ASSESS_IDX == -1)
{
aTTAINS_ASSESS_IDX = null;
}
TAttainsAssess a = null;
if (aTTAINS_ASSESS_IDX != null)
{
a = (from c in _db.TAttainsAssess
where c.AttainsAssessIdx == aTTAINS_ASSESS_IDX
select c).FirstOrDefault();
}
if (a == null)
{
a = new TAttainsAssess();
insInd = true;
}
if (rEPORTING_CYCLE != null)
{
a.ReportingCycle = rEPORTING_CYCLE;
}
if (rEPORT_STATUS != null)
{
a.ReportStatus = rEPORT_STATUS;
}
a.AttainsAssessUnitIdx = aTTAINS_ASSESS_UNIT_IDX;
if (aGENCY_CODE != null)
{
a.AgencyCode = aGENCY_CODE;
}
if (cYCLE_LAST_ASSESSED != null)
{
a.CycleLastAssessed = cYCLE_LAST_ASSESSED;
}
if (cYCLE_LAST_MONITORED != null)
{
a.CycleLastMonitored = cYCLE_LAST_MONITORED;
}
if (tROPHIC_STATUS_CODE != null)
{
a.TrophicStatusCode = tROPHIC_STATUS_CODE;
}
if (insInd) //insert case
{
a.CreateUserid = cREATE_USER.ToUpper();
a.CreateDt = System.DateTime.Now;
_db.TAttainsAssess.Add(a);
}
else
{
a.ModifyUserid = cREATE_USER.ToUpper();
a.ModifyDt = System.DateTime.Now;
_db.TAttainsAssess.Update(a);
}
_db.SaveChanges();
return(a.AttainsAssessIdx);
}
catch (Exception ex)
{
return(0);
}
}
