// checks for an existing user in the db protected void btn_confirm_Click(object sender, EventArgs e) { bool isVerify = false; if (connObj == null) { connObj = new Models.AccessConnection(); } UserTable ut = new UserTable(); ut.Username = txt_name.Text; ut.Password = txt_pass.Text; isVerify = connObj.Verify(ut.Username, ut.Password); if (isVerify) { moveUser = ut.Username; Response.Redirect("PassChange.aspx"); } else { lbl_res.Text = "wrong password / user does not exist"; connObj = null; } }
/// <summary> /// creates new user in db /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btn_NewUser_Click(object sender, EventArgs e) { bool isVerify = false; if (connObj == null) { connObj = new Models.AccessConnection(); } UserTable ut = new UserTable(); string msg; ut.Username = txt_name.Text; ut.Password = txt_pass.Text; bool checkName= client.GetData(ut); if (checkName) { Response.Redirect("main.aspx"); } else { lbl_res.Text = "Username already exists"; connObj = null; } }
/// <summary> /// Returns the logged in user /// </summary> /// <returns></returns> public static IdentityUser GetCurrentUser() { string user_id = null; var claimsIdentity = System.Web.HttpContext.Current.GetOwinContext().Authentication.User.Identity as ClaimsIdentity; if (claimsIdentity != null) { var userIdClaim = claimsIdentity.Claims .FirstOrDefault(x => x.Type == ClaimTypes.NameIdentifier); if (userIdClaim != null) { user_id = userIdClaim.Value; } } if (user_id != null) { MySQLDatabase db = new MySQLDatabase("DefaultConnection"); UserTable<IdentityUser> table = new UserTable<IdentityUser>(db); var user = table.GetUserById(user_id); return user; } return null; }
private void UBtnSave_MouseClick(object sender, MouseEventArgs e) { try { if (UTextBoxFullName.Text.Trim() != "" && UTextBoxUserName.Text.Trim() != "" && UTextBoxPassword.Text.Trim() != "" && UTextBoxConfirmPassword.Text.Trim() != "") { int TempId = 0; try { Int32.TryParse(u[0].UserId.ToString(), out TempId); } catch (Exception) { } if (objUserService.IsUsernameExist(UTextBoxUserName.Text, TempId).Count < 1) { if (UBtnSave.Text == "Save") { UserTable obj = new UserTable(); obj.FullName = UTextBoxFullName.Text; obj.UserName = UTextBoxUserName.Text; obj.Password = UTextBoxPassword.Text; obj.ConfirmPassword = UTextBoxConfirmPassword.Text; if (UCheckBoxIsAdmin.Checked == true) { obj.IsAdmin = 1; } else { obj.IsAdmin = 0; } if (objUserService.SaveUser(obj, 0)) { MessageBox.Show("User Added Seccessfully."); User.Show(); this.Close(); } else { MessageBox.Show("User Insertion Failed"); } } else if (UBtnSave.Text == "Update") { UserTable obj = new UserTable(); obj.FullName = UTextBoxFullName.Text; obj.UserName = UTextBoxUserName.Text; obj.Password = UTextBoxPassword.Text; obj.ConfirmPassword = UTextBoxConfirmPassword.Text; if (UCheckBoxIsAdmin.Checked == true) { obj.IsAdmin = 1; } else { obj.IsAdmin = 0; } if (objUserService.SaveUser(obj, 1)) { MessageBox.Show("User Updated Seccessfully"); User.Show(); this.Close(); } else { MessageBox.Show("User Updation Failed"); } } } else { MessageBox.Show("Username Already Exist in DataBase"); } } else { MessageBox.Show("Incomplete Form", "Please Fill Complete Form.!"); } } catch (Exception exp) { MessageBox.Show(exp.Message, "Exception Error"); } }
public bool Update(UserTable entity) { throw new NotImplementedException(); }
public void Remove(UserTable entity) { _repo.Remove(entity); }
protected override void SetIsoState(DataContext sourceDataContext, DataContext targetDataContext, DataSyncAction syncAction, StringCollection stringCollection, string delimiter) { switch (syncAction.Type) { case DataSyncOperationType.CreateAggregateFunction: case DataSyncOperationType.CreateInlineTableValuedFunction: case DataSyncOperationType.CreateScalarFunction: case DataSyncOperationType.CreateStoredProcedure: case DataSyncOperationType.CreateTableValuedFunction: case DataSyncOperationType.CreateTrigger: case DataSyncOperationType.CreateView: case DataSyncOperationType.AlterAggregateFunction: case DataSyncOperationType.AlterInlineTableValuedFunction: case DataSyncOperationType.AlterScalarFunction: case DataSyncOperationType.AlterStoredProcedure: case DataSyncOperationType.AlterTableValuedFunction: case DataSyncOperationType.AlterTrigger: case DataSyncOperationType.AlterView: IModule module = null; if (syncAction.DataObject is IModule) { module = (IModule)syncAction.DataObject; } if (module != null) { if (CurrentCatalog == null) { ChangeCatalog(sourceDataContext, targetDataContext, stringCollection, module.Catalog); stringCollection.Add(delimiter); } if (string.Compare(module.Catalog.ObjectName, CurrentCatalog.ObjectName, StringComparison.OrdinalIgnoreCase) != 0) { ChangeCatalog(sourceDataContext, targetDataContext, stringCollection, module.Catalog); stringCollection.Add(delimiter); } if (module.UsesAnsiNulls && !CurrentAnsiNulls) { SetAnsiNullsOn(stringCollection); stringCollection.Add(delimiter); } else if (!module.UsesAnsiNulls && CurrentAnsiNulls) { SetAnsiNullsOff(stringCollection); stringCollection.Add(delimiter); } if (module.UsesQuotedIdentifier && !CurrentQuotedIdentifier) { SetQuotedIdentifierOn(stringCollection); stringCollection.Add(delimiter); } else if (!module.UsesQuotedIdentifier && CurrentQuotedIdentifier) { SetQuotedIdentifierOff(stringCollection); stringCollection.Add(delimiter); } } if (!CurrentAnsiPadding) { SetAnsiPaddingOn(stringCollection); stringCollection.Add(delimiter); } if (!CurrentAnsiWarnings) { SetAnsiWarningsOn(stringCollection); stringCollection.Add(delimiter); } break; case DataSyncOperationType.CreateUserTable: UserTable userTable = null; if (syncAction.DataObject is UserTable) { userTable = (UserTable)syncAction.DataObject; } if (userTable != null) { if (CurrentCatalog == null) { ChangeCatalog(sourceDataContext, targetDataContext, stringCollection, userTable.Catalog); stringCollection.Add(delimiter); } if (string.Compare(userTable.Catalog.ObjectName, CurrentCatalog.ObjectName, StringComparison.OrdinalIgnoreCase) != 0) { ChangeCatalog(sourceDataContext, targetDataContext, stringCollection, userTable.Catalog); stringCollection.Add(delimiter); } if (userTable.UsesAnsiNulls && !CurrentAnsiNulls) { SetAnsiNullsOn(stringCollection); stringCollection.Add(delimiter); } else if (!userTable.UsesAnsiNulls && CurrentAnsiNulls) { SetAnsiNullsOff(stringCollection); stringCollection.Add(delimiter); } var createWithAnsiPadding = true; foreach (var userTableColumn in userTable.UserTableColumns) { if (!userTableColumn.IsAnsiPadded && IsDataTypeAnsiPaddable(userTableColumn.DataType)) { createWithAnsiPadding = false; } } if (createWithAnsiPadding && !CurrentAnsiPadding) { SetAnsiPaddingOn(stringCollection); stringCollection.Add(delimiter); } else if (!createWithAnsiPadding && CurrentAnsiPadding) { SetAnsiPaddingOff(stringCollection); stringCollection.Add(delimiter); } } if (!CurrentQuotedIdentifier) { SetQuotedIdentifierOn(stringCollection); stringCollection.Add(delimiter); } if (!CurrentAnsiWarnings) { SetAnsiWarningsOn(stringCollection); stringCollection.Add(delimiter); } break; case DataSyncOperationType.AddUserTableColumn: case DataSyncOperationType.AlterUserTableColumn: if (!CurrentAnsiNulls) { SetAnsiNullsOn(stringCollection); stringCollection.Add(delimiter); } if (!CurrentQuotedIdentifier) { SetQuotedIdentifierOn(stringCollection); stringCollection.Add(delimiter); } UserTableColumn alteredUserTableColumn = null; if (syncAction.DataObject is UserTableColumn) { alteredUserTableColumn = (UserTableColumn)syncAction.DataObject; } if (alteredUserTableColumn != null) { if (CurrentCatalog == null) { ChangeCatalog(sourceDataContext, targetDataContext, stringCollection, alteredUserTableColumn.Catalog); stringCollection.Add(delimiter); } if (string.Compare(alteredUserTableColumn.Catalog.ObjectName, CurrentCatalog.ObjectName, StringComparison.OrdinalIgnoreCase) != 0) { ChangeCatalog(sourceDataContext, targetDataContext, stringCollection, alteredUserTableColumn.Catalog); stringCollection.Add(delimiter); } if (alteredUserTableColumn.IsAnsiPadded && !CurrentAnsiPadding) { SetAnsiPaddingOn(stringCollection); stringCollection.Add(delimiter); } else if (!alteredUserTableColumn.IsAnsiPadded && CurrentAnsiPadding) { SetAnsiPaddingOff(stringCollection); stringCollection.Add(delimiter); } } if (CurrentAnsiWarnings) { SetAnsiWarningsOff(stringCollection); stringCollection.Add(delimiter); } break; default: ICatalog catalogBasedDataObject = null; if (syncAction.DataObject is ICatalog) { catalogBasedDataObject = (ICatalog)syncAction.DataObject; } if (catalogBasedDataObject != null) { if (CurrentCatalog == null) { ChangeCatalog(sourceDataContext, targetDataContext, stringCollection, catalogBasedDataObject.Catalog); stringCollection.Add(delimiter); } if (string.Compare(catalogBasedDataObject.Catalog.ObjectName, CurrentCatalog.ObjectName, StringComparison.OrdinalIgnoreCase) != 0) { ChangeCatalog(sourceDataContext, targetDataContext, stringCollection, catalogBasedDataObject.Catalog); stringCollection.Add(delimiter); } } if (!CurrentAnsiNulls) { SetAnsiNullsOn(stringCollection); stringCollection.Add(delimiter); } if (!CurrentQuotedIdentifier) { SetQuotedIdentifierOn(stringCollection); stringCollection.Add(delimiter); } if (!CurrentAnsiPadding) { SetAnsiPaddingOn(stringCollection); stringCollection.Add(delimiter); } if (!CurrentAnsiWarnings) { SetAnsiWarningsOn(stringCollection); stringCollection.Add(delimiter); } break; } }
// POST: api/Users public void Post([FromBody] UserTable u1) { YRentDB.UserTable.Add(u1); YRentDB.SaveChanges(); }
public T Get(int code) { Type type = typeof(T); var props = type.GetProperties().Where(r => r.Name != "Changed"); T model = (T)Activator.CreateInstance(type); UserTable userTable = (UserTable)Controller.ConnectionController.Instance.Company.UserTables.Item(TableName); try { if (userTable.GetByKey(code.ToString())) { foreach (var prop in props) { Model.BaseModel.NonDB nonDB = prop.GetCustomAttribute(typeof(Model.BaseModel.NonDB)) as Model.BaseModel.NonDB; if (nonDB == null) { if (prop.PropertyType == typeof(Boolean)) { prop.SetValue(model, userTable.UserFields.Fields.Item("U_" + prop.Name).Value.ToString().Equals("Y"), null); } else if (prop.PropertyType.IsEnum) { prop.SetValue(model, Convert.ChangeType(userTable.UserFields.Fields.Item("U_" + prop.Name).Value, Enum.GetUnderlyingType(prop.PropertyType)), null); } else { prop.SetValue(model, userTable.UserFields.Fields.Item("U_" + prop.Name).Value); } } } return(model as T); } else { foreach (var prop in props) { Model.BaseModel.NonDB nonDB = prop.GetCustomAttribute(typeof(Model.BaseModel.NonDB)) as Model.BaseModel.NonDB; if (nonDB == null) { if (prop.PropertyType == typeof(Boolean)) { prop.SetValue(model, userTable.UserFields.Fields.Item("U_" + prop.Name).Value.ToString().Equals("Y"), null); } else if (prop.PropertyType.IsEnum) { prop.SetValue(model, Convert.ChangeType(userTable.UserFields.Fields.Item("U_" + prop.Name).Value, Enum.GetUnderlyingType(prop.PropertyType)), null); } else { prop.SetValue(model, userTable.UserFields.Fields.Item("U_" + prop.Name).Value); } } } return(model as T); } } finally { Marshal.ReleaseComObject(userTable); } }
private void sendReport(UserTable userModel, DateTime currentDate) { // Rapor taslağı oluştur // GEçen haftanın verileri gelir ChartHelper chartHelper = new ChartHelper(); StringBuilder sb = new StringBuilder(); var lastMonday = Convert.ToDateTime(currentDate.AddDays(-(int)currentDate.DayOfWeek - 6).ToShortDateString()); currentDate = Convert.ToDateTime(currentDate.ToShortDateString()); sb.AppendLine("Geçen Hafta Alınan Ve Kapatılan Hatalar Durumu"); var openAndClosedErrorsCountList = chartHelper.getErrorCountThisMonthWithDate(lastMonday, currentDate); // geçen haftadan şuana kadar geçen 1 haftalık veriler foreach (var item in openAndClosedErrorsCountList) { sb.AppendLine(item.label + " :" + item.y.ToString()); } sb.AppendLine("--------------------------------------"); sb.AppendLine("Geçen Hafta Oluşturulan Hata Sayıları"); var createdErrorCountList = chartHelper.getErrorCountDayByDayInOneMonthWithDate(lastMonday, currentDate); // geçen haftadan şuana kadar geçen 1 haftalık veriler foreach (var item in createdErrorCountList) { sb.AppendLine(item.label + " :" + item.y.ToString()); } sb.AppendLine("--------------------------------------"); sb.AppendLine("Geçen Hafta Günlük Kapatılan Hatalar"); var closedErrorsDayByDayList = chartHelper.getClosedErrorDayByDayIMonthWithDate(lastMonday, currentDate); // geçen haftadan şuana kadar geçen 1 haftalık veriler foreach (var item in closedErrorsDayByDayList) { sb.AppendLine(item.label + " :" + item.y.ToString()); } sb.AppendLine("--------------------------------------"); sb.AppendLine("Geçen Haftanın Hata Kaynakları"); var errorSourceList = chartHelper.getErrorResourceChartDataWithDate(lastMonday, currentDate); // geçen haftadan şuana kadar geçen 1 haftalık veriler foreach (var item in errorSourceList) { sb.AppendLine(item.label + " :" + item.y.ToString()); } sb.AppendLine("--------------------------------------"); sb.AppendLine("Geçen Hafta Hata Alınan Müşteriler"); var companyNamesList = chartHelper.getCompanyNameAndCountPieChartWithDate(lastMonday, currentDate); // geçen haftadan şuana kadar geçen 1 haftalık veriler foreach (var item in companyNamesList) { sb.AppendLine(item.label + " :" + item.y.ToString()); } sb.AppendLine("--------------------------------------"); sb.AppendLine("Geçen Haftadaki Son Adımlar"); var lastStepsList = chartHelper.getLastStepsInMonthWithDate(lastMonday, currentDate); // geçen haftadan şuana kadar geçen 1 haftalık veriler foreach (var item in lastStepsList) { sb.AppendLine(item.label + " :" + item.y.ToString()); } sb.AppendLine("--------------------------------------"); sb.AppendLine("Geçen Haftadaki Referans Numaraları"); var errorReferenceList = chartHelper.getReferenceNumberCountThisMonthWithDate(lastMonday, currentDate); // geçen haftadan şuana kadar geçen 1 haftalık veriler foreach (var item in errorReferenceList) { sb.AppendLine(item.label + " :" + item.y.ToString()); } sb.AppendLine("--------------------------------------"); sb.AppendLine("Geçen Haftadaki Hata Tanımları"); var errorDefineList = chartHelper.getThisMonthErrorDefinesWithDate(lastMonday, currentDate); // geçen haftadan şuana kadar geçen 1 haftalık veriler foreach (var item in errorDefineList) { sb.AppendLine(item.label + " :" + item.y.ToString()); } sb.AppendLine("--------------------------------------"); sb.AppendLine("Geçen Haftadaki En Çok Hatalı Parça"); var mostWrong10PartList = chartHelper.getMostWrong10PartThisMonthWithDate(lastMonday, currentDate); // geçen haftadan şuana kadar geçen 1 haftalık veriler foreach (var item in mostWrong10PartList) { sb.AppendLine(item.label.Trim() + " :" + item.y.ToString()); } sb.AppendLine("--------------------------------------"); senMailForSuperUsers(sb, lastMonday, currentDate); }
public bool SaveUser(UserTable model, int checkupdate) { return(objUserProviders.SaveUser(model, checkupdate)); }
/// <summary> /// /// </summary> /// <param name="message"></param> /// <param name="user"></param> private async Task <AuthenticateResult> PassAuthentication(Message message, UserTable user) { user.UserInfo.Password = message.Text; return(await AuthenticationClient.Auhenticate(user.UserInfo)); }
/// <summary> /// Salva o model no BD de acordo com o tipo da operação /// </summary> /// <param name="enumCrudOperation">Operação - Create ou Update</param> /// <param name="tableName">Nome da tabela</param> /// <param name="model">Modelo</param> private void SaveNonObjectModel(EnumCrudOperation enumCrudOperation) { UserTable utbUser = SBOApp.Company.UserTables.Item(TableName.Replace("@", "")); string code = Model.GetType().GetProperty("Code").GetValue(Model, null).ToString(); bool alreadyExists = utbUser.GetByKey(code); if (!String.IsNullOrEmpty(code)) { utbUser.Code = code; } else { utbUser.Code = CrudController.GetNextCode(TableName); } utbUser.Name = utbUser.Code; ModelControllerAttribute modelController; // Percorre as propriedades do Model foreach (PropertyInfo property in Model.GetType().GetProperties()) { if (property.Name == "Code" || property.Name == "Name") { continue; } // Busca os Custom Attributes foreach (Attribute attribute in property.GetCustomAttributes(true)) { modelController = attribute as ModelControllerAttribute; if (modelController != null) { // Se não for DataBaseField não seta nas properties if (!modelController.DataBaseFieldYN) { break; } if (String.IsNullOrEmpty(modelController.ColumnName)) { modelController.ColumnName = property.Name; } utbUser.UserFields.Fields.Item(modelController.ColumnName).Value = property.GetValue(Model, null); } break; } } switch (enumCrudOperation) { case EnumCrudOperation.Create: utbUser.Add(); break; case EnumCrudOperation.Update: utbUser.Update(); break; default: break; } Marshal.ReleaseComObject(utbUser); utbUser = null; GC.Collect(); }
public IEnumerable <MailTable> Get([FromBody] UserTable user) { return(_context.getAllSentMails(user.username).ToList()); }
public void Remove(UserTable entity) { _context.Users.Remove(entity); }
public void Modify(UserTable entity) { _context.Users.Attach(entity); _context.Entry(entity).State = EntityState.Modified; }
public int Add(UserTable entity) { _context.Users.Add(entity); return(entity.Identifier); }
private void button_add_Click(object sender, EventArgs e) { int type = 0; String fname = Txt_fname.Text; String lname = txt_lname.Text; String con = Txt_Con.Text; String add = Txt_add.Text; String user = Txt_user.Text; String pass1 = Txt_pass1.Text; String pass2 = Txt_pass2.Text; String post = cmb_post.Text; if (post == "Admin") { type = 1; } else if (post == "Tester") { type = 2; } else if (post == "Developer") { type = 3; } if (string.IsNullOrEmpty(fname)) { MessageBox.Show("Please Enter First Name"); } else if (string.IsNullOrEmpty(lname)) { MessageBox.Show("Please Enter Lastname"); } else if (string.IsNullOrEmpty(con)) { MessageBox.Show("Please Enter Contact No"); } else if (string.IsNullOrEmpty(add)) { MessageBox.Show("Please Enter Address"); } else if (string.IsNullOrEmpty(user)) { MessageBox.Show("Please Enter Username"); } else if (string.IsNullOrEmpty(pass1)) { MessageBox.Show("Please Enter Password"); } else if (string.IsNullOrEmpty(pass2)) { MessageBox.Show("Please Enter password"); } else if (pass1 != pass2) { MessageBox.Show("Password Do not Math"); } else { UserTable us = new UserTable() { address = add, contact = con, fname = fname, lname = lname, username = user, password = pass1, type_id = type }; UserDAO users = new UserDAO(); int done = users.Insert(us); if (done != 0) { MessageBox.Show("user registered"); ClearUserFields(); } else { MessageBox.Show("Something Went Wrong"); } } }
public ActionResult CreateUser(UserTable user) { if (user != null) { if (ModelState.IsValid) { var finduser = db.UserTables.Where(u => u.Email == user.Email).FirstOrDefault(); if (finduser == null) { finduser = db.UserTables.Where(u => u.Email == user.Email && u.isVerified == false).FirstOrDefault(); if (finduser == null) { if (user.UserTypeID == 2) //doctor { user.isVerified = false; } else if (user.UserTypeID == 3) // lab { user.isVerified = false; } else if (user.UserTypeID == 4) // patient { user.isVerified = true; } else if (user.UserTypeID == 1)//admin { user.isVerified = false; } db.UserTables.Add(user); db.SaveChanges(); Session["User"] = user; if (user.UserTypeID == 2) //doctor { return(RedirectToAction("AddDoctor")); } else if (user.UserTypeID == 3) // lab { return(RedirectToAction("AddLab")); } else if (user.UserTypeID == 4) // patient { return(RedirectToAction("AddPatient")); } else if (user.UserTypeID == 1) //admin { ViewBag.Message = "Account is under review"; } } } else { ViewBag.Message = "Emal already exisit please enter detials"; Session["User"] = finduser; if (finduser.UserTypeID == 2) //doctor { var doc = db.DoctorTables.Where(u => u.UserID == finduser.UserID).FirstOrDefault(); if (doc == null) { return(RedirectToAction("AddDoctor")); } ViewBag.Message = "Account is under review"; } else if (finduser.UserTypeID == 3) // lab { var lab = db.LabTables.Where(u => u.UserID == finduser.UserID).FirstOrDefault(); if (lab == null) { return(RedirectToAction("AddLab")); } ViewBag.Message = "Account is under review"; } else if (finduser.UserTypeID == 4) // patient { var pat = db.PatientTables.Where(u => u.UserID == finduser.UserID).FirstOrDefault(); if (pat == null) { return(RedirectToAction("AddPatient")); } ViewBag.Message = "Account is under review"; } } } } else { ViewBag.Message = "Provide correct detials"; } ViewBag.UserTypeID = new SelectList(db.UserTypeTables.Where(u => u.UserTypeID != 1), "UserTypeID", "UserType", "0"); return(View("CreateUser")); }
public void connectPassworAndUser(UserTable uzytkownik, PasswordTable haslo) { throw new NotImplementedException(); }
public IdentityUnitOfWork(string connectionString) { db = new SQLiteDatabase(connectionString); userManager = new ApplicationUserManager(new UserStore <ApplicationUser, ApplicationRole>(db)); userTable = new UserTable <ApplicationUser>(db); }
public void Save(T model, bool retry = false) { Type type = typeof(T); var props = type.GetProperties().Where(r => r.Name != "Changed" && r.Name != "Code"); UserTable userTable = (UserTable)Controller.ConnectionController.Instance.Company.UserTables.Item(TableName); try { if (userTable.GetByKey(model.Code.ToString())) { foreach (var prop in props) { Model.BaseModel.NonDB nonDB = prop.GetCustomAttribute(typeof(Model.BaseModel.NonDB)) as Model.BaseModel.NonDB; if (nonDB == null) { if (prop.PropertyType == typeof(Boolean)) { userTable.UserFields.Fields.Item("U_" + prop.Name).Value = (bool)prop.GetValue(model) ? "Y" : "N"; } else if (prop.PropertyType.IsEnum) { userTable.UserFields.Fields.Item("U_" + prop.Name).Value = (int)prop.GetValue(model); } else { userTable.UserFields.Fields.Item("U_" + prop.Name).Value = prop.GetValue(model); } } } userTable.Update(); Controller.ConnectionController.Instance.VerifyBussinesObjectSuccess(); } else { foreach (var prop in props) { Model.BaseModel.NonDB nonDB = prop.GetCustomAttribute(typeof(Model.BaseModel.NonDB)) as Model.BaseModel.NonDB; if (nonDB == null) { if (prop.PropertyType == typeof(Boolean)) { userTable.UserFields.Fields.Item("U_" + prop.Name).Value = (bool)prop.GetValue(model) ? "Y" : "N"; } else if (prop.PropertyType.IsEnum) { userTable.UserFields.Fields.Item("U_" + prop.Name).Value = (int)prop.GetValue(model); } else { userTable.UserFields.Fields.Item("U_" + prop.Name).Value = prop.GetValue(model); } } } if (model.Code == 0) { Type seqDAOType = Type.GetType(type.AssemblyQualifiedName.Replace("Model", "DAO").Replace(type.Name.Replace("Model", "DAO"), "ConfigSeqDAO")); if (seqDAOType == null) { model.Code = Controller.ConnectionController.Instance.ExecuteSqlForObject <int>("GetLastCode", TableName, new ConfigSeqDAO().TableName); } else { var dao = (DAO.ConfigSeqDAO)Activator.CreateInstance(seqDAOType); model.Code = Controller.ConnectionController.Instance.ExecuteSqlForObject <int>("GetLastCode", TableName, dao.TableName); } } userTable.UserFields.Fields.Item("U_Code").Value = model.Code; userTable.Code = model.Code.ToString(); userTable.Name = model.Code.ToString(); userTable.Add(); try { Controller.ConnectionController.Instance.VerifyBussinesObjectSuccess(); } catch { if (retry) { userTable.Add(); Type seqDAOType = Type.GetType(type.AssemblyQualifiedName.Replace("Model", "DAO").Replace(type.Name.Replace("Model", "DAO"), "ConfigSeqDAO")); if (seqDAOType == null) { model.Code = Controller.ConnectionController.Instance.ExecuteSqlForObject <int>("GetLastCode", TableName, new ConfigSeqDAO().TableName); } else { var dao = (DAO.ConfigSeqDAO)Activator.CreateInstance(seqDAOType); model.Code = Controller.ConnectionController.Instance.ExecuteSqlForObject <int>("GetLastCode", TableName, dao.TableName); } Controller.ConnectionController.Instance.VerifyBussinesObjectSuccess(); } } } } finally { Marshal.ReleaseComObject(userTable); GC.Collect(); } }
public User GetUserByUserId(int id) { return(UserTable.Where(u => u.Id == id).FirstOrDefault()); }
/// <summary> /// 提交新的顾客信息 /// </summary> /// <param name="user">要添加的顾客信息</param> public void AddUserRecord(UserTable user) { service.AddUserRecord(user); }
public int Add(UserTable entity) { return(_repo.Add(entity)); }
public PollUser GetUser(int userId) { return(UserTable.FindById(userId)); }
public LoginWindow() { InitializeComponent(); window = new MainWindow(this); userTable = new UserTable(); }
public long RegisterUser(UserTable user, UserLoginTable userLogin) => userLogicObj.RegisterUser(user, userLogin);
public NotificationController(ServiceOrderTable serviceOrderTable, TenantTable tenantTable, UserTable userTable, NotificationTable notificationTable, ProjectTable projectTable) { _serviceOrderTable = serviceOrderTable; _tenantTable = tenantTable; _userTable = userTable; _notificationTable = notificationTable; _projectTable = projectTable; }
public User GetUserByUserName(string username) { return(UserTable.Where(u => u.UserName == username).FirstOrDefault()); }
public void Modify(UserTable entity) { _repo.Modify(entity); }
public ActionResult AddOrEdit(int id = 0) { UserTable userModel = new UserTable(); return(View(userModel)); }
static Db() { User = new UserTable(); WorkshopSet = new WorkshopSetTable(); }