public static IEnumerable <module> GetMyModules() { DBFactory db; SqlDataReader rdr; List <module> data = null; try { db = new DBFactory("CCATDBEntities"); rdr = db.ExecuteReader("MSI_GetLeftSideMenu", new SqlParameter("@roleName", GetRoleName())); data = new List <module>(); module record; while (rdr.Read()) { record = new module(); record.moduleId = Convert.ToInt32(rdr["moduleId"].ToString()); record.pageMenuGroups = rdr["pageMenuGroups"].ToString(); data.Add(record); } //Close the datareader rdr.Close(); } catch (Exception ex) { throw new Exception("Exception in DataQueries.GetMyModules:" + ex.Message); } return(data.AsEnumerable <module>()); }
public void LoseControl() { if (_grabbed) { Transform _result = _grabbed.GetComponent <module>().OnRelease(this); //TODO: _singleTestTrf = result or _flowTestTrfs[i] = result //TODO: destroy the stuff existing previously module _resultModule = _result.GetComponent <module>(); if (_resultModule._mySpot == module.SpotType.SingleTest) { if (_singleTestTrf) { Destroy(_singleTestTrf.gameObject); _singleTestTrf = null; } _singleTestTrf = _result; //_singleTestButton.GetComponent<button>().ShowSingleModuleRate(_singleTestTrf); //TODO: update single test success rate on something } else if (_resultModule._mySpot == module.SpotType.FlowTest) { _flowButton.GetComponent <button>().SetFlowTest(false); switch (_resultModule._myType) { case module.ModuleType.Tire: if (_flowTestTrfs[0]) { Destroy(_flowTestTrfs[0].gameObject); _flowTestTrfs[0] = null; } _flowTestTrfs[0] = _result; break; case module.ModuleType.Door: if (_flowTestTrfs[1]) { Destroy(_flowTestTrfs[1].gameObject); _flowTestTrfs[1] = null; } _flowTestTrfs[1] = _result; break; case module.ModuleType.Body: if (_flowTestTrfs[2]) { Destroy(_flowTestTrfs[2].gameObject); _flowTestTrfs[2] = null; } _flowTestTrfs[2] = _result; break; default: break; } } _grabbed = null; _grabbedParent = null; } }
/// <summary> /// update /// </summary> /// <param name="obj"></param> /// <returns></returns> public int update(ref module obj) { using (NpgsqlDBConnection db = new NpgsqlDBConnection()) { try { if (db.open_connection()) { string sql_command = "UPDATE modules set " + " item_name = :item_name, module_id =:module_id, " + " on_value = :on_value, off_value =:off_value, " + " input_min = :input_min, input_max =:input_max, " + " output_min = :output_min, output_max =:output_max, " + " error_min = :error_min, error_max =:error_max, " + " channel_number =:channel_number, off_set =:off_set " + " where id = :id"; using (NpgsqlCommand cmd = db._conn.CreateCommand()) { cmd.CommandText = sql_command; cmd.Parameters.Add(":item_name", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.item_name; cmd.Parameters.Add(":module_id", NpgsqlTypes.NpgsqlDbType.Integer).Value = obj.module_id; cmd.Parameters.Add(":channel_number", NpgsqlTypes.NpgsqlDbType.Integer).Value = obj.channel_number; cmd.Parameters.Add(":on_value", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.on_value; cmd.Parameters.Add(":off_value", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.off_value; cmd.Parameters.Add(":input_min", NpgsqlTypes.NpgsqlDbType.Integer).Value = obj.input_min; cmd.Parameters.Add(":input_max", NpgsqlTypes.NpgsqlDbType.Integer).Value = obj.input_max; cmd.Parameters.Add(":output_min", NpgsqlTypes.NpgsqlDbType.Integer).Value = obj.output_min; cmd.Parameters.Add(":output_max", NpgsqlTypes.NpgsqlDbType.Integer).Value = obj.output_max; cmd.Parameters.Add(":error_min", NpgsqlTypes.NpgsqlDbType.Integer).Value = obj.error_min; cmd.Parameters.Add(":error_max", NpgsqlTypes.NpgsqlDbType.Integer).Value = obj.error_max; cmd.Parameters.Add(":off_set", NpgsqlTypes.NpgsqlDbType.Double).Value = obj.off_set; cmd.Parameters.Add(":id", NpgsqlTypes.NpgsqlDbType.Integer).Value = obj.id; cmd.ExecuteNonQuery(); db.close_connection(); return(obj.id); } } else { db.close_connection(); return(-1); } } catch (NpgsqlException ex) { if (db != null) { db.close_connection(); } return(-1); } } }
private void bDelModule_Click(object sender, RoutedEventArgs e) { module current = dbGridModules.SelectedItem as module; core.serviceCenterDB.modules.Remove(current); core.serviceCenterDB.SaveChanges(); updateModules(); }
public ActionResult DeleteConfirmed(string id) { module module = db.modules.Find(id); db.modules.Remove(module); db.SaveChanges(); return(RedirectToAction("Index")); }
private async void _button_clicked(object sender, EventArgs e) { if (!string.IsNullOrWhiteSpace(_FirstName.Text) && !string.IsNullOrWhiteSpace(_LastName.Text) && !string.IsNullOrWhiteSpace(_Email.Text) && !string.IsNullOrWhiteSpace(_Password.Text) && !string.IsNullOrWhiteSpace(_Num.Text) && !string.IsNullOrWhiteSpace(_module.Text)) { var db = new SQLiteConnection(_dbPath); var maxPK = db.Table <Teacher>().OrderByDescending(c => c.Id).FirstOrDefault(); Teacher teach = new Teacher() { Id = (maxPK == null ? 1 : maxPK.Id + 1), FirstName = _FirstName.Text, LastName = _LastName.Text, Num = _Num.Text, Email = _Email.Text.Trim(), Password = _Password.Text.Trim() }; db.Insert(teach); var maxPK3 = db.Table <student>().OrderByDescending(c => c.Id).FirstOrDefault(); /* * student std = new student { * Email = "*****@*****.**", * FirstName = "oussama", * LastName = "el aaoumari", * Id = (maxPK == null ? 1 : maxPK3.Id + 1), * Nb_Absent = 0, * Nb_Present = 0, * Num = "063946765" * }; * db.Insert(std); */ db.CreateTable <module>(); var maxPK2 = db.Table <module>().OrderByDescending(c => c.Id).FirstOrDefault(); module mod = new module() { Id = (maxPK2 == null ? 1 : maxPK2.Id + 1), Name = _module.Text }; db.Insert(mod); await DisplayAlert("Alert", teach.FirstName + " " + teach.LastName + " Added", "Log In"); await Navigation.PushAsync(new LoginPage()); } else { warning.Text = "Please Fill All the Fields !! "; } }
private void bEditModule_Click(object sender, RoutedEventArgs e) { module current = dbGridModules.SelectedItem as module; Windows.ModuleWindow w = new Windows.ModuleWindow(current); w.ShowDialog(); //(core.serviceCenterDB.modules.Where(m => m.Id == w.Module.Id).First()) core.serviceCenterDB.SaveChanges(); updateModules(); }
public ModuleWindow(module module) { currentModule = module; init(); cbType.SelectedItem = currentModule.typeOfModule; tbName.Text = currentModule.name; tbInStock.Text = currentModule.numberInStock.ToString(); tbToOrder.Text = currentModule.needToOrder.ToString(); tbSafetyStock.Text = currentModule.safetyStock.ToString(); }
/// <summary> /// Gets module by name. /// </summary> /// <param name="module1">The module1.</param> /// <returns>module</returns> /// <remarks></remarks> public static module GetModuleByName(string module1) { module mod = new module(); DocsLinqDataContext doc_db = new DocsLinqDataContext(); mod = (from m in doc_db.modules where m.module1.Equals(module1) select m).FirstOrDefault<module>(); return mod; }
public ActionResult Edit([Bind(Include = "moduleCode,deptCode,moduleTitle")] module module) { if (ModelState.IsValid) { db.Entry(module).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.deptCode = new SelectList(db.departments, "code", "name", module.deptCode); return(View(module)); }
public ActionResult Create([Bind(Include = "moduleCode,deptCode,moduleTitle")] module module) { if (ModelState.IsValid) { db.modules.Add(module); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.deptCode = new SelectList(db.departments, "code", "name", module.deptCode); return(View(module)); }
static void Main(string[] args) { System.IO.StreamReader str = new System.IO.StreamReader("test.xml"); XmlSerializer xSerializer = new XmlSerializer(typeof(module)); module m = (module)xSerializer.Deserialize(str); str.Close(); Console.WriteLine(m.name); Console.ReadLine(); }
// GET: modules/Details/5 public ActionResult Details(string deptCode, string moduleCode) { if (deptCode == null || moduleCode == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } module module = db.modules.Find(moduleCode, deptCode); if (module == null) { return(HttpNotFound()); } return(View(module)); }
// GET: modules/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } module module = db.modules.Find(id); if (module == null) { return(HttpNotFound()); } return(View(module)); }
public void Submit(module model) { model.IsDeleted = false; model.UpdateTime = DateTime.Now; if (model.ID == 0) { entity.module.Add(model); } else { entity.Entry <module>(model).State = System.Data.Entity.EntityState.Modified; } entity.SaveChanges(); }
private void addEditButton_Click(object sender, RoutedEventArgs e) { string descriptionModule = new TextRange(rtbEditor.Document.ContentStart, rtbEditor.Document.ContentEnd).Text; if (db.module.Where(p => p.moduleId == moduleID).Any()) { if (moduleName.Text != "" || descriptionModule != "" || imageArray != null) { var module = db.module.Where(p => p.moduleId == moduleID).FirstOrDefault(); module.moduleName = moduleName.Text; module.description = descriptionModule; module.moduleImage = imageArray; db.SaveChanges(); } } else { if (moduleName.Text != "" && descriptionModule != "" && imageArray != null) { module addModule = new module { moduleName = moduleName.Text, description = descriptionModule, moduleImage = imageArray }; test addTest = new test { testName = moduleName.Text, moduleId = addModule.moduleId }; badge addBadge = new badge { badgeName = moduleName.Text, badgeImage = imageArray, moduleId = addModule.moduleId }; db.module.Add(addModule); db.test.Add(addTest); db.badge.Add(addBadge); db.SaveChanges(); } moduleName.Clear(); moduleImage.ImageSource = null; rtbEditor.Document.Blocks.Clear(); } }
// GET: modules/Edit/5 public ActionResult Edit(string deptCode, string moduleCode) { if (deptCode == null || moduleCode == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } module module = db.modules.Find(moduleCode, deptCode); if (module == null) { return(HttpNotFound()); } ViewBag.deptCode = new SelectList(db.departments, "code", "name", module.deptCode); return(View(module)); }
public Login Loginpost(LoginInput logininfo) { using (var entity = new CASChillerSystemEntities()) { Login login = new Login(); string username = logininfo.Username; string password = logininfo.Password; string appname = logininfo.Appname; if (Membership.ValidateUser(username, password)) { aspnet_Users asp_user = entity.aspnet_Users.Where(x => x.UserName == username).FirstOrDefault(); User user = entity.Users.Where(y => y.userlogin_id == asp_user.UserId).FirstOrDefault(); List <Modules> modulelist = new List <Modules>(); List <user_module> uml = entity.user_module.Where(z => z.users_id == user.Users_ID && z.menu_group == appname).ToList(); if (uml != null && uml.Count != 0) { login.Status = true; for (int i = 0; i < uml.Count; i++) { Modules modules = new Modules(); int moduleid = (int)uml[i].Module_ID; modules.Module_Name = entity.modules.Where(x => x.module_id == moduleid).Select(y => y.module_name).FirstOrDefault(); modules.Module_Display = uml[i].module_display_name; int module_id = (int)uml[i].Module_ID; module module = entity.modules.Where(x => x.module_id == module_id).FirstOrDefault(); modules.Module_Icon = module.description; modulelist.Add(modules); } login.AppName = appname; login.Token = entity.aspnet_Membership.Where(y => y.UserId == asp_user.UserId).Select(x => x.Password).FirstOrDefault(); login.Modules = modulelist; login.Id = user.Users_ID; //insert user login record to Transaction_Log table Transaction_Log tl = new Transaction_Log(); tl.Log_Description = "User Login"; tl.Creation_Time = DateTime.Now; tl.Creator = login.Id; tl.Remarks = appname; entity.Transaction_Log.Add(tl); entity.SaveChanges(); } } return(login); } }
/// <summary> /// get info by id /// </summary> /// <param name="id"></param> /// <returns></returns> public module get_info_by_id(int id) { using (NpgsqlDBConnection db = new NpgsqlDBConnection()) { try { module obj = null; if (db.open_connection()) { string sql_command = "SELECT * FROM modules WHERE id = " + id; sql_command += " LIMIT 1"; using (NpgsqlCommand cmd = db._conn.CreateCommand()) { cmd.CommandText = sql_command; NpgsqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { obj = new module(); obj = (module)_get_info(reader); break; } reader.Close(); db.close_connection(); return(obj); } } else { db.close_connection(); return(null); } } catch { if (db != null) { db.close_connection(); } return(null); } finally { db.close_connection(); } } }
private void ListViewItem_PreviewMouseRightButtonDown(object sender, MouseButtonEventArgs e) { ListViewItem lbi = sender as ListViewItem; if (lbi != null) { module fam = lbi.DataContext as module; if (fam != null) { try { moduleID = fam.moduleId; } catch { } } } }
public ActionResult Edit([Bind(Include = "ModuleID,ModuleCode,ModuleTitle")] module module) { if (ModelState.IsValid) { if (db.modules.Any(s => s.ModuleCode.Equals(module.ModuleCode))) { ViewBag.Error = "Modulis su tokiu kodu jau yra pridėtas."; return(View(module)); } else { db.Entry(module).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } } return(View(module)); }
private async void _saveButton_Clicked(object sender, EventArgs e) { var db = new SQLiteConnection(_dbPath); var maxPK = db.Table <module>().OrderByDescending(c => c.Id).FirstOrDefault(); module mod = new module() { Id = (maxPK == null ? 1 : maxPK.Id + 1), Name = _modueNameEntry.Text }; db.Insert(mod); await DisplayAlert("Alert", "Module : " + mod.Name + " Added", "OK"); await Navigation.PopAsync(); }
/// <summary> /// Get all /// </summary> /// <returns></returns> public IEnumerable <module> get_all() { List <module> listUser = new List <module>(); using (NpgsqlDBConnection db = new NpgsqlDBConnection()) { try { if (db.open_connection()) { string sql_command = "SELECT * FROM modules"; using (NpgsqlCommand cmd = db._conn.CreateCommand()) { cmd.CommandText = sql_command; NpgsqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { module obj = new module(); obj = (module)_get_info(reader); listUser.Add(obj); } reader.Close(); db.close_connection(); return(listUser); } } else { db.close_connection(); return(null); } } catch { if (db != null) { db.close_connection(); } return(null); } finally { db.close_connection(); } } }
private void ListViewItem_PreviewMouseLeftButtonDown(object sender, MouseButtonEventArgs e) { ListViewItem lbi = sender as ListViewItem; if (lbi != null) { module fam = lbi.DataContext as module; if (fam != null) { try { int moduleId = fam.moduleId; main.Children.Clear(); main.Children.Add(new Module(moduleId)); } catch { } } } }
private IEnumerable <module> checkAndInsertModuleConfiguration() { using (module_repository _modules = new module_repository()) { IEnumerable <module> moduleConfigList = _modules.get_all(); MODULE_CONFIG_LIST = moduleConfigList.Select(x => x.item_name).ToArray(); if (moduleConfigList.Count() == MODULE_CONFIG_LIST.Count()) { return(moduleConfigList); } else { foreach (string itemModuleName in MODULE_CONFIG_LIST) { module objExistedModuleByName = _modules.get_info_by_name(itemModuleName); if (objExistedModuleByName != null) { continue; } else { objExistedModuleByName = new module(); objExistedModuleByName.item_name = itemModuleName; if (_modules.add(ref objExistedModuleByName) > 0) { // ok } else { // fail MessageBox.Show(lang.getText("system_error")); this.Close(); return(null); } } } moduleConfigList = _modules.get_all(); return(moduleConfigList); } } }
protected override void OnNavigatedTo(NavigationEventArgs e) { Frame rootFrame = Window.Current.Content as Frame; if (rootFrame.CanGoBack) { // Show UI in title bar if opted-in and in-app backstack is not empty. SystemNavigationManager.GetForCurrentView().AppViewBackButtonVisibility = AppViewBackButtonVisibility.Visible; } else { // Remove the UI from the title bar if in-app back stack is empty. SystemNavigationManager.GetForCurrentView().AppViewBackButtonVisibility = AppViewBackButtonVisibility.Collapsed; } module vm = e.Parameter as module; if (vm != null) { if (vm.ifchecked1 == "true") { line.Visibility = Visibility.Visible; check_box1.IsChecked = true; } else { line.Visibility = Visibility.Collapsed; check_box1.IsChecked = false; } if (vm.ifchecked2 == "true") { line1.Visibility = Visibility.Visible; check_box2.IsChecked = true; } else { line1.Visibility = Visibility.Collapsed; check_box2.IsChecked = false; } } }
public string Submit(module model) { try { var result = Bll.ModuleBll.Instance.Get(m => m.ID == model.ID); if (model.ID == 0 || (model.ID > 0 && result.ModuleCode != model.ModuleCode)) { var isHaveModel = Bll.ModuleBll.Instance.IsHaveModel(m => m.ModuleCode == model.ModuleCode); if (isHaveModel) { return(JsonConvert.SerializeObject(new { data = false, url = "", msg = "已经有编号为" + model.ModuleCode + "的数据" })); } } if (model.ID > 0) { result.Name = model.Name; result.ModuleCode = model.ModuleCode; result.Sort = model.Sort; Bll.ModuleBll.Instance.Submit(result); } else { if (model.ParentId > 0) { var pModel = Bll.ModuleBll.Instance.Get(m => m.ID == model.ParentId); pModel.IsGroup = true; Bll.ModuleBll.Instance.Submit(pModel); } model.CreateTime = DateTime.Now; Bll.ModuleBll.Instance.Submit(model); } } catch (Exception) { return(JsonConvert.SerializeObject(new { data = false, url = "", msg = "保存出错" })); } var url = Url.Action("Index", new { projectCode = model.ProjectCode }); var isEdit = model.ID > 0; return(JsonConvert.SerializeObject(new { data = true, url = url, msg = "保存成功", isEdit = isEdit })); }
protected override void OnNavigatedTo(NavigationEventArgs e) { ViewModule.i = "EditPage"; ViewModule.Date_Time = DateTime.Today; Frame rootFrame = Window.Current.Content as Frame; if (rootFrame.CanGoBack) { // Show UI in title bar if opted-in and in-app backstack is not empty. SystemNavigationManager.GetForCurrentView().AppViewBackButtonVisibility = AppViewBackButtonVisibility.Visible; } else { // Remove the UI from the title bar if in-app back stack is empty. SystemNavigationManager.GetForCurrentView().AppViewBackButtonVisibility = AppViewBackButtonVisibility.Collapsed; } module m = e.Parameter as module; if (m != null) { if (m.title != null) { title_block.Text = m.title; } if (m.detail != null) { detail_block.Text = m.detail; } if (m.Date_Time != null) { date.Date = m.Date_Time; } } }
private void contextModule_Click(object sender, RoutedEventArgs e) { switch ((sender as MenuItem).Name) { case "deleteModule": if (moduleID != 0) { db = new CoursesContext(); module modules = new module { moduleId = moduleID }; db.module.Attach(modules); db.module.Remove(modules); db.SaveChanges(); StartProgramm(db.module.Select(p => p.moduleId).FirstOrDefault()); } break; case "editModule": if (moduleID != 0) { main.Children.Clear(); main.Children.Add(new AddModule(moduleID)); } break; case "addModule": main.Children.Clear(); main.Children.Add(new AddModule()); break; default: break; } }
public ActionResult DeleteConfirmed(int id) { //pirma istrinam moduliu sarysius su studentais while (true) { studentModule studentModule = db.studentModules.Where(s => s.ModuleID == id).FirstOrDefault(); if (studentModule != null) { db.studentModules.Remove(studentModule); db.SaveChanges(); } else { break; } } //tada istrinam modulio paskaitas while (true) { lecture lecture = db.lectures.Where(s => s.ModuleID == id).FirstOrDefault(); if (lecture != null) { db.lectures.Remove(lecture); db.SaveChanges(); } else { break; } } module module = db.modules.Find(id); db.modules.Remove(module); db.SaveChanges(); return(RedirectToAction("Index")); }
select( module : moduleProvider.GetOrDefault().module,