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