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