/// <summary> /// for assigning approver /// </summary> /// <param name="approver">object that hold data from controller</param> /// @ver 1.0 @author rherejias 2/6/2017 public bool AssignApprover(AppoverObject approver) { string sp = ""; SqlParameter[] params_ = new SqlParameter[] { new SqlParameter("@Id", approver.Id), new SqlParameter("@Code", approver.Code), new SqlParameter("@ApprovalType", approver.ApprovalTypeCode), new SqlParameter("@Department", approver.DepartmentCode), new SqlParameter("@DateAdded", approver.DateAdded), new SqlParameter("@AddedBy", approver.AddedBy), new SqlParameter("@IP", approver.IP), new SqlParameter("@MAC", approver.MAC), new SqlParameter("@Module", approver.Module) }; if (approver.ApprovalTypeCode == ConfigurationManager.AppSettings["secondaryITApprover"]) { sp = "spAssignIT"; } else if (approver.ApprovalTypeCode == ConfigurationManager.AppSettings["secondaryPurchasingApprover"]) { sp = "spAssignPurchasing"; } else if (approver.ApprovalTypeCode == ConfigurationManager.AppSettings["secondaryAccountingApprover"]) { sp = "spAssignAccounting"; } return(Library.ConnectionString.returnCon.executeQuery(sp, params_, CommandType.StoredProcedure)); }
/// <summary> /// for re-activating approver /// </summary> /// <param name="approver">object that hold data from controller</param> /// <returns>boolean true or false</returns> /// @ver 1.0 @author rherejias 1/18/2017 public bool ActiveApprover(AppoverObject approver) { SqlParameter[] params_ = new SqlParameter[] { new SqlParameter("@id", approver.Id), new SqlParameter("@Code", approver.Code), new SqlParameter("@table", "tblApprovalDepartmentRelationship"), new SqlParameter("@DateAdded", approver.DateAdded), new SqlParameter("@Module", "APPROVER"), new SqlParameter("@IP", approver.IP), new SqlParameter("@MAC", approver.MAC), new SqlParameter("@AddedBy", approver.AddedBy) }; return(Library.ConnectionString.returnCon.executeQuery("spActivateItem", params_, CommandType.StoredProcedure)); }
/// <summary> /// for adding approver details /// </summary> /// <param name="approver">object that hold data from controller</param> /// <returns>boolean true or false</returns> /// @ver 1.0 @author rherejias 1/18/2017 public bool addApprover(AppoverObject approver) { SqlParameter[] params_ = new SqlParameter[] { new SqlParameter("@ApprovalType", approver.ApprovalTypeCode), new SqlParameter("@Department", approver.DepartmentCode), new SqlParameter("@User", approver.UserCode), new SqlParameter("@DateAdded", approver.DateAdded), new SqlParameter("@AddedBy", approver.AddedBy), new SqlParameter("@IsActive", approver.IsActive), new SqlParameter("@IP", approver.IP), new SqlParameter("@MAC", approver.MAC) }; return(Library.ConnectionString.returnCon.executeQuery("spAddApprover", params_, CommandType.StoredProcedure)); }
/// <summary> /// for updating approver details /// </summary> /// <param name="approver">object that hold data from controller</param> /// <returns>boolean true or false</returns> /// @ver 1.0 @author rherejias 1/18/2017 public bool editApprover(AppoverObject approver) { SqlParameter[] params_ = new SqlParameter[] { new SqlParameter("@id", approver.Id), new SqlParameter("@Code", approver.Code), new SqlParameter("@DepartmentInput", approver.DepartmentCode), new SqlParameter("@UserInput", approver.UserCode), new SqlParameter("@AddedBy", approver.AddedBy), new SqlParameter("@IP", approver.IP), new SqlParameter("@MAC", approver.MAC), new SqlParameter("@DateAdded", approver.DateAdded) }; return(Library.ConnectionString.returnCon.executeQuery("spUpdateApprover", params_, CommandType.StoredProcedure)); }
/// <summary> /// for assigning approver on "approver" and "dept.approver" maintenance /// </summary> /// <param name="approver">object that hold data from controller</param> /// <returns>bollean true or false</returns> /// @ver 1.0 @author rherejias 1/18/2017 public bool AssignApprover(AppoverObject approver) { SqlParameter[] params_ = new SqlParameter[] { new SqlParameter("@Id", approver.Id), new SqlParameter("@Code", approver.Code), new SqlParameter("@ApprovalType", approver.ApprovalTypeCode), new SqlParameter("@Department", approver.DepartmentCode), new SqlParameter("@DateAdded", approver.DateAdded), new SqlParameter("@AddedBy", approver.AddedBy), new SqlParameter("@IP", approver.IP), new SqlParameter("@MAC", approver.MAC), new SqlParameter("@Module", approver.Module) }; return(Library.ConnectionString.returnCon.executeQuery("spAssignTempApprover", params_, CommandType.StoredProcedure)); }