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); } }