public void Disable(string[] disable)
{
MyConnectionDB db = new MyConnectionDB();
foreach (string dt in disable)
{
string sql = string.Format("update HoiVien set Disable = 1 where APK = '{0}'", dt);
db.Execute(sql);
}
}
public void Destroy(string[] destroy)
{
MyConnectionDB db = new MyConnectionDB();
foreach (string dt in destroy)
{
string sql = string.Format("delete from hoivien where APK = '{0}'", dt);
db.Execute(sql);
}
}
public ActionResult Destroy(string[] dl, int page)
{
MyConnectionDB db = new MyConnectionDB();
foreach (string dt in dl)
{
string sql = string.Format("delete from hoivien where APK = '{0}'", dt);
db.Execute(sql);
}
var dele = Search(page);
return Json(dele.Items);
}
public ActionResult Disable(string[] dl, int page)
{
MyConnectionDB db = new MyConnectionDB();
foreach (string dt in dl)
{
string sql = string.Format("update HoiVien set Disable = 1 where APK = '{0}'", dt);
db.Execute(sql);
}
var dis = Search(page);
return Json(dis.Items);
}
public ActionResult Createmember(DemoModels create)
{
int disable = 0;
if (create.Disable == true)
disable = 1;
string sql = "Insert into HoiVien (DivisionID,MemberID,MemberName,ShortName,Address,Identify,Phone,Tel,Fax,Email,Birthday,Website,Mailbox,AreaName,CityName,CountryName,WardName,CountyName,Disable) values (N'" + create.DivisionID + "',N'" + create.MemberID + "',N'" + create.MemberName + "',N'" + create.ShortName + "',N'" + create.Address + "',N'" + create.Identify + "',N'" + create.Phone + "',N'" + create.Tel + "',N'" + create.Fax + "',N'" + create.Email + "',N'" + create.Birthday + "',N'" + create.Website + "',N'" + create.Mailbox + "',N'" + create.AreaName + "',N'" + create.CityName + "',N'" + create.CountryName + "',N'" + create.WardName + "',N'" + create.CountyName + "','" + disable + "')";
MyConnectionDB db = new MyConnectionDB();
db.Execute(sql);
var cr = Search(1);
return Json(cr.Items);
}
