public static T_installment_t GetT_installment_tByID(int id)
{
T_installment_t t_installment_t = new T_installment_t();
SqlT_installment_tProvider sqlT_installment_tProvider = new SqlT_installment_tProvider();
t_installment_t = sqlT_installment_tProvider.GetT_installment_tByID(id);
return t_installment_t;
}
public T_installment_t GetT_installment_tFromReader(IDataReader reader)
{
try
{
T_installment_t t_installment_t = new T_installment_t
(
(int)reader["T_installment_tID"],
reader["ID"].ToString(),
reader["Date"].ToString(),
reader["Amount"].ToString()
);
return t_installment_t;
}
catch(Exception ex)
{
return null;
}
}
public static bool UpdateT_installment_t(T_installment_t t_installment_t)
{
SqlT_installment_tProvider sqlT_installment_tProvider = new SqlT_installment_tProvider();
return sqlT_installment_tProvider.UpdateT_installment_t(t_installment_t);
}
public static int InsertT_installment_t(T_installment_t t_installment_t)
{
SqlT_installment_tProvider sqlT_installment_tProvider = new SqlT_installment_tProvider();
return sqlT_installment_tProvider.InsertT_installment_t(t_installment_t);
}
public bool UpdateT_installment_t(T_installment_t t_installment_t)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("CUC_db_UpdateT_installment_t", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@T_installment_tID", SqlDbType.Int).Value = t_installment_t.T_installment_tID;
cmd.Parameters.Add("@ID", SqlDbType.NVarChar).Value = t_installment_t.ID;
cmd.Parameters.Add("@Date", SqlDbType.NVarChar).Value = t_installment_t.Date;
cmd.Parameters.Add("@Amount", SqlDbType.NVarChar).Value = t_installment_t.Amount;
connection.Open();
int result = cmd.ExecuteNonQuery();
return result == 1;
}
}
