public JsonResult GetListBranch()
        {
            List <Models.ChiNhanh> BranchList = new List <Models.ChiNhanh>();
            Database  db = new Database();
            DataTable dt = db.Query("select * from ChiNhanh; ");

            for (int i = 0; i < dt.Rows.Count; i++)
            {
                Models.ChiNhanh Branch = new Models.ChiNhanh();
                Branch.MaChiNhanh  = dt.Rows[i]["MaChiNhanh"].ToString();
                Branch.TenChiNhanh = dt.Rows[i]["TenchiNhanh"].ToString();
                BranchList.Add(Branch);
            }

            return(Json(BranchList));
        }
        public void AddBranch(Models.ChiNhanh a)
        {
            Database db = new Database();

            db.Insert("insert into ChiNhanh(TenchiNhanh,  DiaChi,HotLine) values (N'" + a.TenChiNhanh + "',N'" + a.DiaChi + "', '" + a.Hotline + "');");
        }