public int UPDATEOTP(UserDetailsEntity Obj) { int OTP = 0; try { using (DbCommand objDbCommand = DBAccessHelper.GetDBCommand(ConnectionManager.DatabaseToConnect.RaiteRajuDefaultInstance, StoredProcedures.SPUPDATEOTP)) { DBAccessHelper.AddInputParametersWithValues(objDbCommand, DataAccessConstants.ParamPhoneNumber, DbType.String, Obj.BigIntPhoneNumber); DBAccessHelper.AddInputParametersWithValues(objDbCommand, DataAccessConstants.PARAMOTP, DbType.String, Obj.OTP); IDataReader dr = DBAccessHelper.ExecuteReader(objDbCommand); while (dr.Read()) { OTP = Convert.ToInt32(dr[DataAccessConstants.PARAMOTP]); } string URL = "https://2factor.in/API/V1/a2cbd769-9ef3-11e8-a895-0200cd936042/SMS/" + Obj.BigIntPhoneNumber + "/" + Obj.OTP + "/RaiteRajuOTP"; HttpWebRequest request = WebRequest.Create(URL) as HttpWebRequest; //optional HttpWebResponse response = request.GetResponse() as HttpWebResponse; Stream stream = response.GetResponseStream(); } } catch (Exception ex) { ExceptionLoggin("ManagementDal", "UPDATEOTP", ex.Message); } return(OTP); }
private static async Task SendNotificationAsync(UserDetailsEntity userData, Attachment card) { var conversationUrl = $"{userData.ServiceUrl}v3/conversations/{userData.ConversationId}/activities"; using (var requestMessage = new HttpRequestMessage(HttpMethod.Post, conversationUrl)) { requestMessage.Headers.Authorization = new AuthenticationHeaderValue( "Bearer", botAccessToken); var attachmentJsonString = JsonConvert.SerializeObject(card); var messageString = "{ \"type\": \"message\", \"attachments\": [ " + attachmentJsonString + " ], \"channelData\": { \"notification\": { \"alert\": true } } }"; requestMessage.Content = new StringContent(messageString, Encoding.UTF8, "application/json"); var httpClient = new HttpClient(); using (var sendResponse = await httpClient.SendAsync(requestMessage)) { if (sendResponse.StatusCode == HttpStatusCode.Created) { return; } if (sendResponse.StatusCode == HttpStatusCode.TooManyRequests) { var random = new Random(); await Task.Delay(random.Next(500, 1500)); } } } }
public IEnumerable <UserDetailsEntity> RetrieveEntities(UserDetailsEntity userDetailsEntity) { var query = new TableQuery <UserDetailsEntity>() .Where(TableQuery.GenerateFilterCondition("PartitionKey", QueryComparisons.Equal, userDetailsEntity.UserName.ToLower().Replace(" ", "-"))); return(_table.ExecuteQuery(query)); }
public UserDetailsEntity VerifyMobileNumber(UserDetailsEntity Obj) { UserDetailsEntity Entity = new UserDetailsEntity(); try { using (DbCommand objDbCommand = DBAccessHelper.GetDBCommand(ConnectionManager.DatabaseToConnect.RaiteRajuDefaultInstance, StoredProcedures.SPVERIFYMOBILENUMBER)) { DBAccessHelper.AddInputParametersWithValues(objDbCommand, DataAccessConstants.ParamPhoneNumber, DbType.String, Obj.BigIntPhoneNumber); DBAccessHelper.AddInputParametersWithValues(objDbCommand, DataAccessConstants.PARAMOTP, DbType.String, Obj.OTP); IDataReader dr = DBAccessHelper.ExecuteReader(objDbCommand); while (dr.Read()) { Entity.txtName = Convert.ToString(dr[DataAccessConstants.ParamtName]); Entity.intUserId = Convert.ToInt32(dr[DataAccessConstants.ParamUserId]); Entity.BigIntPhoneNumber = Convert.ToInt64(dr[DataAccessConstants.ParamPhoneNumber]); Entity.txtPassword = Convert.ToString(dr[DataAccessConstants.ParamPasswordd]); } } } catch (Exception ex) { ExceptionLoggin("ManagementDal", "VerifyMobileNumber", ex.Message); return(null); } return(Entity); }
public int UpdatePassword(UserDetailsEntity Obj) { int UserID = 0; try { using (DbCommand objDbCommand = DBAccessHelper.GetDBCommand(ConnectionManager.DatabaseToConnect.RaiteRajuDefaultInstance, StoredProcedures.SPUPDAGEUSERDETAILS)) { DBAccessHelper.AddInputParametersWithValues(objDbCommand, DataAccessConstants.ParamUserId, DbType.Int32, Obj.intUserId); DBAccessHelper.AddInputParametersWithValues(objDbCommand, DataAccessConstants.ParamPhoneNumber, DbType.Int64, Obj.BigIntPhoneNumber); IDataReader dr = DBAccessHelper.ExecuteReader(objDbCommand); while (dr.Read()) { UserID = Convert.ToInt32(dr[DataAccessConstants.ParamUserId]); } } } catch (Exception ex) { ExceptionLoggin("ManagementDal", "UpdatePassword", ex.Message); } return(UserID); }
protected override async Task OnMessageActivityAsync(ITurnContext <IMessageActivity> turnContext, CancellationToken cancellationToken) { if (turnContext.Activity.Text == "Add me") { var member = await TeamsInfo.GetMemberAsync(turnContext, turnContext.Activity.From.Id, cancellationToken); var user = new UserDetailsEntity() { Name = (member.Name).Split(" ")[0], //indsert proper name UserUniqueID = turnContext.Activity.From.Id, AadId = turnContext.Activity.From.AadObjectId, EmailId = member.Email, ProfilePictureURL = string.Empty, RowKey = Guid.NewGuid().ToString(), PartitionKey = PartitionKeyNames.UserDetailsDataTable.TableName }; await _userDetailsRepository.CreateOrUpdateAsync(user); var reply = MessageFactory.Text("Your data is recorded !"); await turnContext.SendActivityAsync(reply, cancellationToken); } else { var reply = MessageFactory.Text("Welcome to Task Manager, Try crating new Tasks using Messaging extension"); await turnContext.SendActivityAsync(reply, cancellationToken); } }
public async Task <TableResult> RetrieveEntityAsync(UserDetailsEntity userdetailsEntity) { var retrieveOperation = TableOperation.Retrieve <UserDetailsEntity>( userdetailsEntity.UserName.ToLower().Replace(" ", "-"), userdetailsEntity.StopWatchName.ToLower().Replace(" ", "-")); return(await _table.ExecuteAsync(retrieveOperation)); }
public static async Task <UserDetailsEntity> GetUserId(string userEmail, IConfiguration configuration) { UserDetailsRepository userDetailsDataRepository = new UserDetailsRepository(configuration); UserDetailsEntity manager = await userDetailsDataRepository.GeUserDetails(userEmail.ToLower()); return(manager ?? null); }
public int UpdateOtp(UserDetailsModel Obj) { ManagementObjectMapper objMapper = new ManagementObjectMapper(); UserDetailsEntity Entity = new UserDetailsEntity(); Entity = objMapper.MapUserRegistrationModelToUserRegistrationEntity(Obj); ServiceLayer.ManagementService ManObj = new ManagementService(); return(ManObj.UPDATEOTP(Entity)); }
public int InsertAddUserDetails(UserDetailsModel obj) { ManagementObjectMapper objMapper = new ManagementObjectMapper(); UserDetailsEntity Entity = new UserDetailsEntity(); Entity = objMapper.MapUserRegistrationModelToUserRegistrationEntity(obj); ServiceLayer.ManagementService ManObj = new ManagementService(); return(ManObj.InsertAddUserDetails(Entity)); }
public UserDetailsModel GetLoginCheck(Int64 PhoneNumber, string Password) { UserDetailsEntity EntityObj = new UserDetailsEntity(); UserDetailsModel ModelObj = new UserDetailsModel(); InformationObjectMapper ObjMapper = new InformationObjectMapper(); ServiceLayer.InformationService obj = new InformationService(); EntityObj = obj.GetLoginCheck(PhoneNumber, Password); ModelObj = ObjMapper.MapUserDetailsModelToEntity(EntityObj); return(ModelObj); }
public UserDetailsModel GetUserDetailsWithPassword(Int64 PhoneNumber, string Password) { UserDetailsModel DetModelObj = new UserDetailsModel(); UserDetailsEntity DetEntityObj = new UserDetailsEntity(); ServiceLayer.InformationService obj = new InformationService(); InformationObjectMapper ObjMapper = new InformationObjectMapper(); DetEntityObj = obj.GetUserDetailsWithPassword(PhoneNumber, Password); DetModelObj = ObjMapper.MapDetailsEntityToDetailsModel(DetEntityObj); return(DetModelObj); }
public UserDetailsModel GetUserDetailsWithOTP(Int32 OTP, Int64 PhoneNumber) { UserDetailsModel DetModelObj = new UserDetailsModel(); UserDetailsEntity DetEntityObj = new UserDetailsEntity(); ServiceLayer.InformationService obj = new InformationService(); InformationObjectMapper ObjMapper = new InformationObjectMapper(); DetEntityObj = obj.GetUserDetailsWithOTP(OTP, PhoneNumber); DetModelObj = ObjMapper.MapDetailsEntityToDetailsModel(DetEntityObj); return(DetModelObj); }
public UserDetailsModel AdminLoginCheck(Int64 PhoneNumber, string Password) { UserDetailsModel UserModel = new UserDetailsModel(); UserDetailsEntity UserEntity = new UserDetailsEntity(); ServiceLayer.InformationService obj = new InformationService(); InformationObjectMapper objmapper = new InformationObjectMapper(); UserEntity = obj.AdminLoginCheck(PhoneNumber, Password); UserModel = objmapper.MapUserDetailsModelToEntity(UserEntity); return(UserModel); }
public UserDetailsModel VerifyMobileNumber(int otp, Int64 MobileNumber) { ManagementObjectMapper objMapper = new ManagementObjectMapper(); UserDetailsEntity Entity = new UserDetailsEntity(); UserDetailsModel Model = new UserDetailsModel(); Entity.BigIntPhoneNumber = MobileNumber; Entity.OTP = otp.ToString(); ServiceLayer.ManagementService ManObj = new ManagementService(); Entity = ManObj.VerifyMobileNumber(Entity); Model = objMapper.MapUserDetailsModelToEntity(Entity); return(Model); }
internal UserDetailsModel MapUserDetailsModelToEntity(UserDetailsEntity Entity) { UserDetailsModel UserObj = new UserDetailsModel(); if (Entity != null) { UserObj.txtUserName = Entity.txtName; UserObj.intUserId = Entity.intUserId; UserObj.txtPhoneNumber = Entity.BigIntPhoneNumber; UserObj.ddlState = Entity.txtState; UserObj.ddlDistrict = Entity.txtDistrict; UserObj.ddlMandal = Entity.txtMandal; UserObj.txtVillage = Entity.txtvillage; UserObj.txtMailId = Entity.txtMailId; } return(UserObj); }
internal UserDetailsModel MapDetailsEntityToDetailsModel(UserDetailsEntity Entity) { //DetailsModel DetModelobj = new DetailsModel(); //UserDetailsModel UserObj = new UserDetailsModel(); //AdDetailsModel AdObj; //List<AdDetailsModel> adListObj = new List<AdDetailsModel>(); //List<AdDetailsEntity> AdEntityList = new List<AdDetailsEntity>(); UserDetailsModel UserObj = new UserDetailsModel(); if (Entity != null) { UserObj.txtUserName = Entity.txtName; UserObj.intUserId = Entity.intUserId; UserObj.txtPhoneNumber = Entity.BigIntPhoneNumber; UserObj.ddlState = Entity.txtState; UserObj.ddlDistrict = Entity.txtDistrict; UserObj.ddlMandal = Entity.txtMandal; UserObj.txtVillage = Entity.txtvillage; UserObj.txtMailId = Entity.txtMailId; //foreach (AdDetailsEntity item in Entity.AdDetails) //{ // AdObj = new AdDetailsModel(); // AdObj.AdID = item.AdID; // AdObj.txtAddTitle = item.Title; // AdObj.Category = item.Category; // AdObj.SubCategory = item.SubCategory; // AdObj.txtAdDescription = item.AdDescription; // AdObj.txtPrice = item.Price; // AdObj.txtQuantity = item.Quantity; // AdObj.SellingUnit = item.SellingUnit; // AdObj.Image = item.Image; // adListObj.Add(AdObj); //} //DetModelobj.AdDetails = adListObj; //DetModelobj.UserDetailsModel = UserObj; return(UserObj); } else { return(null); } }
public IActionResult PushUserDetails([FromBody] UserDetailsEntity userDetailsEntity) { if (!ModelState.IsValid) { return(new JsonResult(BadRequest(ModelState))); } else { try { UserDetails userDetails = new UserDetails(); return(new JsonResult(userDetails.pushUserDetails(userDetailsEntity))); } catch (Exception e) { return(new JsonResult(StatusCode(500, e.Message))); } } }
public async Task <List <UserDetailsModel> > RetrieveElaspedTime(UserDetailsEntity userDetailsEntity) { try { var entityList = new List <UserDetailsModel>(); if (!string.IsNullOrEmpty(userDetailsEntity.UserName) && !string.IsNullOrEmpty(userDetailsEntity.StopWatchName)) { var userEntity = await _azureService.RetrieveEntityAsync(userDetailsEntity); entityList.Add(new UserDetailsModel { UserName = ((UserDetailsEntity)userEntity.Result).UserName, StopWatchName = ((UserDetailsEntity)userEntity.Result).StopWatchName, Status = ((UserDetailsEntity)userEntity.Result).Status, ElapsedTime = _elapsedTime.CalculateElapsedTime(((UserDetailsEntity)userEntity.Result).StartTime, ((UserDetailsEntity)userEntity.Result).EndTime) }); } if (!string.IsNullOrEmpty(userDetailsEntity.StopWatchName)) { return(entityList); } var entities = _azureService.RetrieveEntities(userDetailsEntity); entityList.AddRange(entities.Select(x => new UserDetailsModel { UserName = x.UserName, StopWatchName = x.StopWatchName, Status = x.Status, ElapsedTime = _elapsedTime.CalculateElapsedTime(x.StartTime, x.EndTime) }).ToList()); return(entityList); } catch (Exception ex) { Console.Error.WriteLine(ex.Message); throw; } }
public int InsertAddUserDetails(UserDetailsEntity Obj) { int UserID = 0; try { using (DbCommand objDbCommand = DBAccessHelper.GetDBCommand(ConnectionManager.DatabaseToConnect.RaiteRajuDefaultInstance, StoredProcedures.SPINSERTUSERDETAILS)) { DBAccessHelper.AddInputParametersWithValues(objDbCommand, DataAccessConstants.ParamtName, DbType.String, Obj.txtName); DBAccessHelper.AddInputParametersWithValues(objDbCommand, DataAccessConstants.ParamPhoneNumber, DbType.Int64, Obj.BigIntPhoneNumber); DBAccessHelper.AddInputParametersWithValues(objDbCommand, DataAccessConstants.ParamState, DbType.String, Obj.txtState); DBAccessHelper.AddInputParametersWithValues(objDbCommand, DataAccessConstants.ParamDistrict, DbType.String, Obj.txtDistrict); DBAccessHelper.AddInputParametersWithValues(objDbCommand, DataAccessConstants.ParamMandal, DbType.String, Obj.txtMandal); DBAccessHelper.AddInputParametersWithValues(objDbCommand, DataAccessConstants.Paramvillage, DbType.String, Obj.txtvillage); // DBAccessHelper.AddInputParametersWithValues(objDbCommand, DataAccessConstants.ParamMailId, DbType.String, Obj.txtMailId); DBAccessHelper.AddInputParametersWithValues(objDbCommand, DataAccessConstants.ParamPasswordd, DbType.String, Obj.txtPassword); DBAccessHelper.AddInputParametersWithValues(objDbCommand, DataAccessConstants.PARAMOTP, DbType.Int32, Obj.OTP); IDataReader dr = DBAccessHelper.ExecuteReader(objDbCommand); while (dr.Read()) { UserID = Convert.ToInt32(dr[DataAccessConstants.ParamUserId]); } if (Obj.KeyForUserSettings != "ADMIN") { string URL = "https://2factor.in/API/V1/a2cbd769-9ef3-11e8-a895-0200cd936042/SMS/" + Obj.BigIntPhoneNumber + "/" + Obj.OTP + "/RaiteRajuOTP"; HttpWebRequest request = WebRequest.Create(URL) as HttpWebRequest; //optional HttpWebResponse response = request.GetResponse() as HttpWebResponse; Stream stream = response.GetResponseStream(); } } return(UserID); } catch (Exception ex) { ExceptionLoggin("ManagementDal", "InsertAddUserDetails", ex.Message); return(0); } }
internal UserDetailsEntity MapUserRegistrationModelToUserRegistrationEntity(UserDetailsModel Model) { UserDetailsEntity Entity = new UserDetailsEntity(); Entity.intUserId = Model.intUserId; Entity.KeyForUserSettings = Model.KeyForUserSettings; Entity.txtName = Model.txtUserName; Entity.BigIntPhoneNumber = Model.txtPhoneNumber; Entity.txtMailId = Model.txtMailId; Entity.txtState = Model.ddlState; Entity.txtDistrict = Model.ddlDistrict; Entity.txtMandal = Model.ddlMandal; Entity.txtvillage = Model.txtVillage; Entity.txtPassword = Model.txtPassword; Random r = new Random(); string OTP = r.Next(100000, 999999).ToString(); Entity.OTP = OTP; return(Entity); }
public UserDetailsEntity VerifyMobileNumber(UserDetailsEntity Obj) { DAL.ManagementDAL OBJ = new DAL.ManagementDAL(); return(OBJ.VerifyMobileNumber(Obj)); }
public int UPDATEOTP(UserDetailsEntity Obj) { ManagementBusinessLayerInterface ManageObj = new BusinessLayer.ManagementBusinessLayer(); return(ManageObj.UPDATEOTP(Obj)); }
public async Task <List <UserDetailsModel> > RetrieveElapsedTime(UserDetailsEntity userDetails) { return(await _stopwatchDetails.RetrieveElaspedTime(userDetails)); }
public ResponseEntity pushUserDetails(UserDetailsEntity userDetailsEntity) { try { ResponseEntity responseEntity = new ResponseEntity(); var command = dBContext.Connection.CreateCommand() as SqlCommand; command.CommandType = CommandType.StoredProcedure; command.CommandText = "dbo.prcUpSertUserDetails"; command.Parameters.Add(new SqlParameter { ParameterName = "@UID", DbType = DbType.String, Value = userDetailsEntity.UserId, }); command.Parameters.Add(new SqlParameter { ParameterName = "@FNAME", DbType = DbType.String, Value = userDetailsEntity.FirstName, }); command.Parameters.Add(new SqlParameter { ParameterName = "@MNAME", DbType = DbType.String, Value = userDetailsEntity.MiddleName, }); command.Parameters.Add(new SqlParameter { ParameterName = "@LNAME", DbType = DbType.String, Value = userDetailsEntity.LastName, }); command.Parameters.Add(new SqlParameter { ParameterName = "@GENDER", DbType = DbType.String, Value = userDetailsEntity.Gender, }); command.Parameters.Add(new SqlParameter { ParameterName = "@MAIL", DbType = DbType.String, Value = userDetailsEntity.PersonalMailAddress, }); List <IDictionary <String, Object> > result = dBContext.GetDatabaseResultSet(command); if (result != null) { var config = new MapperConfiguration(cfg => { cfg.CreateMap <IDictionary <String, Object>, List <DBResultEnity> >(); }).CreateMapper(); List <DBResultEnity> dBResult = config.Map <List <DBResultEnity> >(result); DBResultEnity dBResultEnity = dBResult.FirstOrDefault(); responseEntity.StatusCode = dBResultEnity.STATUSCODE; responseEntity.StatusMessage = dBResultEnity.STATUSDESC; return(responseEntity); } else { responseEntity.StatusCode = 0; responseEntity.StatusMessage = "Failed"; return(responseEntity); } } catch (Exception e) { throw e; } }
public int InsertAddUserDetails(UserDetailsEntity Obj) { return(new DAL.ManagementDAL().InsertAddUserDetails(Obj)); }
public static async Task SendNotificationAsync(IConfiguration configuration, Attachment attachment, UserDetailsEntity userDetailsEntity) { await FetchTokenAsync(configuration); var createConversationUrl = $"{userDetailsEntity.ServiceUrl}v3/conversations"; using (var requestMessage = new HttpRequestMessage(HttpMethod.Post, createConversationUrl)) { requestMessage.Headers.Authorization = new AuthenticationHeaderValue( "Bearer", botAccessToken); var payloadString = "{\"bot\": { \"id\": \"28:" + configuration["MicrosoftAppId"] + "\"},\"isGroup\": false, \"tenantId\": \"" + userDetailsEntity.TenantId + "\", \"members\": [{\"id\": \"" + userDetailsEntity.UserUniqueID + "\"}]}"; requestMessage.Content = new StringContent(payloadString, Encoding.UTF8, "application/json"); var httpClient = new HttpClient(); using (var sendResponse = await httpClient.SendAsync(requestMessage)) { if (sendResponse.StatusCode == HttpStatusCode.Created) { var jsonResponseString = await sendResponse.Content.ReadAsStringAsync(); dynamic resp = JsonConvert.DeserializeObject(jsonResponseString); if (string.IsNullOrEmpty(userDetailsEntity.ConversationId)) { userDetailsEntity.ConversationId = resp.id; } await SendNotificationAsync(userDetailsEntity, attachment); var operation = TableOperation.InsertOrMerge(userDetailsEntity); if (userDataRepository == null) { userDataRepository = new UserDetailsRepository(configuration); } await userDataRepository.Table.ExecuteAsync(operation); } } } }
public UserDetailsEntity VerifyMobileNumber(UserDetailsEntity Obj) { ManagementBusinessLayerInterface ManageObj = new BusinessLayer.ManagementBusinessLayer(); return(ManageObj.VerifyMobileNumber(Obj)); }
public int UpdateUserDetails(UserDetailsEntity Obj) { DAL.ManagementDAL OBJ = new DAL.ManagementDAL(); return(OBJ.UpdateUserDetails(Obj)); }
public int UPDATEOTP(UserDetailsEntity Obj) { DAL.ManagementDAL OBJ = new DAL.ManagementDAL(); return(OBJ.UPDATEOTP(Obj)); }