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