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