//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); }