public int EditApprovalLimit(ApprovalLimitData objDOApprovalLimit)
{
try
{
System.Data.SqlClient.SqlParameter[] obj = new System.Data.SqlClient.SqlParameter[] {
new System.Data.SqlClient.SqlParameter("@ID", objDOApprovalLimit.ID),
new System.Data.SqlClient.SqlParameter("@Category", objDOApprovalLimit.Category),
new System.Data.SqlClient.SqlParameter("@Approval_Limt", objDOApprovalLimit.Approval_Limit),
new System.Data.SqlClient.SqlParameter("@Modified_By", objDOApprovalLimit.CurrentUser)
};
SqlHelper.ExecuteNonQuery(_internalConnection, CommandType.StoredProcedure, "[PURC_SP_upd_Approval_Limit]", obj);
return(0);
}
catch (Exception ex)
{
throw ex;
}
}
public int DeleteApprovalLimit(ApprovalLimitData objDOApprovalLimit)
{
try
{
System.Data.SqlClient.SqlParameter[] sqlpram = new System.Data.SqlClient.SqlParameter[]
{
new System.Data.SqlClient.SqlParameter("@ID", objDOApprovalLimit.ID),
new System.Data.SqlClient.SqlParameter("@Deleted_By", objDOApprovalLimit.CurrentUser)
};
SqlHelper.ExecuteNonQuery(_internalConnection, CommandType.StoredProcedure, "PURC_SP_Del_Approval_Limit", sqlpram);
return(0);
}
catch (Exception ex)
{
throw ex;
}
}
public int SaveApprovalLimit(ApprovalLimitData objDOApprovalLimit)
{
try
{
System.Data.SqlClient.SqlParameter[] sqlprm = new System.Data.SqlClient.SqlParameter[]
{
new System.Data.SqlClient.SqlParameter("@UserID", objDOApprovalLimit.UserID),
new System.Data.SqlClient.SqlParameter("@Vessel_Code", objDOApprovalLimit.Vessel_Code),
new System.Data.SqlClient.SqlParameter("@Category_Code", objDOApprovalLimit.Category),
new System.Data.SqlClient.SqlParameter("@Approval_Limit", Convert.ToDouble(objDOApprovalLimit.Approval_Limit)),
new System.Data.SqlClient.SqlParameter("@Created_By", objDOApprovalLimit.CurrentUser),
};
SqlHelper.ExecuteNonQuery(_internalConnection, CommandType.StoredProcedure, "PURC_SP_Ins_Approval_Limit", sqlprm);
return(0);
}
catch (Exception ex)
{
throw ex;
}
}
public int EditApprovalLimit(ApprovalLimitData objDOApprovalLimit)
{
return(objApprovalLimit.EditApprovalLimit(objDOApprovalLimit));
}
public int DeleteApprovalLimit(ApprovalLimitData objDOApprovalLimit)
{
return(objApprovalLimit.DeleteApprovalLimit(objDOApprovalLimit));
}
public int SaveApprovalLimit(ApprovalLimitData objDOApprovalLimit)
{
return(objApprovalLimit.SaveApprovalLimit(objDOApprovalLimit));
}
