// 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();
}
