//
// GET: /AttProcessors/Create
public ActionResult Create()
{
TAS2013Entities db = new TAS2013Entities();
User LoggedInUser = Session["LoggedUser"] as User;
QueryBuilder qb = new QueryBuilder();
String query = qb.QueryForCompanyViewLinq(LoggedInUser);
ViewBag.PeriodTag = new SelectList(new List<SelectListItem>
{
new SelectListItem { Selected = true, Text = "Daily", Value = "D"},
new SelectListItem { Selected = false, Text = "Monthly", Value = "M"},
new SelectListItem { Selected = false, Text = "Summary", Value = "S"},
}, "Value" , "Text",1);
ViewBag.CriteriaID = new SelectList(new List<SelectListItem>
{
new SelectListItem { Selected = true, Text = "Company", Value = "C"},
new SelectListItem { Selected = false, Text = "Location", Value = "L"},
}, "Value", "Text", 1);
ViewBag.ProcessCats = new SelectList(new List<SelectListItem>
{
new SelectListItem { Selected = true, Text = "Yes", Value = "1"},
new SelectListItem { Selected = false, Text = "No", Value = "0"},
}, "Value", "Text", 1);
ViewBag.CompanyID = new SelectList(db.Companies.Where(query).OrderBy(s=>s.CompName), "CompID", "CompName");
query = qb.QueryForLocationTableSegerationForLinq(LoggedInUser);
ViewBag.LocationID = new SelectList(db.Locations.Where(query).OrderBy(s=>s.LocName), "LocID", "LocName");
ViewBag.CatID = new SelectList(db.Categories.OrderBy(s=>s.CatName), "CatID", "CatName");
return View();
}
private void BindGridView(string search)
{
User LoggedInUser = HttpContext.Current.Session["LoggedUser"] as User;
QueryBuilder qb = new QueryBuilder();
string query = qb.QueryForCompanyViewLinq(LoggedInUser);
List<Company> _View = da.Companies.Where(query).ToList();
GridViewCompany.DataSource = _View.Where(aa => aa.CompName.ToUpper().Contains(search.ToUpper())).ToList();
GridViewCompany.DataBind();
}
private void BindGridViewDivision(string search)
{
FiltersModel fm = Session["FiltersModel"] as FiltersModel;
List<ViewDivision> _View = new List<ViewDivision>();
List<ViewDivision> _TempView = new List<ViewDivision>();
User LoggedInUser = HttpContext.Current.Session["LoggedUser"] as User;
QueryBuilder qb = new QueryBuilder();
string query = qb.QueryForCompanyViewLinq(LoggedInUser);
_View = da.ViewDivisions.Where(query).AsQueryable().OrderBy("DivisionName ASC").ToList();
if (fm.CompanyFilter.Count > 0)
{
foreach (var comp in fm.CompanyFilter)
{
short _compID = Convert.ToInt16(comp.ID);
_TempView.AddRange(_View.Where(aa => aa.CompID == _compID).ToList());
}
_View = _TempView.ToList();
}
GridViewDivision.DataSource = _View.Where(aa => aa.DivisionName.ToUpper().Contains(search.ToUpper())).ToList();
GridViewDivision.DataBind();
}
public ActionResult Edit(short? id)
{
if (id == null)
{
return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
}
Department department = db.Departments.Find(id);
if (department == null)
{
return HttpNotFound();
}
User LoggedInUser = Session["LoggedUser"] as User;
QueryBuilder qb = new QueryBuilder();
string query = qb.QueryForCompanyViewForLinq(LoggedInUser);
string query1 = qb.QueryForCompanyViewLinq(LoggedInUser);
ViewBag.DivID = new SelectList(db.Divisions.Where(query).AsQueryable().OrderBy(s=>s.DivisionName), "DivisionID", "DivisionName", department.DivID);
ViewBag.CompanyID = new SelectList(db.Companies.Where(query1).AsQueryable().OrderBy(s => s.CompName), "CompID", "CompName");
return View(department);
}
private void BindGridView(string search)
{
User LoggedInUser = HttpContext.Current.Session["LoggedUser"] as User;
QueryBuilder qb = new QueryBuilder();
string query = qb.QueryForCompanyViewLinq(LoggedInUser);
GridViewCompany.DataBind();
}
private void BindGridViewSection(string search)
{
FiltersModel fm = Session["FiltersModel"] as FiltersModel;
List<ViewSection> _View = new List<ViewSection>();
List<ViewSection> _TempView = new List<ViewSection>();
User LoggedInUser = HttpContext.Current.Session["LoggedUser"] as User;
QueryBuilder qb = new QueryBuilder();
string query = qb.QueryForCompanyViewLinq(LoggedInUser);
DataTable dt = qb.GetValuesfromDB("select * from ViewSection where " + query);
_View = dt.ToList<ViewSection>();
if (fm.CompanyFilter.Count > 0)
{
foreach (var comp in fm.CompanyFilter)
{
short _compID = Convert.ToInt16(comp.ID);
_TempView.AddRange(_View.Where(aa => aa.CompID == _compID).ToList());
}
_View = _TempView.ToList();
}
if (fm.DivisionFilter.Count > 0)
{
_TempView.Clear();
foreach (var comp in fm.DivisionFilter)
{
short _compID = Convert.ToInt16(comp.ID);
_TempView.AddRange(_View.Where(aa => aa.DivID == _compID).ToList());
}
_View = _TempView.ToList();
}
if (fm.DepartmentFilter.Count > 0)
{
_TempView.Clear();
foreach (var comp in fm.DepartmentFilter)
{
short _compID = Convert.ToInt16(comp.ID);
_TempView.AddRange(_View.Where(aa => aa.DeptID == _compID).ToList());
}
_View = _TempView.ToList();
}
GridViewSection.DataSource = _View.Where(aa => aa.SectionName.ToUpper().Contains(search.ToUpper())).ToList();
GridViewSection.DataBind();
}
