private void CreateUpdateSalesArea(SalesArea s) { SqlService sql = new SqlService(_sqlConnection); if (s.Id != null) sql.AddParameter("@pId", System.Data.SqlDbType.UniqueIdentifier, s.Id); sql.AddParameter("@pSalesAreaName", System.Data.SqlDbType.VarChar, s.SalesAreaName); sql.AddParameter("@pOrderCode", System.Data.SqlDbType.VarChar, s.OrderCode); sql.ExecuteSP("ICMS_spCreateUpdateSalesArea"); }
public SalesArea GetSalesArea(Guid id) { SalesArea s = new SalesArea(); SqlService sql = new SqlService(_sqlConnection); sql.AddParameter("@pId", System.Data.SqlDbType.UniqueIdentifier, id); using (SqlDataReader r = sql.ExecuteSPReader("ICMS_spGetSalesAreas")) { if (r.HasRows) { while (r.Read()) { SetupSalesArea(s, r); } } } return s; }
private void SetupSalesArea(SalesArea s, SqlDataReader r) { s.Id = r.SafeGetGuid(r.GetOrdinal("Id")); s.OrderCode = r.SafeGetString(r.GetOrdinal("OrderCode")); s.SalesAreaName = r.SafeGetString(r.GetOrdinal("SalesArea")); }
public void UpdateSalesArea(SalesArea s) { CreateUpdateSalesArea(s); }