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);
}
