public async Task <IActionResult> ContactUs(UserContactInfo model)
{
if (ModelState.IsValid)
{
var message = new EmailMessage(new string[] { model.UserEmail }, "Thanks for your query at BEYONCETECH", string.Format("Hi {0},\n Thanks for showing interests at BEYONCETECH. \n\n Our team member will get back to you shortly. ", model.UserName), true, null);
await _EmailSender.SendEmailAsync(message);
string LastError = _EmailSender.GetLastError();
if (string.IsNullOrEmpty(LastError))
{
message = new EmailMessage(new string[] { "*****@*****.**", "*****@*****.**", "*****@*****.**" }, string.Format("[{0}] Query at BEYONCETECH - {1}", model.UserName, model.Subject), string.Format("Hi, \n User Message: \n {0} \n User Email: \n {1}", model.Description, model.UserEmail), true, null);
await _EmailSender.SendEmailAsync(message);
return(Json(new { Stat = true, Msg = "Successfully send your query" }));
}
else
{
return(Json(new { Stat = false, Msg = LastError }));
}
}
else
{
return(Json(new { Stat = false, Msg = "Data is Not Valid" }));
}
}
public ActionResult Create(UserContactInfo ObjUserContactInfo)
{
System.Text.StringBuilder sb = new System.Text.StringBuilder();
try
{
if (ModelState.IsValid)
{
db.UserContactInfos.Add(ObjUserContactInfo);
db.SaveChanges();
sb.Append("Sumitted");
return(Content(sb.ToString()));
}
else
{
foreach (var key in this.ViewData.ModelState.Keys)
{
foreach (var err in this.ViewData.ModelState[key].Errors)
{
sb.Append(err.ErrorMessage + "<br/>");
}
}
}
}
catch (Exception ex)
{
sb.Append("Error :" + ex.Message);
}
return(Content(sb.ToString()));
}
private void Process(UserAccountEvent evt, object extra = null)
{
evt.AppInfo = Settings.Information;
evt.Urls = Settings.Urls;
var contact = new UserContactInfo().InjectFrom(evt.Account) as UserContactInfo;
Send(contact, NotificationTypes.AccountCreated);
}
public WorkOrderModel(int id, DateTime createdDate, DateTime?completedDate, UserContactInfo worker, WorkOrderStatusModel status, WorkOrderClientModel client, int totalPrice, IEnumerable <WorkModel> works) : base(id)
{
CreatedDate = createdDate;
CompletedDate = completedDate;
Worker = worker;
Status = status;
Client = client;
TotalPrice = totalPrice;
Works = works;
}
public DeliveryRequestModel(int id, int carId, int?supplierId, UserContactInfo manager, UserContactInfo supplierManager, DeliveryRequestStatusModel status, int amount, DateTime createDate, DateTime?completedDate) : base(id)
{
CarId = carId;
SupplierId = supplierId;
Manager = manager;
SupplierManager = supplierManager;
Status = status;
Amount = amount;
CreateDate = createDate;
CompletedDate = completedDate;
}
public static bool GetUserContactInfo(List <UserContactInfo> userContactInfoCollector)
{
try
{
if (userContactInfoCollector == null)
{
throw new ArgumentNullException(nameof(userContactInfoCollector));
}
string sqlConnectionString = Environment.GetEnvironmentVariable("SqlConnectionString", EnvironmentVariableTarget.Process);
if (!String.IsNullOrEmpty(sqlConnectionString))
{
using (SqlConnection connection = new SqlConnection(sqlConnectionString))
{
connection.Open();
using (SqlCommand cmd = new SqlCommand("GetAllUsersContactInfo", connection))
{
cmd.CommandType = CommandType.StoredProcedure;
using (SqlDataReader reader = cmd.ExecuteReader())
{
if (reader != null)
{
while (reader.Read())
{
UserContactInfo userContactInfo = new UserContactInfo();
userContactInfo.UserId = reader["UserId"].ToString();
userContactInfo.FullName = reader["FullName"].ToString();
userContactInfo.EmailAddress = reader["EmailAddress"].ToString();
userContactInfo.MobilePhone = reader["MobileNumber"].ToString();
userContactInfoCollector.Add(userContactInfo);
}
return(true);
}
return(false);
}
}
}
}
string errorMsg = "Error: SQL Connection Parameters not found in Configuration";
throw new ArgumentNullException(errorMsg);
}
catch (SqlException sqlEx)
{
throw new Exception(sqlEx.Message);
}
catch (ArgumentNullException argNullEx)
{
throw new ArgumentNullException(argNullEx.Message);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public ActionResult ContactInfo(UserModel model, string Salutation)
{
model.Info.Salutation = Salutation;
usercont = model.Contact;
user = model.Info;
if (user.Salutation != "" && user.FirstName != null && user.LastName != null && user.Company != null && user.Title != null &&
usercont.Email != null && usercont.ConfirmEmail != null && usercont.Phone != null)
{
return(Redirect("/Register/Areas"));
}
return(View(model));
}
public OrderModel(int id, int carId, int managerId, UserContactInfo manager, int clientId, OrderStatusModel status, int?deliveryRequestId, DateTime createDate, DateTime?completedDate, bool canPromote) : base(id)
{
CarId = carId;
ManagerId = managerId;
Manager = manager;
ClientId = clientId;
Status = status;
DeliveryRequestId = deliveryRequestId;
CreateDate = createDate;
CompletedDate = completedDate;
CanPromote = canPromote;
}
// GET: /UserContactInfo/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
UserContactInfo ObjUserContactInfo = db.UserContactInfos.Find(id);
if (ObjUserContactInfo == null)
{
return(HttpNotFound());
}
return(View(ObjUserContactInfo));
}
// GET: /UserContactInfo/MultiViewIndex/5
public ActionResult MultiViewIndex(int?id)
{
UserContactInfo ObjUserContactInfo = db.UserContactInfos.Find(id);
ViewBag.IsWorking = 0;
if (id > 0)
{
ViewBag.IsWorking = id;
ViewBag.ContactTypeId = new SelectList(db.ContactTypes, "Id", "TypeName", ObjUserContactInfo.ContactTypeId);
ViewBag.UserId = new SelectList(db.Users, "Id", "Username", ObjUserContactInfo.UserId);
}
return(View(ObjUserContactInfo));
}
//[Authorize]
//[ValidateAntiForgeryToken]
//[Route("ModifyInfo")]
public async Task <ActionResult <UserContactInfo> > ModifyInfo(int id, [FromBody] UserContactInfoModel userContactInfoModel)
{
//var result = new Result<string>();
var result = new Result <UserContactInfo>();
var user = await _context.UserContactInfo.Where(x => x.UserId == id).FirstOrDefaultAsync();
var updateSubscribe = await _context.User.FirstAsync(x => x.Id == id);
if (user == null)
{
UserContactInfo userContactInfo = new UserContactInfo();
_mapper.Map(userContactInfoModel, userContactInfo);
await _context.UserContactInfo.AddAsync(userContactInfo);
}
else
{
user.FirstName = userContactInfoModel.FirstName;
user.LastName = userContactInfoModel.LastName;
user.PhoneNumber = userContactInfoModel.PhoneNumber;
user.Company = userContactInfoModel.Company;
user.Comments = userContactInfoModel.Comments;
user.Website = userContactInfoModel.Website;
user.SocialMedia = userContactInfoModel.SocialMedia;
user.Nzbn = userContactInfoModel.Nzbn;
user.BusinessInfo = userContactInfoModel.BusinessInfo;
_context.UserContactInfo.Update(user);
}
updateSubscribe.IsSubscribe = userContactInfoModel.IsSubscribe;
updateSubscribe.Discount = userContactInfoModel.Discount;
_context.User.Update(updateSubscribe);
try
{
await UserSubscribe(userContactInfoModel);
_context.SaveChanges();
result.Data = user;
}
catch (Exception ex)
{
result.IsSuccess = false;
result.ErrorMessage = ex.ToString();
return(BadRequest(result));
}
result.IsSuccess = true;
return(Ok(result));
}
public static UserContactInfo GetSingleUserContactInfo(String UserId)
{
try
{
string sqlConnectionString = Environment.GetEnvironmentVariable("SqlConnectionString", EnvironmentVariableTarget.Process);
if (!String.IsNullOrEmpty(sqlConnectionString))
{
using (SqlConnection connection = new SqlConnection(sqlConnectionString))
{
connection.Open();
using (SqlCommand cmd = new SqlCommand("GetSingleUserContactInfo", connection))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@UserId", SqlDbType.VarChar).Value = UserId;
using (SqlDataReader reader = cmd.ExecuteReader())
{
if (reader != null)
{
while (reader.Read())
{
UserContactInfo userContactInfo = new UserContactInfo();
userContactInfo.UserId = reader["UserId"].ToString();
userContactInfo.FullName = reader["FullName"].ToString();
userContactInfo.EmailAddress = reader["EmailAddress"].ToString();
userContactInfo.MobilePhone = reader["MobileNumber"].ToString();
return(userContactInfo);
}
}
}
}
}
}
string errorMsg = "Error: SQL Connection Parameters not found in Configuration";
throw new ArgumentNullException(errorMsg);
}
catch (SqlException sqlEx)
{
throw new Exception(sqlEx.Message);
}
catch (ArgumentNullException argNullEx)
{
throw new ArgumentNullException(argNullEx.Message);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
// GET: /UserContactInfo/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
UserContactInfo ObjUserContactInfo = db.UserContactInfos.Find(id);
if (ObjUserContactInfo == null)
{
return(HttpNotFound());
}
ViewBag.ContactTypeId = new SelectList(db.ContactTypes, "Id", "TypeName", ObjUserContactInfo.ContactTypeId);
ViewBag.UserId = new SelectList(db.Users, "Id", "Username", ObjUserContactInfo.UserId);
return(View(ObjUserContactInfo));
}
public async Task <IActionResult> Register([FromBody] UserModel userModel)
{
var result = new Result <Object>();
var user = _context.User.FirstOrDefault(x => x.Email == userModel.Email);
if (user != null)
{
result.IsSuccess = false;
result.ErrorMessage = "This email has been registered.";
return(BadRequest(result));
}
User newUser = new User();
userModel.CreatedOn = DateTime.Now;
_mapper.Map(userModel, newUser);
newUser.Password = HashPassword(userModel.Password);
try
{
await UserSubscribe(userModel);
}
catch (Exception ex)
{
result.IsSuccess = false;
result.ErrorMessage = userModel.Email + " looks fake or invalid";
return(BadRequest(result));
}
await _context.User.AddAsync(newUser);
UserContactInfo userContactInfo = new UserContactInfo();
userContactInfo.UserId = newUser.Id;
await _context.UserContactInfo.AddAsync(userContactInfo);
await _context.SaveChangesAsync();
var tokenString = GenerateJwt(newUser.Id);
result.Data = new JsonResult {
userId = newUser.Id, email = newUser.Email, token = tokenString
};
SendRegisterEmail(userModel);
//result.Data = newUser;
return(Ok(result));
}
public ActionResult DeleteConfirmed(int id)
{
System.Text.StringBuilder sb = new System.Text.StringBuilder();
try
{
UserContactInfo ObjUserContactInfo = db.UserContactInfos.Find(id);
db.UserContactInfos.Remove(ObjUserContactInfo);
db.SaveChanges();
sb.Append("Sumitted");
return(Content(sb.ToString()));
}
catch (Exception ex)
{
sb.Append("Error :" + ex.Message);
}
return(Content(sb.ToString()));
}
public static bool GetUserContactInfo(List <UserContactInfo> userContactInfoCollector)
{
try
{
if (userContactInfoCollector == null)
{
throw new ArgumentNullException(nameof(userContactInfoCollector));
}
var sqlConnectionString = Environment.GetEnvironmentVariable("SqlConnectionString", EnvironmentVariableTarget.Process);
using (SqlConnection connection = new SqlConnection(sqlConnectionString))
{
connection.Open();
string spName = @"dbo.[GetAllUsersContactInfo]";
using (SqlCommand cmd = new SqlCommand(spName, connection))
{
cmd.CommandType = CommandType.StoredProcedure;
using (SqlDataReader reader = cmd.ExecuteReader())
{
if (reader != null)
{
while (reader.Read())
{
UserContactInfo userContactInfo = new UserContactInfo();
userContactInfo.UserId = reader["UserId"].ToString();
userContactInfo.FullName = reader["FullName"].ToString();
userContactInfo.EmailAddress = reader["EmailAddress"].ToString();
userContactInfo.MobilePhone = reader["MobileNumber"].ToString();
userContactInfoCollector.Add(userContactInfo);
}
return(true);
}
return(false);
}
}
}
}
catch (Exception ex)
{
throw new Exception(ex.ToString());
}
}
protected virtual void Send(UserContactInfo userFrom, NotificationTypes?type,
object model = null, object data = null)
{
if (!type.HasValue)
{
return;
}
var note = new Notification
{
UserId = userFrom.UserId,
Type = type.GetValueOrDefault()
};
var result = _notificationService.Repository.Insert(note);
Event?.Invoke(this, new NotificationEvent
{
Data = result,
UserId = UserId,
Username = userFrom.Username
});
}
public static async Task <IActionResult> Run(
[HttpTrigger(AuthorizationLevel.Function, "post", Route = null)] HttpRequestMessage req,
ILogger log)
{
try
{
if (req == null)
{
return(new BadRequestObjectResult("Error: Request object missing"));
}
SymptomsInfo symptomsInfo = await req.Content.ReadAsAsync <SymptomsInfo>().ConfigureAwait(false);
if (checkEmptyOrNull(symptomsInfo))
{
return(new BadRequestObjectResult("Error: Incorrect payload"));
}
bool dataRecorded = DbHelper.PostDataAsync(symptomsInfo, Constants.postSymptomsInfo);
if (dataRecorded)
{
string SrcEmail = Environment.GetEnvironmentVariable("SrcEmail", EnvironmentVariableTarget.Process);
string AuthorName = Environment.GetEnvironmentVariable("AuthorName", EnvironmentVariableTarget.Process);
string SendGridAPIKey = Environment.GetEnvironmentVariable("SendGridAPIKey", EnvironmentVariableTarget.Process);
if (!String.IsNullOrEmpty(SrcEmail) && !String.IsNullOrEmpty(AuthorName) && !String.IsNullOrEmpty(SendGridAPIKey))
{
UserContactInfo userContactInfo = DbHelper.GetSingleUserContactInfo(symptomsInfo.UserId.ToString());
string DestEmail = userContactInfo.EmailAddress.ToString();
string RecipientName = userContactInfo.FullName.ToString();
bool isClearToWork = symptomsInfo.ClearToWorkToday;
string recordGUID = "";
string imageBase64Encoding = "";
if (isClearToWork == true)
{
recordGUID = Guid.NewGuid().ToString();
symptomsInfo.GUID = recordGUID;
imageBase64Encoding = NotificationHelper.GenerateQRCode(recordGUID);
}
string DateOfEntry = symptomsInfo.DateOfEntry.ToString();
NotificationHelper.SendSummaryEmailWithQRCode(DestEmail, SrcEmail, AuthorName, RecipientName, isClearToWork, symptomsInfo, imageBase64Encoding, SendGridAPIKey, DateOfEntry);
}
return(new OkObjectResult("Status: OK"));
}
else
{
return(new BadRequestObjectResult("Error: Writing to database did not complete"));
}
}
catch (HttpRequestException httpEx)
{
log.LogInformation(httpEx.Message);
return(new BadRequestObjectResult("Error: Incorrect Request"));
}
catch (ArgumentNullException argNullEx)
{
log.LogInformation(argNullEx.Message);
return(new BadRequestObjectResult("Error: Writing to database did not complete. One or more configuration parameters for SendGrid are missing."));
}
catch (Newtonsoft.Json.JsonSerializationException serializeEx)
{
log.LogInformation(serializeEx.Message);
return(new BadRequestObjectResult("Error: Incorrect payload"));
}
catch (SqlException sqlEx)
{
log.LogInformation(sqlEx.Message);
return(new BadRequestObjectResult("Error: Writing to database did not complete"));
}
catch (Exception ex)
{
log.LogInformation(ex.Message);
return(new BadRequestObjectResult("Error: Something went wrong, could not save your details"));
}
}
