/// <summary>
/// Single USer From Database
/// <para>Use it when delete data through a stored procedure</para>
/// </summary>
public vmUser GetUserByID(int?id, int?CompanyID, int?LoggedUser)
{
vmUser objUser = null;
try
{
if ((id > 0) && (CompanyID > 0))
{
using (GenericFactoryFor_User = new vmUser_GF())
{
Hashtable ht = new Hashtable();
ht.Add("CompanyID", CompanyID);
ht.Add("LoggedUser", LoggedUser);
ht.Add("UserID", id);
string spQuery = "[Get_CmnUserByID]";
objUser = GenericFactoryFor_User.ExecuteQuerySingle(spQuery, ht);
}
}
}
catch (Exception e)
{
e.ToString();
}
return(objUser);
}
public async Task <HttpResponseMessage> SaveUser(object[] data)//vmUser model)
{
vmUser model = JsonConvert.DeserializeObject <vmUser>(data[0].ToString());
List <vmCompany> companylist = JsonConvert.DeserializeObject <List <vmCompany> >(data[1].ToString());
int result = 0; int emailResult = 0; vmUser objUser = null;
try
{
if (model != null)
{
//result = objUserService.SaveUser(model);
objUser = objUserService.SaveUser(model, companylist);
if (objUser != null)
{
result = Convert.ToInt32(objUser.ReturnValue);
if (result == 1)
{
emailResult = await objMailService.UserRegistration(objUser);
}
}
}
}
catch (Exception e)
{
e.ToString();
result = -0;
}
return(Request.CreateResponse(HttpStatusCode.OK, result));
}
public ActionResult Edit(vmUser getuser, FormCollection collection)
{
try
{
var edituser = new Models.UserInfo();
edituser = iuser.GetUser(getuser.UserId);
getuser.Divitions = idv.GetKVP();
getuser.Districts = idis.GetKVP(0);
edituser.FristName = getuser.FristName;
edituser.LastName = getuser.LastName;
edituser.UserName = getuser.UserName;
edituser.Email = getuser.Email;
edituser.Mobile = getuser.Mobile;
edituser.GenderId = getuser.GenderId;
edituser.DivitionId = getuser.DivitionId;
edituser.DistrictId = getuser.DistrictId;
edituser.LastEducationalQulification = getuser.LastEducationalQulification;
edituser.Occupation = getuser.Occupation;
edituser.PresentAddress = getuser.PresentAddress;
edituser.DateOFBirth = getuser.DateOFBirth;
iuser.UpdateUser(edituser);
return(RedirectToAction("Index"));
}
catch (Exception e)
{
return(View(getuser));
}
}
public IActionResult UserProfile(vmUser objuser, ICollection <IFormFile> files)
{
if (HttpContext.Request.Form.Files != null)
{
}
return(View());
}
public async Task <object> Save([FromBody] vmUser model)
{
object result = null;
string message = "";
if (model == null)
{
return(BadRequest());
}
using (_ctx)
{
using (var _ctxTransaction = _ctx.Database.BeginTransaction())
{
try
{
if (model.id > 0)
{
var entityUpdate = _ctx.User.FirstOrDefault(c => c.Id == model.id);
if (entityUpdate != null)
{
entityUpdate.FirstName = model.firstName;
entityUpdate.LastName = model.lastName;
entityUpdate.Email = model.email;
entityUpdate.Phone = model.phone;
await _ctx.SaveChangesAsync();
}
}
else
{
var UserModel = new User
{
FirstName = model.firstName,
LastName = model.lastName,
Email = model.email,
Phone = model.phone
};
_ctx.User.Add(UserModel);
await _ctx.SaveChangesAsync();
}
_ctxTransaction.Commit();
message = "Saved Successfully";
}
catch (Exception ex)
{
_ctxTransaction.Rollback();
ex.ToString();
message = "Error !!!";
}
result = new
{
message
};
}
}
return(result);
}
// GET: User/Create
public ActionResult Create()
{
var user = new vmUser();
// var item = idv.GetKVP();
user.Divitions = idv.GetKVP();
user.Districts = idis.GetKVP(0);
return(View(user));
}
// [HttpPost("[action]")]
public IActionResult Authenticate([FromBody] vmUser userParam)
{
// var user = _userService.Authenticate(userParam["username"].ToString(), userParam["password"].ToString());
var user = _userService.Authenticate(userParam.UserName, userParam.Password);
if (user == null)
{
return(Unauthorized());
}
// return BadRequest(new { message = "Username or password is incorrect" });
return(Ok(user));
}
public async Task <int> UserRegistration(vmUser model)
{
int result = 0;
//string sender = "*****@*****.**";
string sender = "*****@*****.**";
string receiver = model.LoginEmail;
MailMessage Msg = new MailMessage();
try
{
Msg.From = new MailAddress(sender);
Msg.To.Add(receiver);
StreamReader reader = new StreamReader(HttpContext.Current.Server.MapPath("~/EmailTemplate/UserRegistration.html"));
string readFile = reader.ReadToEnd();
string StrContent = "";
StrContent = readFile;
StrContent = StrContent.Replace("[UserID]", model.UserID.ToString());
StrContent = StrContent.Replace("[LoginID]", model.LoginID);
StrContent = StrContent.Replace("[LoginEmail]", model.LoginEmail);
StrContent = StrContent.Replace("[Password]", model.Password);
StrContent = StrContent.Replace("[RequestedIP]", model.RequestedIP);
StrContent = StrContent.Replace("[CompanyName]", model.CompanyName);
Msg.Subject = model.CompanyName + " - Account Details";
Msg.Body = StrContent.ToString();
Msg.IsBodyHtml = true;
using (var smtp = new SmtpClient())
{
var credential = new NetworkCredential
{
UserName = "******",
Password = "******"
};
smtp.Credentials = credential;
smtp.Host = "mail.amber.com.bd";
smtp.Port = 25;
smtp.EnableSsl = false;
await smtp.SendMailAsync(Msg);
result = 1;
}
}
catch (Exception ex)
{
ex.ToString();
result = 0;
}
return(result);
}
public IActionResult Me()
{
vmUser ret = new vmUser();
try
{
var service = Provider.GetService <IUserApplication>();
ret = service.Me(login);
return(Ok(ret));
}
catch (Exception ex)
{
return(BadRequest(ex));
}
}
public IActionResult SignUp(vmUser user)
{
try
{
var service = Provider.GetService <IUserApplication>();
service.SignUp(user);
return(Ok());
}
catch (ArgumentException ex)
{
vmError erro = new vmError();
erro.errorCode = Convert.ToInt32(ex.ParamName);
erro.message = ex.Message;
return(BadRequest(erro));
}
}
public HttpResponseMessage GetUserByID(int?id, int?companyID, int?loggedUser)
{
vmUser objUser = null;
try
{
if (id != null)
{
objUser = objUserService.GetUserByID(id, companyID, loggedUser);
}
}
catch (Exception e)
{
e.ToString();
}
return(Request.CreateResponse(HttpStatusCode.OK, objUser));
}
public void DeleteSignature(vmUser _vUser)
{
string fileName = _vUser.SignatUrl.ToString();
try
{
var directory = @"E:/Upload/Signature/";
string filePath = directory + fileName;
if (fileName != null)
{
System.IO.File.Delete(filePath);
}
}
catch (Exception ex)
{
ex.ToString();
}
}
public vmUser Authenticate(string username, string password)
{
vmUser _user = new vmUser();
var user = db.SecUsers.SingleOrDefault(x => x.UserName == username && x.Password == password);
// return null if user not found
if (user == null)
{
return(null);
}
// JWT Implementation
var ClaimData = new[] { new Claim(ClaimTypes.Name, username), new Claim(ClaimTypes.Role, "admin") };
var _key = new SymmetricSecurityKey(Encoding.ASCII.GetBytes(_appSettings.Secret));
var SignInCred = new SigningCredentials(_key, SecurityAlgorithms.HmacSha256Signature);
var _token = new JwtSecurityToken(
issuer: "localhost:5001",
audience: "localhost:5001",
expires: DateTime.Now.AddMinutes(5),
claims: ClaimData,
signingCredentials: SignInCred
);
var Token = new JwtSecurityTokenHandler().WriteToken(_token);
user.Token = Token; // tokenHandler.WriteToken(token);
user.TokenExpireOn = DateTime.Now.AddMinutes(5);
db.SecUsers.Update(user);
db.SaveChanges();
user.Password = null;
MappingProperty.Map(_user, user);
var userRoles = db.SecUserRoles.Where(x => x.SecUserId == user.SecUserId).Select(x => x.SecRoleId).ToList();
var userRolePermissions = db.SecRolePermissions.Where(x => userRoles.Contains(x.SecRoleId)).Select(x => x.SecPermissionId).ToList();
var userPermissions = db.SecPermissions.Where(x => userRolePermissions.Contains(x.SecPermissionId)).ToList();
_user.permissions = userPermissions;
_user.RoleName = db.SecRoles.Where(x => x.SecRoleId == userRoles[0]).FirstOrDefault().RoleName;
return(_user);
}
public async Task <IActionResult> GetUsers([FromBody] vmUser userParam)
{
List <SecUsers> users = new List <SecUsers>();
try
{
users = await _userService.GetUsers(userParam);
if (users == null)
{
return(NotFound());
}
return(Ok(users));
}
catch (Exception ex)
{
Console.WriteLine("Some Error Acquired: ", ex.StackTrace);
}
return(BadRequest());
}
public async Task <List <SecUsers> > GetUsers(vmUser criteria)
{
if (db != null)
{
try
{
if (criteria.Status != null)
{
criteria.Status = int.Parse(criteria.Status.ToString());
}
Expression <Func <SecUsers, bool> > userName = res => res.UserName == criteria.UserName;
Expression <Func <SecUsers, bool> > status = res => res.Status == criteria.Status;
Expression <Func <SecUsers, bool> > createdBy = res => res.CreatedBy == criteria.CreatedBy;
IQueryable <SecUsers> filter = db.SecUsers;
if (!String.IsNullOrEmpty(criteria.UserName) && criteria.UserName != null)
{
filter = filter.Where(userName);
}
if (criteria.Status != null && criteria.Status != -1)
{
filter = filter.Where(status);
}
if (criteria.CreatedBy != null && criteria.CreatedBy != -1)
{
filter = filter.Where(createdBy);
}
return(await filter.ToListAsync());
}
catch (Exception ex) {
Console.WriteLine("Some Error Acquired" + ex.StackTrace);
}
}
return(null);
}
private static UserDomain ConvertToModelView(vmUser v)
{
UserDomain userDomain = new UserDomain();
PhoneDomain phoneDomain;
userDomain.firstName = v.firstName;
userDomain.lastName = v.lastName;
userDomain.email = v.email;
userDomain.password = v.password;
userDomain.id = userDomain.email;
foreach (var item in v.phones)
{
phoneDomain = new PhoneDomain();
phoneDomain.number = item.number;
phoneDomain.area_code = item.area_code;
phoneDomain.country_code = item.country_code;
phoneDomain.id = item.number.ToString() + item.area_code.ToString() + item.country_code;
userDomain.phones.Add(phoneDomain);
}
return(userDomain);
}
private static vmUser ConvertToViewModel(UserDomain d)
{
vmUser vmUser = new vmUser();
vmPhone vmPhone;
vmUser.firstName = d.firstName;
vmUser.lastName = d.lastName;
vmUser.email = d.email;
vmUser.password = d.password;
foreach (var item in d.phones)
{
vmPhone = new vmPhone();
vmPhone.number = item.number;
vmPhone.area_code = item.area_code;
vmPhone.country_code = item.country_code;
vmUser.phones.Add(vmPhone);
}
vmUser.token = d.token;
vmUser.create_ate = d.create_ate;
vmUser.last_login = d.last_login;
return(vmUser);
}
// GET: User/Edit/5
public ActionResult Edit(int id)
{
var getuser = iuser.GetUser(id);
var edituser = new vmUser();
edituser.Divitions = idv.GetKVP();
edituser.Districts = idis.GetKVP(getuser.DivitionId);
edituser.UserId = id;
edituser.FristName = getuser.FristName;
edituser.LastName = getuser.LastName;
edituser.UserName = getuser.UserName;
edituser.Email = getuser.Email;
edituser.Mobile = getuser.Mobile;
edituser.GenderId = getuser.GenderId;
edituser.DivitionId = getuser.DivitionId;
edituser.DistrictId = getuser.DistrictId;
edituser.LastEducationalQulification = getuser.LastEducationalQulification;
edituser.Occupation = getuser.Occupation;
edituser.PresentAddress = getuser.PresentAddress;
edituser.DateOFBirth = getuser.DateOFBirth;
return(View(edituser));
}
public void SignUp(vmUser user)
{
var domain = GetService <ISignUpDomain>();
domain.Execute(ConvertToModelView(user));
}
/// <summary>
/// Save Data To Database
/// <para>Use it when save data through a stored procedure</para>
/// </summary>
public vmUser SaveUser(vmUser model, List <vmCompany> companyList)
{
vmUser result = null;
try
{
if (model != null && model.UserGroupID > 0)
{
Hashtable ht = new Hashtable();
ht.Add("CompanyID", model.CompanyID);
ht.Add("LoggedUser", model.LoggedUser);
//Login Account
ht.Add("LoginID", model.LoginID ?? null);
ht.Add("Email", model.LoginEmail);
ht.Add("Phone", model.LoginPhone ?? null);
//User Type
ht.Add("UserTypeID", model.UserTypeID);
ht.Add("UserGroupID", model.UserGroupID);
ht.Add("UserTitleID", model.UserTitleID);
//User Info
ht.Add("UserFirstName", model.UserFirstName ?? null);
ht.Add("UserMiddleName", model.UserMiddleName ?? null);
ht.Add("UserLastName", model.UserLastName ?? null);
ht.Add("GenderID", model.GenderID);
ht.Add("ReligionID", model.ReligionID);
ht.Add("FathersName", model.FathersName ?? null);
ht.Add("MothersName", model.MothersName ?? null);
ht.Add("SpouseNane", model.SpouseNane ?? null);
//User Parmanent Address
ht.Add("ParAddress1", model.ParAddress1 ?? "");
ht.Add("ParAddress2", model.ParAddress2 ?? "");
ht.Add("ParCountryID", model.ParCountryID);
ht.Add("ParStateID", model.ParStateID);
ht.Add("ParCityID", model.ParCityID);
//User Present Address
ht.Add("PreAddress1", model.PreAddress1 ?? "");
ht.Add("PreAddress2", model.PreAddress2 ?? "");
ht.Add("PreCountryID", model.PreCountryID);
ht.Add("PreStateID", model.PreStateID);
ht.Add("PreCityID", model.PreCityID);
//User Identity
ht.Add("UniqueIdentity", model.UniqueIdentity);
ht.Add("BloodGroup", model.BloodGroup ?? "");
ht.Add("Height", model.Height);
ht.Add("DOB", model.DOB);
ht.Add("PassportNO", model.PassportNO);
ht.Add("NID", model.NID);
ht.Add("ImageUrl", model.ImageUrl ?? "");
ht.Add("FingerUrl", model.FingerUrl ?? "");
ht.Add("SignatureUrl", model.SignatUrl ?? "");
//Open User Login Account
ht.Add("IsOnlineAccount", model.IsOnlineAccount);
//User Job Contract
ht.Add("DesignationID", model.DesignationID);
ht.Add("DepartmentID", model.DepartmentID);
ht.Add("JobContractTypeID", model.JobContractTypeID);
//for CmnACCIntegration
ht.Add("AcDetailID", model.AcDetailID);
if (model.UserID > 0)
{
using (GenericFactoryFor_User = new vmUser_GF())
{
ht.Add("UserID", model.UserID);
string spQuery = "[Put_CmnUser]";
result = GenericFactoryFor_User.ExecuteCommandSingle(spQuery, ht);
if (result != null && companyList.Count > 0)
{
UpdateUserWiseCompany(model.UserID ?? 0, model.LoggedUser, companyList);
}
}
}
else
{
using (GenericFactoryFor_User = new vmUser_GF())
{
string spQuery = "[Set_CmnUser]";
result = GenericFactoryFor_User.ExecuteCommandSingle(spQuery, ht);
}
if (result != null && companyList.Count > 0)
{
SaveUserWiseCompany(result.UserID ?? 0, model.LoggedUser, companyList);
}
}
}
}
catch (Exception e)
{
e.ToString();
}
return(result);
}
