public static bool set_PMS_APPROVAL_PROCESS(PMS_APPROVAL_PROCESS _obj_pms_approval_process) { bool status = false; if (_obj_pms_approval_process.OPERATION == operation.Insert) { if (ExecuteNonQuery("EXEC USP_PMS_APPROVAL_PROCESS @OPERATION = 'INSERT'" + ",@PMS_APPROVAL_PROCESS_EMP_ID_1 = " + _obj_pms_approval_process.PMS_APPROVAL_PROCESS_EMP_ID_1 + ",@PMS_APPROVAL_PROCESS_EMP_ID_2 = " + _obj_pms_approval_process.PMS_APPROVAL_PROCESS_EMP_ID_2 + ",@PMS_APPROVAL_PROCESS_EMP_ID_3 = " + _obj_pms_approval_process.PMS_APPROVAL_PROCESS_EMP_ID_3 + ",@PMS_APPROVAL_PROCESS_ORGANISATION_ID = " + _obj_pms_approval_process.ORGANISATION_ID + ",@PMS_APPROVAL_PROCESS_STATUS = " + _obj_pms_approval_process.PMS_APPROVAL_PROCESS_STATUS + ",@PMS_APPROVAL_PROCESS_CREATED_BY = " + _obj_pms_approval_process.CREATEDBY + ",@PMS_APPROVAL_PROCESS_CREATED_DATE = '" + _obj_pms_approval_process.CREATEDDATE + "',@PMS_APPROVAL_PROCESS_BU_ID = " + _obj_pms_approval_process.BUID)) { status = true; } } if (_obj_pms_approval_process.OPERATION == operation.Update) { if (ExecuteNonQuery("EXEC USP_PMS_APPROVAL_PROCESS @OPERATION = 'UPDATE'" + ",@PMS_APPROVAL_PROCESS_ID = " + _obj_pms_approval_process.PMS_APPROVAL_PROCESS_ID //+ "@PMS_APPROVAL_PROCESS_EMP_ID_1 = " + _obj_pms_approval_process.PMS_APPROVAL_PROCESS_EMP_ID_1 //+ "@PMS_APPROVAL_PROCESS_EMP_ID_2 = " + _obj_pms_approval_process.PMS_APPROVAL_PROCESS_EMP_ID_2 //+ "@PMS_APPROVAL_PROCESS_EMP_ID_3 = " + _obj_pms_approval_process.PMS_APPROVAL_PROCESS_EMP_ID_3 //+ "@PMS_APPROVAL_PROCESS_ORGANISATION_ID = " + _obj_pms_approval_process.ORGANISATION_ID + ",@PMS_APPROVAL_PROCESS_STATUS = " + _obj_pms_approval_process.PMS_APPROVAL_PROCESS_STATUS + ",@PMS_APPROVAL_PROCESS_MODIFIED_BY = " + _obj_pms_approval_process.LASTMDFBY + ",@PMS_APPROVAL_PROCESS_MODIFIED_DATE = '" + _obj_pms_approval_process.LASTMDFDATE + "'")) { status = true; } } return(status); }
public static DataTable Check_PMS_Approval_Process_Exists(PMS_APPROVAL_PROCESS _obj_pms_approval_process) { return(ExecuteQuery("EXEC USP_PMS_APPROVAL_PROCESS @OPERATION = 'CHECK_EXISTS',@PMS_APPROVAL_PROCESS_ORGANISATION_ID = " + _obj_pms_approval_process.ORGANISATION_ID + ",@PMS_APPROVAL_PROCESS_STATUS = " + Convert.ToBoolean(_obj_pms_approval_process.PMS_APPROVAL_PROCESS_STATUS) + ",@PMS_APPROVAL_PROCESS_BU_ID =" + _obj_pms_approval_process.BUID)); }