public bool Update(int RECORD_ID, int SURVEYOR_ID, string ISSUE_DATE, string RECEIVE_DATE, string ACCEPT_DATE, string SURVEY_NO, string MUSTUKHLAS_ID, string notes) { //string sql = string.Format("select SURVEYOR_NAME from SURVEYORS where SURVEYOR_NO={0} ", SURVEYOR_ID); string surveyorName = Surveyor.GetSurveyorNameByID(SURVEYOR_ID); //db.ExecuteScalar(sql).ToString(); ISSUE_DATE = (string.IsNullOrEmpty(ISSUE_DATE) ? "NULL" : string.Format("'{0}'", Shared.FormatDateArEgDMY(ISSUE_DATE))); RECEIVE_DATE = (string.IsNullOrEmpty(RECEIVE_DATE) ? "NULL" : string.Format("'{0}'", Shared.FormatDateArEgDMY(RECEIVE_DATE))); ACCEPT_DATE = (string.IsNullOrEmpty(ACCEPT_DATE) ? "NULL" : string.Format("'{0}'", Shared.FormatDateArEgDMY(ACCEPT_DATE))); notes = string.IsNullOrEmpty(notes) ? "NULL" : string.Format("'{0}'", notes.Replace("'", "''")); MUSTUKHLAS_ID = string.IsNullOrEmpty(MUSTUKHLAS_ID) ? "NULL" : int.Parse(MUSTUKHLAS_ID).ToString(); string sql = string.Format("update SURVEYORS_SUBMIT_JOB set SURVEYOR_ID={0}, SURVEYOR_NAME='{1}', ISSUE_DATE={2}, RECEIVE_DATE={3}, ACCEPT_DATE={4}, SURVEY_NO={5}, MUSTUKHLAS_ID={6}, notes={8} where RECORD_ID={7} ", SURVEYOR_ID, surveyorName, ISSUE_DATE, RECEIVE_DATE, ACCEPT_DATE, SURVEY_NO, MUSTUKHLAS_ID, RECORD_ID, notes); int rows = db.ExecuteNonQuery(sql); return(rows > 0); }
public bool Insert(int surveyorID, DateTime?issueDate, DateTime?recieveDate, int surveyNo, string notes, string ID, JobType jobType) { // sectionNo, interNo, regionNo, string surveyorName, string sql = ""; int rows = 0; int x = 0; if (string.IsNullOrEmpty(ID)) { throw new Exception("الرجاء اختيار العنصر الممسوح - مقطع أو تقاطع أو منطقة فرعية"); } string surveyorName = Surveyor.GetSurveyorByID(surveyorID).Rows[0]["SURVEYOR_NAME"].ToString(); string issueDatePart = (issueDate == null) ? "NULL" : string.Format("'{0}'", ((DateTime)issueDate).ToString("dd/MM/yyyy")); string recieveDatePart = (recieveDate == null) ? "NULL" : string.Format("'{0}'", ((DateTime)recieveDate).ToString("dd/MM/yyyy")); notes = string.IsNullOrEmpty(notes) ? "NULL" : string.Format("'{0}'", notes.Replace("'", "''")); switch (jobType) { case JobType.Section: sql = string.Format("SELECT Count(*) as X FROM SURVEYORS_SUBMIT_JOB where section_NO=(select section_no from sections where section_id={0}) and SURVEY_NO={1} and SURVEYOR_ID={2} ", ID, surveyNo, surveyorID); x = int.Parse(db.ExecuteScalar(sql).ToString()); if (x >= 1) { throw new Exception("هذا المسح مدخل من قبل"); } // 0 1 2 3 4 5 6 sql = string.Format("insert into SURVEYORS_SUBMIT_JOB(ISSUE_DATE, SURVEY_NO, NOTES, RECEIVE_DATE, SURVEYOR_NAME, SURVEYOR_ID, SECTION_NO, RECORD_ID, IS_SECTION) " + " values({0}, {1}, {2}, {3}, '{4}', {5}, (select SECTION_NO from SECTIONS where SECTION_ID={6}), SEQ_SURVEYORS_SUBMIT.nextval, 1) ", issueDatePart, surveyNo, notes, recieveDatePart, surveyorName, surveyorID, ID); rows += db.ExecuteNonQuery(sql); break; case JobType.Intersection: sql = string.Format("SELECT Count(*) as X FROM SURVEYORS_SUBMIT_JOB where inter_no=(select inter_no from INTERSECTIONS where INTERSECTION_ID={0}) and SURVEY_NO={1} and SURVEYOR_ID={2} ", ID, surveyNo, surveyorID); x = int.Parse(db.ExecuteScalar(sql).ToString()); if (x >= 1) { throw new Exception("هذا المسح مدخل من قبل"); } // 0 1 2 3 4 5 6 sql = string.Format("insert into SURVEYORS_SUBMIT_JOB(ISSUE_DATE, SURVEY_NO, NOTES, RECEIVE_DATE, SURVEYOR_NAME, SURVEYOR_ID, INTER_NO, RECORD_ID, IS_INTERSECT) " + " values({0}, {1}, {2}, {3}, '{4}', {5}, (select INTER_NO from INTERSECTIONS where INTERSECTION_ID={6}), SEQ_SURVEYORS_SUBMIT.nextval, 1) ", issueDatePart, surveyNo, notes, recieveDatePart, surveyorName, surveyorID, ID); rows += db.ExecuteNonQuery(sql); break; case JobType.RegionSecondaryStreets: sql = string.Format("SELECT Count(*) as X FROM SURVEYORS_SUBMIT_JOB where REGION_NO=(select REGION_NO from REGIONS where REGION_ID={0}) and SURVEY_NO={1} and SURVEYOR_ID={2} ", ID, surveyNo, surveyorID); x = int.Parse(db.ExecuteScalar(sql).ToString()); if (x >= 1) { throw new Exception("هذا المسح مدخل من قبل"); } // 0 1 2 3 4 5 6 sql = string.Format("insert into SURVEYORS_SUBMIT_JOB(ISSUE_DATE, SURVEY_NO, NOTES, RECEIVE_DATE, SURVEYOR_NAME, SURVEYOR_ID, REGION_NO, RECORD_ID, IS_REGION) " + " values({0}, {1}, {2}, {3}, '{4}', {5}, (select REGION_NO from REGIONS where REGION_ID={6}), SEQ_SURVEYORS_SUBMIT.nextval, 1) ", issueDatePart, surveyNo, notes, recieveDatePart, surveyorName, surveyorID, ID); rows += db.ExecuteNonQuery(sql); break; default: return(false); } return(rows > 0); }