public BusinessResult UpdateUser(BOUser objUser)
{
BusinessResult result = new BusinessResult();
using (var conexion = Util.GetConnection())
{
conexion.Open();
using (var objPE = new UserPE())
{
try
{
objPE.UpdateUser(conexion, objUser);
result.Success = true;
result.Other = objUser;
}
catch (Exception error)
{
result.ErrorsList.Add(error.Message);
}
}
}
return(result);
}
public BusinessResult GetUserById(int id)
{
BusinessResult result = new BusinessResult();
using (var conexion = Util.GetConnection())
{
conexion.Open();
using (var objPE = new UserPE())
{
try
{
BOUser objUser = objPE.GetUserById(conexion, id);
if (objUser == null)
{
result.ErrorsList.Add("Record not found.");
}
else
{
result.Success = true;
result.Other = objUser;
}
}
catch (Exception error)
{
throw new Exception(error.Message);
}
}
}
return(result);
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (Session["UserDetail"] != null)
{
BOUser _bouserDetail = (BOUser)Session["UserDetail"];
if (!IsPostBack)
{
if (Request.QueryString["exmid"] != null && Request.QueryString["tstmd"] != null)
{
string examid = Common.Decrypt(HttpUtility.UrlDecode(Request.QueryString["exmid"]));
ViewState["Mode"] = Request.QueryString["tstmd"];
GetExamDetail(examid);
}
else
{
Response.Redirect("UserLogin.aspx");
}
}
}
else
{
Response.Redirect("Default.aspx", false);
}
}
catch (Exception ex)
{
string exmsg = ex.Message;
}
}
public void Login()
{
bool validated = false;
DacII.WinForms.Security.FrmMyobLogin frm = new DacII.WinForms.Security.FrmMyobLogin(mAccountant);
if (frm.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
validated = true;
}
if (!validated)
{
Exit();
}
else
{
BOUser curr_user = mAccountant.CurrentAuthUser;
if (curr_user != null)
{
AuthRole curr_role = curr_user.Role;
IsFullControl = curr_role == null || curr_role.IsFullControl;
Username = curr_user.Username;
}
ShowCmd();
mMiscPresenter.BackupEnabled = true;
}
}
private void btnRecord_Click(object sender, EventArgs e)
{
ReviseRole();
BOUser current_user = AccountantPool.Instance.CurrentAccountant.User;
current_user.UpdateAuthRole(mRole);
}
public List <BOUser> LoadUsers(int userid, string hostCode)
{
DACategories pDAL = new DACategories();
try
{
var dtStudents = pDAL.LoadUsers(userid, hostCode);
var users = new List <BOUser>();
BOUser std = null;
foreach (DataRow item in dtStudents.Rows)
{
std = new BOUser();
std.FirstName = item["FirstName"].ToString();
std.DepartmentName = item["DepartmentName"].ToString();
std.userid = item["UserId"].ToString();
std.Id = item["Id"].ToString();
users.Add(std);
}
return(users);
}
catch
{
throw;
}
finally
{
pDAL = null;
}
}
public FrmAuthUser()
{
InitializeComponent();
BOUser current_user = AccountantPool.Instance.CurrentAccountant.User;
cboRole.DataSource = current_user.List("AuthRole");
}
private void btnDeleteRole_Click(object sender, EventArgs e)
{
int RoleID;
if (WinFormUtil.DataGridView_GetSelectedID(dgvRoles, out RoleID))
{
BOUser current_user = AccountantPool.Instance.CurrentAccountant.User;
AuthRole role = current_user.GetAuthRole(RoleID);
if (role != null)
{
if (current_user.CanDelete(role))
{
if (WinFormUtil.Confirm("Do you want to delete?", "Delete Warning") == DialogResult.Yes)
{
current_user.Delete(role);
ViewModel();
}
}
else if (WinFormUtil.Confirm("Other roles and users have inherited this role, delete this role will also delete them,\r\n do you still want to delete?", "Delete Warning") == DialogResult.Yes)
{
current_user.Delete(role);
ViewModel();
}
}
}
}
public int InsertUser(BOUser user, out string id)
{
id = string.Empty;
SqlParameter[] sqlParams = new SqlParameter[28];
sqlParams[0] = new SqlParameter("@FirstName", user.FirstName);
sqlParams[1] = new SqlParameter("@LastName", user.LastName);
sqlParams[2] = new SqlParameter("@Age", user.Age);
sqlParams[3] = new SqlParameter("@Gender", user.Gender);
sqlParams[4] = new SqlParameter("@DOB", user.DOB);
sqlParams[5] = new SqlParameter("@ContactNo", user.ContactNo);
sqlParams[6] = new SqlParameter("@Qualification", user.Qualification);
sqlParams[7] = new SqlParameter("@Address", user.Address);
sqlParams[8] = new SqlParameter("@Basic", user.Basic);
sqlParams[9] = new SqlParameter("@DA", user.DA);
sqlParams[10] = new SqlParameter("@HRA", user.HRA);
sqlParams[11] = new SqlParameter("@ProfTax", user.ProfTax);
sqlParams[12] = new SqlParameter("@ConvAllowance", user.ConvAllowance);
sqlParams[13] = new SqlParameter("@CapitalCostAllow", user.CapitalCostAllow);
sqlParams[14] = new SqlParameter("@EnterAllowance", user.EnterAllowance);
sqlParams[15] = new SqlParameter("@NetSalary", user.NetSalary);
sqlParams[16] = new SqlParameter("@Department", user.Department);
sqlParams[17] = new SqlParameter("@empid", user.empid);
sqlParams[18] = new SqlParameter("@userid", user.userid);
sqlParams[19] = new SqlParameter("@password", user.password);
sqlParams[20] = new SqlParameter("@SeqQuestion", user.SeqQuestion);
sqlParams[21] = new SqlParameter("@Answer", user.Answer);
sqlParams[22] = new SqlParameter("@DateOfJoin", user.DateOfJoin);
sqlParams[23] = new SqlParameter("@CreatedBy", user.CreatedBy);
sqlParams[24] = new SqlParameter("@CreatedDate", user.CreatedDate);
sqlParams[25] = new SqlParameter("@ModifiedBy", user.ModifiedBy);
sqlParams[26] = new SqlParameter("@ModifiedDate", user.ModifiedDate);
sqlParams[27] = new SqlParameter("@RecordId", id);
return(cmnDA.ExecuteNonQuery("pr_users_AddOrUpdate", sqlParams));
}
private void ViewModel()
{
BOUser current_user = AccountantPool.Instance.CurrentAccountant.User;
dgvUsers.DataSource = current_user.UserDataGridView();
dgvRoles.DataSource = current_user.RoleDataGridView();
}
private void dgvUsers_DoubleClick(object sender, EventArgs e)
{
int UserID;
if (WinFormUtil.DataGridView_GetSelectedID(dgvUsers, out UserID))
{
BOUser current_user = AccountantPool.Instance.CurrentAccountant.User;
AuthUser user = current_user.GetAuthUser(UserID);
if (user != null)
{
FrmAuthUser frm = new FrmAuthUser();
frm.Username = user.Username;
frm.Password = user.Password;
frm.Role = user.Role;
frm.Description = user.Description;
if (frm.ShowDialog() == DialogResult.OK)
{
user.Username = frm.Username;
user.Password = frm.Password;
user.Description = frm.Description;
user.Role = frm.Role;
current_user.SaveAuthUser(user);
ViewModel();
}
}
}
}
public ActionResult RemoveUser(Guid id)
{
BOUser BOU = new BOUser();
BOU.UserId = id;
var Response = client.DeleteAsync("User/" + BOU.UserId).Result;
if (Response.IsSuccessStatusCode)
{
var Responsedata = Convert.ToBoolean(Response.Content.ReadAsStringAsync().Result);
if (Responsedata == true)
{
return(RedirectToAction("ManageUsers", "Users"));
}
else
{
TempData ["DeleteSuccess"] = false;
}
}
else
{
Console.WriteLine("Fail");
}
return(null);
}
public int CreateUser(IDbConnection conexion, BOUser obj)
{
string sql = "INSERT INTO USER " +
"(" +
"EMAIL," +
"CLAVE," +
"COUNTRY" +
")" +
" VALUES " +
"(" +
"'" + obj.Email + "'," +
"'" + obj.Password + "'," +
"'" + obj.Country + "'" +
")";
int resp = 0;
switch (Util._GestorBaseDatos)
{
case Util.GestorBaseDatos.MySQL:
DataBase.ExecuteNonQuery(sql, conexion);
sql = "SELECT AUTO_INCREMENT FROM information_schema.tables WHERE table_name = 'USER'";
resp = Convert.ToInt32(DataBase.ExecuteScalar(sql, conexion)) - 1;
break;
default:
break;
}
return(resp);
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (Session["UserDetail"] != null)
{
BOUser _bouserDetail = (BOUser)Session["UserDetail"];
userId = _bouserDetail.UserId;
if (!IsPostBack)
{
Session["CheckRefresh"] = Server.UrlDecode(System.DateTime.Now.ToString());
FillgirdViewExamDetail(_bouserDetail.UserId);
FillgridViewExamReport(_bouserDetail.UserId);
}
}
else
{
Response.Redirect("Default.aspx", false);
}
}
catch (Exception ex)
{
Common.LogError(ex);
ShowMessage("Some technical error", MessageType.Warning);
}
}
private void LoginFunction()
{
if (ValidateTextBoxes())
{
BOUser _bousr = _bausr.SelectUserDetail("GetUserDetail", txtEmailid.Text, Encryptdata(txtPassword.Password));
if (_bousr != null)
{
if (_bousr.EndDate >= DateTime.Now)
{
if (_bousr.ValidTimeTo >= DateTime.Now)
{
if (!string.IsNullOrEmpty(_bousr.AccessOption))
{
string[] accessoption = _bousr.AccessOption.Split(',');
exists = accessoption.Contains("3");
}
else if (!string.IsNullOrEmpty(_bousr.UGAccessOption))
{
string[] accessoption = _bousr.UGAccessOption.Split(',');
exists = accessoption.Contains("3");
}
if (exists)
{
Application.Current.Properties["Bouser"] = _bousr;
if (txtPassword.Password == Decryptdata(_bousr.AccessPassword))
{
this.Hide();
MainWindow _mainWindow = new ExamSimulator.MainWindow();
_mainWindow.ShowDialog();
}
else
{
MessageBox.Show("Email Id or Password Invalid", "Message", MessageBoxButton.OK, MessageBoxImage.Warning);
txtEmailid.Text = txtPassword.Password = "";
txtEmailid.Focus();
}
}
else
{
MessageBox.Show("You are not authorized to Offline Exam");
}
}
else
{
MessageBox.Show("Your account is expired. contact to merchant");
}
}
else
{
MessageBox.Show("Your account has been expired, please contact your merchant");
}
}
else
{
MessageBox.Show("Email Id or Password Invalid");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["UserDetail"] != null)
{
_bouserDetail = (BOUser)Session["UserDetail"];
if (Session["ExamList"] != null)
{
_examqueanslist = (BOExamManage)Session["ExamList"];
lblExamCode.Text = _examqueanslist.SecondCategory + " " + _examqueanslist.ExamCode;
lblExamName.Text = _examqueanslist.SecondCategory + " " + _examqueanslist.ExamCode;
passingSocre = ((_examqueanslist.QuestionList.Count() * 100) * Convert.ToDouble(_examqueanslist.PassingPercentage)) / 100;
resultScore = _examqueanslist.QuestionList.Where(ur => ur.UserResult == true).Count() * 100;
totalScore = _examqueanslist.QuestionList.Count() * 100;
lblpassingscore.Text = Convert.ToString(passingSocre) + "/" + (totalScore);
lblyourscore.Text = Convert.ToString(resultScore) + " / " + (totalScore);
//lblpbpassingvalue.Text = Convert.ToString(passingSocre);
// lblpbresultvalue.Text = Convert.ToString(_examqueanslist.QuestionList.Where(ur => ur.UserResult == true).Count() * 100);
string htmlpassingvalue = "<div class='progress-bar progress-bar-success' role='progressbar' aria-valuenow='" + Convert.ToString(passingSocre / (totalScore / 100)) + "' aria-valuemin='0' aria-valuemax='100'><span class='skill'><i class='val'>" + Convert.ToString(passingSocre) + "</i></span></div>";
pbpassingvalue.InnerHtml = htmlpassingvalue;
string htmlresultvalue = string.Empty;
if (resultScore >= passingSocre)
{
lblResultMsg.Text = "Congratulation!! You has passed the " + _examqueanslist.SecondCategory + " " + _examqueanslist.ExamCode + " exam";
lblResultMsg.ForeColor = System.Drawing.Color.Green;
htmlresultvalue = "<div class='progress-bar progress-bar-success' role='progressbar' aria-valuenow='" + Convert.ToString(resultScore / (totalScore / 100)) + "' aria-valuemin='0' aria-valuemax='100'><span class='skill'><i class='val'>" + Convert.ToString(resultScore) + "</i></span></div>";
}
else
{
lblResultMsg.Text = "Sorry!! You has failed the " + _examqueanslist.SecondCategory + " " + _examqueanslist.ExamCode + " exam";
lblResultMsg.ForeColor = System.Drawing.Color.Red;
if (resultScore != 0)
{
htmlresultvalue = "<div class='progress-bar progress-bar-danger' role='progressbar' aria-valuenow='" + Convert.ToString(resultScore / (totalScore / 100)) + "' aria-valuemin='0' aria-valuemax='100'><span class='skill'><i class='val'>" + Convert.ToString(resultScore) + "</i></span></div>";
}
else
{
htmlresultvalue = "<div class='progress-bar progress-bar-danger' role='progressbar' aria-valuenow='" + 1 + "' aria-valuemin='0' aria-valuemax='100'><span class='skill'><i class='val'>" + Convert.ToString(resultScore) + "</i></span></div>";
}
}
pbresultvalue.InnerHtml = htmlresultvalue;
DateTime now = DateTime.Now;
lbldate.Text = now.ToShortDateString();
lbltime.Text = now.ToLongTimeString();
Session.Remove("ExamList");
if (_examqueanslist.QuestionList.FirstOrDefault().Event == "TO")
{
UpdateExamManage(_examqueanslist);
InserExamReport(_examqueanslist);
}
}
else
{
Response.Redirect("UserLogin.aspx");
}
}
}
public bool CheckAccessSilent(string objectid, string attribute)
{
BOUser current_user = mAccountant.CurrentAuthUser;
if (current_user.CheckAccess(objectid, attribute))
{
return(true);
}
return(false);
}
public static bool CheckAccessSilent(string action)
{
BOUser current_user = AccountantPool.Instance.CurrentAccountant.User;
if (current_user.CheckAccess(action))
{
return(true);
}
return(false);
}
private BOUser Load(IDataReader reader)
{
BOUser obj = new BOUser();
obj.Id = NotNullDataReader.GetInt32(reader, "ID");
obj.Email = NotNullDataReader.GetString(reader, "EMAIL");
obj.Password = NotNullDataReader.GetString(reader, "CLAVE");
obj.Country = NotNullDataReader.GetString(reader, "COUNTRY");
return(obj);
}
public void UpdateUser(IDbConnection conexion, BOUser obj)
{
string sql = "UPDATE USER SET" +
" EMAIL='" + obj.Email + "'," +
" CLAVE='" + obj.Password + "'," +
" COUNTRY='" + obj.Country + "'" +
" WHERE ID='" + obj.Id + "'";
DataBase.ExecuteNonQuery(sql, conexion);
}
public void MapModelToBO()
{
var mapper = new BOLUserMapper();
ApiUserRequestModel model = new ApiUserRequestModel();
model.SetProperties("A", "A");
BOUser response = mapper.MapModelToBO(1, model);
response.Password.Should().Be("A");
response.Username.Should().Be("A");
}
private void btnCreateRole_Click(object sender, EventArgs e)
{
BOUser current_user = AccountantPool.Instance.CurrentAccountant.User;
AuthRole role = current_user.CreateAuthRole();
FrmAuthRole frm = new FrmAuthRole(role);
if (frm.ShowDialog() == DialogResult.OK)
{
ViewModel();
}
}
public void MapBOToModel()
{
var mapper = new BOLUserMapper();
BOUser bo = new BOUser();
bo.SetProperties(1, "A", "A");
ApiUserResponseModel response = mapper.MapBOToModel(bo);
response.Id.Should().Be(1);
response.Password.Should().Be("A");
response.Username.Should().Be("A");
}
private void btnDelUser_Click(object sender, EventArgs e)
{
int UserID;
if (WinFormUtil.DataGridView_GetSelectedID(dgvUsers, out UserID))
{
BOUser current_user = AccountantPool.Instance.CurrentAccountant.User;
current_user.DeleteAuthUser(UserID);
ViewModel();
}
}
public FrmAuthUser(ApplicationPresenter ap, BOUser model)
: base(ap)
{
InitializeComponent();
mModel = model;
mViewModel = new BOViewModel(model);
mViewModel.ErrorProvider = errorProvider;
BindViews();
RegisterEventHandlers();
}
public void IsValid_UserNameAndLastNameIsRequired()
{
UserService userService = new UserService();
BOUser objUser = new BOUser()
{
Name = " ", LastName = " "
};
var resp = userService.IsValid(objUser);
Assert.IsFalse(resp);
}
public void ShowAuthUser(BOUser model)
{
if (IsInvalid(mFrmUser))
{
mFrmUser = new FrmAuthUser(mApplicationController, model);
}
else
{
mFrmUser.Model = model;
mFrmUser.UpdateView();
}
SetCurrentDlg(mFrmUser);
}
public void MapEFToBO()
{
var mapper = new DALUserMapper();
User entity = new User();
entity.SetProperties(1, "A", "A");
BOUser response = mapper.MapEFToBO(entity);
response.Id.Should().Be(1);
response.Password.Should().Be("A");
response.Username.Should().Be("A");
}
public void MapBOToEF()
{
var mapper = new DALUserMapper();
var bo = new BOUser();
bo.SetProperties(1, "A", "A");
User response = mapper.MapBOToEF(bo);
response.Id.Should().Be(1);
response.Password.Should().Be("A");
response.Username.Should().Be("A");
}
public void MapBOToModelList()
{
var mapper = new BOLUserMapper();
BOUser bo = new BOUser();
bo.SetProperties(1, "A", DateTime.Parse("1/1/1987 12:00:00 AM"), "A", "A", "A", "A", "A", 1, "A", "A", "A", "A", "A");
List <ApiUserResponseModel> response = mapper.MapBOToModel(new List <BOUser>()
{
{ bo }
});
response.Count.Should().Be(1);
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
var user = new BOUser();
user.FirstName = txtFirstName.Text;
user.LastName = txtLastName.Text;
user.Age = drpAge.SelectedItem.Text;
user.Gender = drpGender.SelectedItem.Text;
//TODO
if (txtDateOfBirth.Text.Trim().Length > 0)
{
DateTime dob;
var isValid = DateTime.TryParse(txtDateOfBirth.Text.Trim(), out dob);
if (isValid)
user.DOB = dob.ToString();
}
user.ContactNo = txtContactNo.Text;
user.Qualification = Convert.ToInt32(drpQualification.SelectedValue);
user.Address = txtAddress.Text;
user.Basic = txtBasic.Text;
user.DA = txtDA.Text;
user.HRA = txtHRA.Text;
user.ProfTax = txtProfTax.Text;
user.ConvAllowance = txtConveyanceAllowance.Text;
user.CapitalCostAllow = txtCapitalCostAllowance.Text;
user.EnterAllowance = txtEntertainmentAllowance.Text;
user.NetSalary = txtNetSalary.Text;
user.Department = Convert.ToInt32(drpSelectDepartment.SelectedValue);
user.empid = txtEmpId.Text;
user.userid = txtUserId.Text;
user.password = txtCreatePassword.Text;
user.SeqQuestion = Convert.ToInt32(drpSecurityQuestion.SelectedValue);
user.Answer = txtAnswer.Text;
// TODO
if (txtDateOfJoin.Text.Trim().Length > 0)
{
DateTime doj;
var isValid = DateTime.TryParse(txtDateOfJoin.Text.Trim(), out doj);
if (isValid)
user.DateOfJoin = doj.ToString();
}
user.CreatedBy = 1;
user.ModifiedBy = 1;
user.CreatedDate = DateTime.Now.ToString();
var users = new BLCategories();
string id = string.Empty;
if (users.InsertUser(user, out id) == -1)
{
lblErrorMsg.ForeColor = System.Drawing.Color.Green;
lblErrorMsg.Text = "user created successfully.";
BindUsers();
ResetControls();
}
else
{
lblErrorMsg.ForeColor = System.Drawing.Color.Red;
lblErrorMsg.Text = "unable to save user";
}
}
catch (Exception)
{
}
}
public int InsertUser(BOUser user, out string id)
{
id = string.Empty;
SqlParameter[] sqlParams = new SqlParameter[28];
sqlParams[0] = new SqlParameter("@FirstName", user.FirstName);
sqlParams[1] = new SqlParameter("@LastName", user.LastName);
sqlParams[2] = new SqlParameter("@Age", user.Age);
sqlParams[3] = new SqlParameter("@Gender", user.Gender);
sqlParams[4] = new SqlParameter("@DOB", user.DOB);
sqlParams[5] = new SqlParameter("@ContactNo", user.ContactNo);
sqlParams[6] = new SqlParameter("@Qualification", user.Qualification);
sqlParams[7] = new SqlParameter("@Address", user.Address);
sqlParams[8] = new SqlParameter("@Basic", user.Basic);
sqlParams[9] = new SqlParameter("@DA", user.DA);
sqlParams[10] = new SqlParameter("@HRA", user.HRA);
sqlParams[11] = new SqlParameter("@ProfTax", user.ProfTax);
sqlParams[12] = new SqlParameter("@ConvAllowance", user.ConvAllowance);
sqlParams[13] = new SqlParameter("@CapitalCostAllow", user.CapitalCostAllow);
sqlParams[14] = new SqlParameter("@EnterAllowance", user.EnterAllowance);
sqlParams[15] = new SqlParameter("@NetSalary", user.NetSalary);
sqlParams[16] = new SqlParameter("@Department", user.Department);
sqlParams[17] = new SqlParameter("@empid", user.empid);
sqlParams[18] = new SqlParameter("@userid", user.userid);
sqlParams[19] = new SqlParameter("@password", user.password);
sqlParams[20] = new SqlParameter("@SeqQuestion", user.SeqQuestion);
sqlParams[21] = new SqlParameter("@Answer", user.Answer);
sqlParams[22] = new SqlParameter("@DateOfJoin", user.DateOfJoin);
sqlParams[23] = new SqlParameter("@CreatedBy", user.CreatedBy);
sqlParams[24] = new SqlParameter("@CreatedDate", user.CreatedDate);
sqlParams[25] = new SqlParameter("@ModifiedBy", user.ModifiedBy);
sqlParams[26] = new SqlParameter("@ModifiedDate", user.ModifiedDate);
sqlParams[27] = new SqlParameter("@RecordId", id);
return cmnDA.ExecuteNonQuery("pr_users_AddOrUpdate", sqlParams);
}
