public static int DeleteT_ATTAINS_ASSESS_UNITS(int aSSESS_UNIT_IDX)
{
try
{
TAttainsAssessUnits r = (from c in _db.TAttainsAssessUnits
where c.AttainsAssessUnitIdx == aSSESS_UNIT_IDX
select c).FirstOrDefault();
_db.TAttainsAssessUnits.Remove(r);
_db.SaveChanges();
return(1);
}
catch
{
return(0);
}
}
public static int InsertOrUpdateATTAINS_ASSESS_UNITS(int?aTTAINS_ASSESS_UNIT_IDX, int?aTTAINS_REPORT_IDX, string aSSESS_UNIT_ID, string aSSESS_UNIT_NAME,
string lOCATION_DESC, string aGENCY_CODE, string sTATE_CODE, string aCT_IND, string wATER_TYPE_CODE, decimal?wATER_SIZE, string wATER_UNIT_CODE,
string uSE_CLASS_CODE, string uSE_CLASS_NAME, String cREATE_USER = "******")
{
Boolean insInd = false;
try
{
if (aTTAINS_ASSESS_UNIT_IDX == -1)
{
aTTAINS_ASSESS_UNIT_IDX = null;
}
TAttainsAssessUnits a = null;
if (aTTAINS_ASSESS_UNIT_IDX != null)
{
a = (from c in _db.TAttainsAssessUnits
where c.AttainsAssessUnitIdx == aTTAINS_ASSESS_UNIT_IDX
select c).FirstOrDefault();
}
if (a == null)
{
a = new TAttainsAssessUnits();
insInd = true;
}
if (aTTAINS_REPORT_IDX != null)
{
a.AttainsReportIdx = aTTAINS_REPORT_IDX.ConvertOrDefault <int>();
}
if (aSSESS_UNIT_ID != null)
{
a.AssessUnitId = aSSESS_UNIT_ID;
}
if (aSSESS_UNIT_NAME != null)
{
a.AssessUnitName = aSSESS_UNIT_NAME;
}
if (lOCATION_DESC != null)
{
a.LocationDesc = lOCATION_DESC;
}
if (aGENCY_CODE != null)
{
a.AgencyCode = aGENCY_CODE;
}
if (sTATE_CODE != null)
{
a.StateCode = sTATE_CODE;
}
if (aCT_IND != null)
{
a.ActInd = aCT_IND;
}
if (wATER_TYPE_CODE != null)
{
a.WaterTypeCode = wATER_TYPE_CODE;
}
if (wATER_SIZE != null)
{
a.WaterSize = wATER_SIZE;
}
if (wATER_UNIT_CODE != null)
{
a.WaterUnitCode = wATER_UNIT_CODE;
}
if (uSE_CLASS_CODE != null)
{
a.UseClassCode = uSE_CLASS_CODE;
}
if (uSE_CLASS_NAME != null)
{
a.UseClassName = uSE_CLASS_NAME;
}
if (insInd) //insert case
{
a.CreateUserid = cREATE_USER.ToUpper();
a.CreateDt = System.DateTime.Now;
_db.TAttainsAssessUnits.Add(a);
}
else
{
a.ModifyUserid = cREATE_USER.ToUpper();
a.ModifyDt = System.DateTime.Now;
_db.TAttainsAssessUnits.Update(a);
}
_db.SaveChanges();
return(a.AttainsAssessUnitIdx);
}
catch (Exception ex)
{
return(0);
}
}
