public void Add(Models.PotentialCustomer item)
{
DbCommand comm = this.GetCommand("PotentialCustomer_Insert");
comm.AddParameter <string>(this.Factory, "CusName", item.CusName);
comm.AddParameter <string>(this.Factory, "CusPhone", item.CusPhone);
comm.AddParameter <string>(this.Factory, "CusEmail", item.CusEmail);
comm.SafeExecuteNonQuery();
}
public void Remove(Models.PotentialCustomer item)
{
DbCommand comm = this.GetCommand("PotentialCustomer_Delete");
comm.AddParameter <int>(this.Factory, "Id", item.Id);
this.SafeExecuteNonQuery(comm);
}
public Models.PotentialCustomer Get(Models.PotentialCustomer dummy)
{
DbCommand comm = this.GetCommand("PotentialCustomer_Get");
comm.AddParameter <int>(this.Factory, "Id", dummy.Id);
DataTable dt = this.GetTable(comm);
return(EntityBase.ParseListFromTable <PotentialCustomer>(dt).FirstOrDefault());
}
public void Update(Models.PotentialCustomer @new, Models.PotentialCustomer old)
{
var item = @new;
item.Id = old.Id;
DbCommand comm = this.GetCommand("PotentialCustomer_Update");
comm.AddParameter <int>(this.Factory, "Id", item.Id);
comm.AddParameter <string>(this.Factory, "CusName", item.CusName);
comm.AddParameter <string>(this.Factory, "CusPhone", item.CusPhone);
comm.AddParameter <string>(this.Factory, "CusEmail", item.CusEmail);
this.SafeExecuteNonQuery(comm);
}
