private void CreateUpdateContractor(Contractor contractor) { SqlService sql = new SqlService(_sqlConnection); if (contractor.Id != null) sql.AddParameter("@pId", System.Data.SqlDbType.UniqueIdentifier, contractor.Id); sql.AddParameter("@pName", System.Data.SqlDbType.VarChar, contractor.Name); sql.AddParameter("@pRef", System.Data.SqlDbType.VarChar, contractor.Ref); sql.AddParameter("@pMobile", System.Data.SqlDbType.BigInt, contractor.Mobile); sql.AddParameter("@pSalesArea", System.Data.SqlDbType.VarChar, contractor.SalesAreaName); if (contractor.TravelDistance != null) sql.AddParameter("@pTravelDistance", System.Data.SqlDbType.Int, contractor.TravelDistance); if (contractor.TravelTime != null) sql.AddParameter("@pTravelTime", System.Data.SqlDbType.Int, contractor.TravelTime); //sql.AddParameter("@", System.Data.SqlDbType,); sql.ExecuteSP("ICMS_spCreateUpdateContractor"); }
public Contractor GetContractor(Guid id) { Contractor c = new Contractor(); SqlService sql = new SqlService(_sqlConnection); sql.AddParameter("@pId", System.Data.SqlDbType.UniqueIdentifier, id); using (SqlDataReader reader = sql.ExecuteSPReader("ICMS_spGetContractors")) { if (reader.HasRows) { while (reader.Read()) { SetupContractor(c, reader); } } } return c; }
private void SetupContractor(Contractor c, SqlDataReader reader) { c.Id = reader.SafeGetGuid(reader.GetOrdinal("Id")).Value; c.Name = reader.SafeGetString(reader.GetOrdinal("Name")); c.Ref = reader.SafeGetString(reader.GetOrdinal("Ref")); c.Mobile = reader.SafeGetInt64(reader.GetOrdinal("Mobile")); c.SalesAreaName = reader.SafeGetString(reader.GetOrdinal("SalesArea")); c.TravelDistance = reader.SafeGetInt(reader.GetOrdinal("TravelDistance")).Value; c.TravelTime = reader.SafeGetInt(reader.GetOrdinal("TravelTime")).Value; }
public void UpdateContractor(Contractor c) { CreateUpdateContractor(c); }