//Thêm dữ liệu vào sql
public void Createmember(DemoModels create)
{
int disable = 0;
if (create.Disable == true)
disable = 1;
HoiVien create1 = new HoiVien();
create1.DivisionID = create.DivisionID;
create1.MemberID = create.MemberID;
create1.MemberName = create.MemberName;
create1.ShortName = create.ShortName;
create1.Address = create.Address;
create1.Identify = create.Identify;
create1.Phone = create.Phone;
create1.Tel = create.Tel;
create1.Fax = create.Fax;
create1.Email = create.Email;
create1.Birthday = create.Birthday;
create1.Website = create.Website;
create1.Mailbox = create.Mailbox;
create1.AreaName = create.AreaName;
create1.CityName = create.CityName;
create1.CountryName = create.CountryName;
create1.WardName = create.WardName;
create1.CountyName = create.CountyName;
create1.Disable = Convert.ToByte(disable);
MyConnectionDB.GetInstance().Insert(create1);
}
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);
}
