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