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