private void CreateUpdatePaymentTerm(PaymentTerm p)
{
SqlService sql = new SqlService(_sqlConnection);
if (p.Id != null)
sql.AddParameter("@pId", System.Data.SqlDbType.UniqueIdentifier, p.Id);
sql.AddParameter("@pCode", System.Data.SqlDbType.VarChar, p.Code);
sql.AddParameter("@pDescription", System.Data.SqlDbType.VarChar, p.Description);
sql.ExecuteSP("ICMS_spCreateUpdatePaymentTerm");
}
public PaymentTerm GetPaymentTerm(Guid id)
{
PaymentTerm p = new PaymentTerm();
SqlService sql = new SqlService(_sqlConnection);
sql.AddParameter("@pId", System.Data.SqlDbType.UniqueIdentifier, id);
using (SqlDataReader reader = sql.ExecuteSPReader("ICMS_spGetPaymentTerms"))
{
if (reader.HasRows)
{
while (reader.Read())
{
SetupPaymentTerm(p, reader);
}
}
}
return p;
}
private void SetupPaymentTerm(PaymentTerm p, SqlDataReader reader)
{
p.Id = reader.SafeGetGuid(reader.GetOrdinal("Id"));
p.Code = reader.SafeGetInt(reader.GetOrdinal("Code")).Value;
p.Description = reader.SafeGetString(reader.GetOrdinal("Description"));
}
public void UpdatePaymentTerm(PaymentTerm p)
{
CreateUpdatePaymentTerm(p);
}