public DataSet Login_Usermaster(Usermaster _obj)
{
try
{
_cn.Open();
SqlCommand _cmd = new SqlCommand("sp_tbl_user_master", _cn);
_cmd.Parameters.AddWithValue("@User_Name", _obj.User_Name);
_cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter _adp = new SqlDataAdapter(_cmd);
_cmd.CommandTimeout = 300;
DataSet _ds = new DataSet();
_adp.Fill(_ds);
_adp.Dispose();
_cmd.Dispose();
return(_ds);
}
catch (Exception)
{
throw;
}
finally
{
_cn.Close();
}
}
public JsonResult CheckLogin(Usermaster _obj)
{
bool flagLogin = false;
bool flagCaptcha = false;
bool flagValidID = false;
UserRepository _objRepository = new UserRepository();
DataSet ds = _objRepository.Login_Usermaster(_obj);
try
{
if (this.Session["CaptchaImageText"].ToString() == _obj.Captchastr)
{
flagCaptcha = true;
if (ds != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
flagValidID = true;
DataRow dr = ds.Tables[0].Rows[0];
if (dr["Password"].ToString() == _obj.Password)
{
string localIPadmin = "?";
localIPadmin = Request.ServerVariables["REMOTE_ADDR"].ToString();
Session["localIPADmin"] = localIPadmin;
Session["is_callCentre"] = dr["is_callCentre"].ToString();
Session["User_id"] = dr["User_id"];
Session["User_Name"] = dr["User_Name"];
Session["Name"] = dr["Name"].ToString();
Session["is_admin"] = dr["is_admin"].ToString();
Session["AdminRole"] = dr["AdminRole"].ToString();
Session["is_doc_verification"] = dr["is_doc_verification"].ToString();
string localIP = "?";
localIP = Request.ServerVariables["REMOTE_ADDR"].ToString();
Session["localIP"] = localIP;
flagLogin = true;
}
}
}
}
else
{
flagCaptcha = false;
}
}
catch (Exception)
{
throw;
}
return(Json(new
{
flagLogin = flagLogin,
flagValidID = flagValidID,
flagCaptcha = flagCaptcha
},
JsonRequestBehavior.AllowGet
));
}
public ActionResult Create(CreateNewUserViewModel createUserViewModel)
{
try
{
if (ModelState.IsValid)
{
if (_iUserMaster.CheckEmailIdExists(createUserViewModel.EmailId))
{
TempData["MessageCreateUsersErrors"] = "EmailId Already Exists";
}
else if (_iUserMaster.CheckMobileNoExists(createUserViewModel.MobileNo))
{
TempData["MessageCreateUsersErrors"] = "MobileNo Already Exists";
}
else
{
string username = GenerateUserName(createUserViewModel);
Usermaster usermaster = new Usermaster();
usermaster.Status = true;
usermaster.CreateDate = DateTime.Now;
usermaster.UserId = 0;
usermaster.FirstName = createUserViewModel.FirstName;
usermaster.LastName = createUserViewModel.LastName;
usermaster.EmailId = createUserViewModel.EmailId;
usermaster.MobileNo = createUserViewModel.MobileNo;
usermaster.UserName = username;
usermaster.CreatedBy = Convert.ToInt32(_sessionHandler.UserId);
usermaster.Gender = createUserViewModel.Gender;
var salt = GenerateRandomNumbers.RandomNumbers(20);
var password = GeneratePassword(createUserViewModel, salt);
var userId = _iUserMaster.AddUser(usermaster, password, salt, Convert.ToInt16(StatusMain.Roles.User));
if (userId != -1)
{
TempData["MessageCreateUsers"] = $"User Created Successfully Username :- {usermaster.UserName}";
}
return(RedirectToAction("Create", "CreateNewUser"));
}
return(View("Create", createUserViewModel));
}
else
{
return(View("Create", createUserViewModel));
}
}
catch
{
throw;
}
}
public void DeleteUser(int?userId)
{
try
{
Usermaster usermaster = _context.Usermasters.Find(userId);
if (usermaster != null)
{
_context.Usermasters.Remove(usermaster);
}
_context.SaveChanges();
}
catch (Exception)
{
throw;
}
}
public ActionResult Login(LoginModel Model)
{
if (ModelState.IsValid)
{
Usermaster user = _user.DoLogin(Model.Username, Model.Password);
if (user != null)
{
TempData["UserId"] = user.UserId;
AddLoginCookie(user.UserId, user.Name, user.UserName, user.Role, "Token");
// Using for new registration
var registrationDetails = _registrationRepository.FindBy(x => x.UserId == user.UserId).FirstOrDefault();
if (registrationDetails != null && user.Role == (int)Roles.Admin && user.Status == (int)Status.Active)
{
return(RedirectToAction("Index", "Dashboard", new { area = "Admin" }));
}
else if (registrationDetails != null && user.Role == (int)Roles.Distributor && user.Status == (int)Status.Active)
{
return(RedirectToAction("Index", "Account"));
}
else if (registrationDetails != null && user.Role == (int)Roles.Retrailer && user.Status == (int)Status.Active)
{
return(RedirectToAction("Index", "Account"));
}
else if (registrationDetails != null && user.Status == (int)Status.InActive)
{
return(RedirectToAction("RequestForApproving", "Account"));
}
else if (registrationDetails == null && user.Status == (int)Status.Created)
{
return(RedirectToAction("CreateRegistration", "Account"));
}
else
{
return(RedirectToAction("CreateRegistration", "Account"));
}
}
else
{
ViewBag.Message = "The Username Or Password you enterd is invalid";
}
}
return(View());
}
private bool IsCategogryAssigned(Usermaster usermasterModel, SavedAssignedRolesViewModel rolesModel)
{
if (rolesModel.RoleId == Convert.ToInt32(StatusMain.Roles.Agent) && _agentCheckInStatus.CheckIsCategoryAssignedtoAgent(usermasterModel.UserId))
{
return(true);
}
if (rolesModel.RoleId == Convert.ToInt32(StatusMain.Roles.AgentAdmin) && _iUserMaster.CheckIsCategogryAssignedtoAgentAdmin(usermasterModel.UserId))
{
return(true);
}
if (rolesModel.RoleId == Convert.ToInt32(StatusMain.Roles.Hod) && _iUserMaster.CheckIsCategogryAssignedtoHod(usermasterModel.UserId))
{
return(true);
}
return(false);
}
public long?UpdateUser(Usermaster usermaster)
{
try
{
long?result = -1;
if (usermaster != null)
{
usermaster.CreateDate = DateTime.Now;
_context.Entry(usermaster).State = EntityState.Modified;
_context.SaveChanges();
result = usermaster.UserId;
}
return(result);
}
catch (Exception)
{
throw;
}
}
public ActionResult RedirectionManager(Usermaster usermasterModel, SavedAssignedRolesViewModel rolesModel)
{
if (rolesModel.RoleId == Convert.ToInt32(StatusMain.Roles.SuperAdmin))
{
return(RedirectToAction("Dashboard", "SuperDashboard"));
}
if (rolesModel.RoleId == Convert.ToInt32(StatusMain.Roles.User))
{
return(RedirectToAction("Dashboard", "UserDashboard"));
}
if (rolesModel.RoleId == Convert.ToInt32(StatusMain.Roles.Admin))
{
return(RedirectToAction("Dashboard", "AdminDashboard"));
}
if (rolesModel.RoleId == Convert.ToInt32(StatusMain.Roles.AgentAdmin))
{
return(RedirectToAction("Dashboard", "AgentAdminDashboard"));
}
if (rolesModel.RoleId == Convert.ToInt32(StatusMain.Roles.Hod))
{
return(RedirectToAction("Dashboard", "HODDashboard"));
}
if (rolesModel.RoleId == Convert.ToInt32(StatusMain.Roles.Agent))
{
if (_agentCheckInStatus.CheckIsalreadyCheckedIn(usermasterModel.UserId))
{
return(RedirectToAction("Dashboard", "AgentDashboard"));
}
else
{
return(RedirectToAction("Alerts", "CheckInAlert"));
}
}
return(RedirectToAction("Login", "Login"));
}
public long?AddUser(Usermaster usermaster)
{
try
{
long?result = -1;
if (usermaster != null)
{
usermaster.Status = true;
usermaster.CreateDate = DateTime.Now;
_context.Usermasters.Add(usermaster);
_context.SaveChanges();
result = usermaster.UserId;
}
return(result);
}
catch (Exception)
{
throw;
}
}
private void AssignSessionValues(Usermaster usermasterModel, SavedAssignedRolesViewModel rolesModel)
{
var sessionHandler = new SessionHandler
{
UserId = Convert.ToString(usermasterModel.UserId),
UserName = usermasterModel.FirstName + " " + usermasterModel.LastName,
EmailId = usermasterModel.EmailId,
RoleId = Convert.ToString(rolesModel.RoleId),
RoleName = Convert.ToString(rolesModel.RoleName),
CacheProfileKey = "Cache_" + usermasterModel.UserId
};
if (rolesModel.RoleId == Convert.ToInt32(StatusMain.Roles.AgentAdmin))
{
sessionHandler.AgentAdminCategoryId = Convert.ToString(_category.GetAdminCategory(usermasterModel.UserId));
}
if (rolesModel.RoleId == Convert.ToInt32(StatusMain.Roles.Hod))
{
sessionHandler.HodCategoryId = Convert.ToString(_category.GetHodCategory(usermasterModel.UserId));
}
var result = _iProfile.IsProfileImageExists(Convert.ToInt64(sessionHandler.UserId));
if (result)
{
string cacheProfileKey = Convert.ToString(sessionHandler.CacheProfileKey);
if (!CacheHelper.CheckExists(cacheProfileKey))
{
var imageBase64String = _iProfile.GetProfileImageBase64String(Convert.ToInt64(sessionHandler.UserId));
var tempimageBase64String = string.Concat("data:image/png;base64,", imageBase64String);
CacheHelper.AddToCacheWithNoExpiration(cacheProfileKey, tempimageBase64String);
}
}
}
public HttpResponseMessage CreateRegistration(RegistrationModel registrationModel)
{
ResponseModel _response = new ResponseModel();
var _getUser = _userMaster.FindBy(x => x.UserId == registrationModel.UserId).FirstOrDefault();
if (_getUser == null)
{
_response.Type = "error";
_response.Message = "User not Exist";
return(Request.CreateResponse(HttpStatusCode.OK, _response));
}
var _getDetail = _registrationRepository.FindBy(x => x.UserId == registrationModel.UserId).FirstOrDefault();
if (_getDetail != null)
{
_response.Type = "error";
_response.Message = "Profile already Created";
return(Request.CreateResponse(HttpStatusCode.OK, _response));
}
var model = Mapper.Map <RegistrationModel, Registration>(registrationModel);
model.CreatedDate = DateTime.Now;
model.CreatedBy = registrationModel.CreatedBy;
model.Status = (int)Status.InActive;
model.IsDeleted = false;
var Result = _registrationRepository.CreateUserProfile(model);
if (Result != null)
{
// Update UserMaster Status for Inactive
Usermaster _details = _userMaster.FindBy(x => x.UserId == Result.UserId).FirstOrDefault();
if (_details != null)
{
_details.Status = (int)Status.InActive;
_userMaster.Update(_details);
_userMaster.SaveChanges();
}
// For Uploading Licence image ----
foreach (var item in registrationModel.lstDocLicence)
{
if (item != null)
{
UploadDocumentModel UploadDocument = new UploadDocumentModel();
UploadDocument.documents = new List <DocumentModel>();
UploadDocument.ImageSize = 250;
UploadDocument.ImageQuality = 250;
UploadDocument.documents.Add(item);
List <string> uploadedFileName = SavePicture(UploadDocument);
if (uploadedFileName.Count > 0)
{
LicenceImages licenceImages = new LicenceImages();
licenceImages.ImagePath = uploadedFileName[0].ToString();
licenceImages.RegistrationId = Result.RegistrationId;
licenceImages.IsActive = true;
_licenceImagesReposiory.Add(licenceImages);
_licenceImagesReposiory.SaveChanges();
}
}
}
// For Uploading image ----
if (registrationModel.DocGSTNo != null)
{
UploadDocumentModel UploadDocumentGSTNo = new UploadDocumentModel();
UploadDocumentGSTNo.documents = new List <DocumentModel>();
UploadDocumentGSTNo.ImageSize = 250;
UploadDocumentGSTNo.ImageQuality = 250;
UploadDocumentGSTNo.documents.Add(registrationModel.DocGSTNo);
List <string> uploadedFileName = SavePicture(UploadDocumentGSTNo);
if (uploadedFileName.Count > 0)
{
Registration _registration = _registrationRepository.FindBy(x => x.RegistrationId == Result.RegistrationId).FirstOrDefault();
if (_registration != null)
{
_registration.GSTNoImage = uploadedFileName[0].ToString();
_registrationRepository.Update(_registration);
_registrationRepository.SaveChanges();
}
}
}
_response.Type = "success";
_response.Message = "Profile created successfully";
return(Request.CreateResponse(HttpStatusCode.OK, _response));
}
else
{
_response.Type = "error";
_response.Message = "somehing went wrong";
return(Request.CreateResponse(HttpStatusCode.OK, _response));
}
}
public IEnumerable <DocumentModel> SearchDocuments(SearchModel searchModel)
{
string result = "load";
IEnumerable <DocumentModel> documents = null;
Usermaster resultObjUM = null;
string username, password;
(username, password) = SecurityHelper.GetCredentials(User.Identity as ClaimsIdentity);
try
{
using (var client = new HttpClient())
{
try
{
string uri = ConfigurationManager.AppSettings["GetEPFMSettings"] + "?Username="******"N" ? resultObjUM.EpfmUsername : username;
password = resultObjUM.Isaduser == "N" ? resultObjUM.EpfmPassword : password;
Logger.WriteLog(JsonConvert.SerializeObject(resultObjUM));
}
else
{
new Exception("ERCMS Core API failed" + httpresult.ReasonPhrase);
}
}
catch (Exception ex)
{
Logger.WriteLog("ERCMS Core API failed " + ex.Message + Environment.NewLine + ex.StackTrace);
throw ex;
}
}
//string username, password;
//(username, password) = SecurityHelper.GetCredentials(User.Identity as ClaimsIdentity);
String repository = ConfigurationManager.AppSettings["EPFMRepository"];
//String username = ConfigurationManager.AppSettings["EPFMUsername"];
//String password = ConfigurationManager.AppSettings["EPFMPassword"];
String address = ConfigurationManager.AppSettings["EPFMAddress"];
Logger.WriteLog("SearchDocuments Log details " + username + Environment.NewLine + password + Environment.NewLine + address);
SearchServiceDemo searchServiceDemo = new SearchServiceDemo(repository, null, username, password, address);
Logger.WriteLog("SearchDocuments searchServiceDemo " + searchServiceDemo.ToString());
documents = searchServiceDemo.SimplePassthroughQueryDocumentWithPath_New(searchModel);
}
catch (Exception ex)
{
result = result + "Got exception" + ex.StackTrace;
Logger.WriteLog("SearchDocuments searchServiceDemo " + result);
throw new Exception(result);
}
return(documents);
}
public IHttpActionResult DownloadDocument(DownloadContextDTO Dto)
{
string result = "";
try
{
Usermaster resultObjUM = null;
string username, password;
(username, password) = SecurityHelper.GetCredentials(User.Identity as ClaimsIdentity);
using (var client = new HttpClient())
{
try
{
string uri = ConfigurationManager.AppSettings["GetEPFMSettings"] + "?Username="******"N" ? resultObjUM.EpfmUsername : username;
password = resultObjUM.Isaduser == "N" ? resultObjUM.EpfmPassword : password;
Logger.WriteLog(JsonConvert.SerializeObject(resultObjUM));
}
else
{
new Exception("ERCMS Core API failed" + httpresult.ReasonPhrase);
}
}
catch (Exception ex)
{
Logger.WriteLog("ERCMS Core API failed " + ex.Message + Environment.NewLine + ex.StackTrace);
throw ex;
}
}
String repository = ConfigurationManager.AppSettings["EPFMRepository"];
//String username = ConfigurationManager.AppSettings["EPFMUsername"];
//String password = ConfigurationManager.AppSettings["EPFMPassword"];
String address = ConfigurationManager.AppSettings["EPFMAddress"];
ObjectServiceDemo objectService = new ObjectServiceDemo(repository, null, username, password, address);
//string object_id = "090181cd80054c37";
ObjectIdentity objIdentity =
new ObjectIdentity(new Qualification("dm_document where r_object_id = '" + Dto.object_id + "'"),
repository);
FileInfo fileInfo = null;
try
{
fileInfo = objectService.GetWithContent(objIdentity, "Pleasanton", Emc.Documentum.FS.DataModel.Core.Content.ContentTransferMode.MTOM, Dto.object_id);
}
catch (Exception ex)
{
}
if (fileInfo == null)
{
string TemplateFilePath = ConfigurationManager.AppSettings["TemplateFilePath"];
string Fullpath = Path.Combine(TemplateFilePath, Dto.SaveFilename);
StreamWriter sw = new StreamWriter(Fullpath, false);
sw.WriteLine("This is a sample file created at " + DateTime.Now);
sw.Close();
fileInfo = new FileInfo(Fullpath);
}
MoveEPFMResultWrapper resultObj = null;
//
using (var client = new HttpClient())
{
try
{
string uri = ConfigurationManager.AppSettings["CoreMoveEPFMUri"] + "?RidType=" + Dto.RidType + "&category=" +
Dto.category + "&Tmpfilename=" + fileInfo.FullName + "&SaveFilename=" + Dto.SaveFilename + "&attachsequence=" + Dto.attachsequence + "&objectid=" + Dto.object_id + "&attachmentguid=" + Dto.attachmentguid;
client.DefaultRequestHeaders.Authorization = ActionContext.Request.Headers.Authorization;
var responseTask = client.GetAsync(uri);
responseTask.Wait();
var httpresult = responseTask.Result;
if (httpresult.IsSuccessStatusCode)
{
//var readTask = result.Content.ReadAsAsync<IList<StudentViewModel>>();
var readTask = httpresult.Content.ReadAsAsync <MoveEPFMResultWrapper>();
readTask.Wait();
resultObj = readTask.Result;
Logger.WriteLog(JsonConvert.SerializeObject(resultObj));
}
else
{
new Exception("ERCMS Core API failed" + httpresult.ReasonPhrase);
}
}
catch (Exception ex)
{
Logger.WriteLog("ERCMS Core API failed " + ex.Message + Environment.NewLine + ex.StackTrace);
throw ex;
}
}
return(Content(HttpStatusCode.OK, resultObj));
}
catch (Exception ex)
{
result = result + "Got exception" + ex.StackTrace;
return(Ok(ex.Message));
}
}
