public int update(Model.deliveryaddress deliveryaddress) { StringBuilder strsql = new StringBuilder(); strsql.Append("update deliveryaddress set "); strsql.AppendFormat(" company =N'{0}',", deliveryaddress.company); strsql.AppendFormat(" provence =N'{0}',", deliveryaddress.provence); strsql.AppendFormat(" address =N'{0}'", deliveryaddress.address); strsql.AppendFormat(" where id={0}", deliveryaddress.id); return(sql.ExecuteNonQuery(strsql.ToString())); }
public int Add(Model.deliveryaddress deliveryaddress) { StringBuilder strsql = new StringBuilder(); strsql.Append("insert into deliveryaddress values ("); strsql.AppendFormat("N'{0}',", deliveryaddress.company); strsql.AppendFormat("N'{0}',", deliveryaddress.provence); strsql.AppendFormat("N'{0}'", deliveryaddress.address); strsql.Append(") select SCOPE_IDENTITY()"); return(Convert.ToInt32(sql.ExecuteSc(strsql.ToString()))); }
public Model.deliveryaddress getdeliveryaddress(Model.deliveryaddress deliveryaddress1) { StringBuilder strsql = new StringBuilder(); strsql.Append("select * from deliveryaddress where "); strsql.AppendFormat("id='{0}'", deliveryaddress1.id); DataTable dt = sql.ExecuteDataSet(strsql.ToString()).Tables[0]; if (dt.Rows.Count < 1) { return(null); } Model.deliveryaddress deliveryaddress = new Model.deliveryaddress(); deliveryaddress.id = deliveryaddress1.id; deliveryaddress.company = dt.Rows[0]["company"].ToString(); deliveryaddress.provence = dt.Rows[0]["provence"].ToString(); deliveryaddress.address = dt.Rows[0]["address"].ToString(); return(deliveryaddress); }
public int Add(Model.deliveryaddress deliveryaddress) { return(itu.Add(deliveryaddress)); }
public int update(Model.deliveryaddress deliveryaddress) { return(itu.update(deliveryaddress)); }
public Model.deliveryaddress getdeliveryaddress(Model.deliveryaddress deliveryaddress1) { return(itu.getdeliveryaddress(deliveryaddress1)); }