/*
* @author : AV <*****@*****.**>
* @date : DEC. 15, 2016
* @description : approval of gatepass by logging to tblapprovallogs
*/
#region UpdateUpprovalLogsByDept
public int UpdateUpprovalLogsByDept(ApprovalLogsObject approvallogs, string approvaltype)
{
return(Convert.ToInt32(Library.ConnectionString.returnCon.executeScalarQuery("exec ApprovedByDepatment_UpdateApproverLogs " +
" @ApprovalType = '" + approvaltype + "'," +
" @DateModified = '" + approvallogs.DateModified + "'," +
" @TransHeaderCode = '" + approvallogs.Code + "'", CommandType.Text)));
}// End
}// End
/*
* @author : AV <*****@*****.**>
* @date : DEC. 15, 2016
* @description : rejection of gatepass by logging to tblapprovallogs
*/
//#region UpdateUpprovalLogsByDept_Rejected
//public int UpdateUpprovalLogsByDept_Rejected(ArppovalLogs approvallogs, string approvaltype)
//{
// return Convert.ToInt32(Library.ConnectionString.returnCon.executeScalarQuery("exec RejectedByApprovers_UpdateApproverLogs " +
// " @ApprovalType = '" + approvaltype + "'," +
// " @DateModified = '" + approvallogs.DateModified + "'," +
// " @RejectedRemarks = '" + approvallogs.Remarks + "'," +
// " @RejectedBy = '" + approvallogs.RejectedBy + "'," +
// " @TransHeaderCode = '" + approvallogs.Code + "'", CommandType.Text));
//}// End
public bool UpdateUpprovalLogsByDept_Rejected(ApprovalLogsObject approvalLog, string approvaltype)
{
var @params = new SqlParameter[] {
new SqlParameter(parameterName: "ApprovalType", value: approvaltype),
new SqlParameter(parameterName: "DateRejected", value: approvalLog.DateRejected),
new SqlParameter(parameterName: "RejectedRemarks", value: approvalLog.Remarks),
new SqlParameter(parameterName: "RejectedBy", value: approvalLog.RejectedBy),
new SqlParameter(parameterName: "TransHeaderCode", value: approvalLog.Code),
};
return(Library.ConnectionString.returnCon.executeQuery(strQuery: "RejectedByApprovers_UpdateApproverLogs", params_: @params, type_: CommandType.StoredProcedure));
}
/// <summary>
/// for reject
/// </summary>
/// <param name="approvalLog">from controller</param>
/// <returns>boolean true or false</returns>
/// @ver @author rherejias 2/10/2017
public bool Reject(ApprovalLogsObject approvalLog)
{
SqlParameter[] params_ = new SqlParameter[] {
new SqlParameter("id", approvalLog.Id),
new SqlParameter("headercode", approvalLog.TransHeaderCode),
new SqlParameter("isapproved", approvalLog.IsApproved),
new SqlParameter("rejectedby", approvalLog.RejectedBy),
new SqlParameter("daterejected", approvalLog.DateRejected),
new SqlParameter("remarks", approvalLog.Remarks),
new SqlParameter("isoverride", approvalLog.IsOverride),
new SqlParameter("IP", approvalLog.IP),
new SqlParameter("MAC", approvalLog.MAC)
};
return(Library.ConnectionString.returnCon.executeQuery("spOverrideReject", params_, CommandType.StoredProcedure));
}
