public static SPR_COMMISSION GetSPR_COMMISSIONByID(int id)
{
SPR_COMMISSION sPR_COMMISSION = new SPR_COMMISSION();
SqlSPR_COMMISSIONProvider sqlSPR_COMMISSIONProvider = new SqlSPR_COMMISSIONProvider();
sPR_COMMISSION = sqlSPR_COMMISSIONProvider.GetSPR_COMMISSIONByID(id);
return(sPR_COMMISSION);
}
public bool UpdateSPR_COMMISSION(SPR_COMMISSION sPR_COMMISSION)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("AbiMatuEnterprise_UpdateSPR_COMMISSION", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@SPR_COMMISSIONID", SqlDbType.Int).Value = sPR_COMMISSION.SPR_COMMISSIONID;
cmd.Parameters.Add("@STYPE", SqlDbType.VarChar).Value = sPR_COMMISSION.STYPE;
cmd.Parameters.Add("@SPLAN", SqlDbType.VarChar).Value = sPR_COMMISSION.SPLAN;
cmd.Parameters.Add("@SASL", SqlDbType.VarChar).Value = sPR_COMMISSION.SASL;
cmd.Parameters.Add("@SYEAR", SqlDbType.Int).Value = sPR_COMMISSION.SYEAR;
cmd.Parameters.Add("@BASECOMM", SqlDbType.Int).Value = sPR_COMMISSION.BASECOMM;
cmd.Parameters.Add("@ASLCOMM", SqlDbType.Int).Value = sPR_COMMISSION.ASLCOMM;
cmd.Parameters.Add("@TYPECOMM", SqlDbType.Int).Value = sPR_COMMISSION.TYPECOMM;
cmd.Parameters.Add("@YEARCOMM", SqlDbType.Int).Value = sPR_COMMISSION.YEARCOMM;
connection.Open();
int result = cmd.ExecuteNonQuery();
return(result == 1);
}
}
public SPR_COMMISSION GetSPR_COMMISSIONFromReader(IDataReader reader)
{
try
{
SPR_COMMISSION sPR_COMMISSION = new SPR_COMMISSION
(
(int)reader["SPR_COMMISSIONID"],
reader["STYPE"].ToString(),
reader["SPLAN"].ToString(),
reader["SASL"].ToString(),
(int)reader["SYEAR"],
(int)reader["BASECOMM"],
(int)reader["ASLCOMM"],
(int)reader["TYPECOMM"],
(int)reader["YEARCOMM"]
);
return(sPR_COMMISSION);
}
catch (Exception ex)
{
return(null);
}
}
public static bool UpdateSPR_COMMISSION(SPR_COMMISSION sPR_COMMISSION)
{
SqlSPR_COMMISSIONProvider sqlSPR_COMMISSIONProvider = new SqlSPR_COMMISSIONProvider();
return(sqlSPR_COMMISSIONProvider.UpdateSPR_COMMISSION(sPR_COMMISSION));
}
public static int InsertSPR_COMMISSION(SPR_COMMISSION sPR_COMMISSION)
{
SqlSPR_COMMISSIONProvider sqlSPR_COMMISSIONProvider = new SqlSPR_COMMISSIONProvider();
return(sqlSPR_COMMISSIONProvider.InsertSPR_COMMISSION(sPR_COMMISSION));
}
