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