public void delete(string ID)
{
using (DBAccess.DBAccess db = new DBAccess.DBAccess())
{
string[,] param = {
{"@ID", ID}
};
db.ExecuteNonQuery("sprDeleteCustomer", param);
}
}
public void add(ModelCustomer MC)
{
using (DBAccess.DBAccess db = new DBAccess.DBAccess())
{
string[,] param = {
{"@NAME", MC.Name},
{"@ADDRESS", MC.Address}
};
db.ExecuteNonQuery("sprInsertCustomer", param);
}
}
public void update(ModelCustomer MC)
{
using (DBAccess.DBAccess db = new DBAccess.DBAccess())
{
string[,] param = {
{"@ID", MC.Id.ToString()},
{"@NAME", MC.Name},
{"@ADDRESS", MC.Address}
};
db.ExecuteNonQuery("sprUpdateCustomer", param);
}
}
