public ActionResult DeleteConfirmed(int id) { sy_app_setting sy_app_setting = db.sy_app_setting.Find(id); db.sy_app_setting.Remove(sy_app_setting); db.SaveChanges(); return(RedirectToAction("Index")); }
public static string GetSetting(string pKey) { try { sy_app_setting _obj = APPLICATION_SETTING.Where(a => a.app_key.ToUpper() == pKey.ToUpper()).Single <sy_app_setting>(); return(_obj.app_value); } catch { } return(""); }
// GET: appsetting/Create public ActionResult Create() { sy_app_setting sy_app_setting = new sy_app_setting() { app_id = 0, fl_active = true, created_by = UserProfile.UserId, created_date = DateTime.Now }; return(View(sy_app_setting)); }
// GET: appsetting/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } sy_app_setting sy_app_setting = db.sy_app_setting.Find(id); if (sy_app_setting == null) { return(HttpNotFound()); } return(View(sy_app_setting)); }
public ActionResult Edit([Bind(Include = "app_id,app_key,app_value,app_desc")] sy_app_setting sy_app_setting) { if (ModelState.IsValid) { sy_app_setting.fl_active = true; sy_app_setting.created_date = DateTime.Now; sy_app_setting.created_by = UserProfile.UserId; db.Entry(sy_app_setting).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(sy_app_setting)); }
public ActionResult Index(printLabelViewModel model) { sy_app_setting setting = app_setting.APPLICATION_SETTING.Where(a => a.app_key.ToUpper() == "PRINT_BASE_FOLDER").Single <sy_app_setting>(); if (string.IsNullOrWhiteSpace(setting.app_value)) { BASE_FOLDER = @"C:\ASM_PRINT\"; } else { BASE_FOLDER = setting.app_value.ToUpper(); } if (!Directory.Exists(BASE_FOLDER)) { Directory.CreateDirectory(BASE_FOLDER); } //printLabelViewModel model = new printLabelViewModel() //{ // company_id = UserProfile.company_id, // asset_reg_location_id = UserProfile.asset_reg_location_id //}; model.company_id = UserProfile.company_id; model.company_list = db.ms_asmin_company.Where(c => c.fl_active == true && c.deleted_date == null).ToList <ms_asmin_company>(); model.company = db.ms_asmin_company.Find(UserProfile.company_id); model.asset_reg_location_id = UserProfile.asset_reg_location_id; model.asset_reg_location = db.ms_asset_register_location.Find(UserProfile.asset_reg_location_id); model.asset_reg_location_list = db.ms_asset_register_location.Where(c => c.fl_active == true && c.deleted_date == null).ToList <ms_asset_register_location>(); //Set Location List if (UserProfile.asset_reg_location_id == 1) { model.asset_location_list = (from m in db.ms_asset_location.Where(m => (m.fl_active == true && m.deleted_date == null)) select m).ToList(); } else //branch { model.asset_location_list = (from m in db.ms_asset_location.Where(m => (m.fl_active == true && m.deleted_date == null && m.asset_reg_location_id == UserProfile.asset_reg_location_id)) select m).ToList(); } model.asset_category_list = db.ms_asset_category.Where(c => c.fl_active == true && c.deleted_date == null).ToList <ms_asset_category>(); model.department_list = db.ms_department.Where(c => c.fl_active == true && c.deleted_date == null).ToList <ms_department>(); if (model.asset_location_id != null && model.asset_location_id > 0) { var _qry = (from ar in db.tr_asset_registration where (ar.fl_active == true && ar.deleted_date == null && ar.asset_type_id == (int)Enum_asset_type_Key.AssetParent) && ar.company_id == model.company_id && ar.asset_reg_location_id == model.asset_reg_location_id join b in db.ms_asset_register_location on ar.asset_reg_location_id equals b.asset_reg_location_id where (b.fl_active == true && b.deleted_date == null) join e in db.ms_asset_category on ar.category_id equals e.category_id where (e.fl_active == true && e.deleted_date == null && (e.category_id == model.category_id || model.category_id == null || model.category_id == 0)) join f in db.ms_asmin_company on ar.company_id equals f.company_id where (f.fl_active == true && f.deleted_date == null) join g in db.ms_department on ar.department_id equals g.department_id where (g.fl_active == true && g.deleted_date == null && (g.department_id == model.department_id || model.department_id == null || model.department_id == 0)) join i in db.ms_asset_location on ar.location_id equals i.location_id where (i.fl_active == true && i.deleted_date == null && i.location_id == model.asset_location_id) select new Print_Asset_Items() { asset_id = ar.asset_id, asset_number = ar.asset_number, asset_name = ar.asset_name, category_id = ar.category_id, category_name = e.category_name, department_id = ar.department_id, department_name = g.department_name, Value = ar.asset_id.ToString(), Text = ar.asset_name, Checked = false }).ToList <Print_Asset_Items>(); model.print_asset_items = _qry; } return(View(model)); }