public JsonResult SendToiPad(int id, int techId) { var pricebookName = string.Empty; var tablet = string.Empty; string folder = null; using (var db = GetContext()) { pricebookName = db.tbl_PriceBook.Single(pb => pb.PriceBookID == id).BookName; } using (var db = new EightHundredEntities()) { var result = (from t in db.tbl_Employee join tt in db.tbl_Franchise_Tablets on t.EmployeeID equals tt.EmployeeID join f in db.tbl_Franchise on t.FranchiseID equals f.FranchiseID where t.EmployeeID == techId select new { TabletNumber = tt.TabletNumber }).Single(); folder = Path.Combine(GlobalConfiguration.InitTabletDropPath, result.TabletNumber); tablet = result.TabletNumber; } using (var db = new PriceBookContext()) { db.Database.ExecuteSqlCommand("EXEC [GetXMLByPriceBook] @PriceBookId, @Folder", new System.Data.SqlClient.SqlParameter("PriceBookId", id), new System.Data.SqlClient.SqlParameter("Folder", folder)); } return(Json(new { Success = true, Name = pricebookName, Tablet = tablet })); }
public PriceBookTreeView(PriceBookContext context) { this.context = context; }