public HttpResponseMessage addUserBranches(Models.MstUserBranch userBranch) { try { var userId = (from d in db.MstUsers where d.UserId == User.Identity.GetUserId() select d.Id).SingleOrDefault(); Data.MstUserBranch newUserBranch = new Data.MstUserBranch(); newUserBranch.UserId = userBranch.UserId; newUserBranch.BranchId = userBranch.BranchId; db.MstUserBranches.InsertOnSubmit(newUserBranch); db.SubmitChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } catch { return(Request.CreateResponse(HttpStatusCode.InternalServerError)); } }
public async Task <ActionResult> Register(RegisterViewModel model) { var response = HttpContext.Request.Form["g-recaptcha-response"]; string secretKey = "6LfCXGcUAAAAAGG5ZPamj8Da5mqaoO0DIye1fUgv"; var client = new System.Net.WebClient(); var verificationResultJson = client.DownloadString(string.Format("https://www.google.com/recaptcha/api/siteverify?secret={0}&response={1}", secretKey, response)); var verificationResult = JsonConvert.DeserializeObject <CaptchaVerificationResult>(verificationResultJson); if (!verificationResult.Success) { ModelState.AddModelError("CaptiaError", "Invalid recaptcha challenge."); } else { if (ModelState.IsValid) { var user = new ApplicationUser { UserName = model.UserName, FullName = model.FullName, }; // var user = new ApplicationUser { UserName = model.Email, Email = model.Email }; var result = await UserManager.CreateAsync(user, model.Password); if (result.Succeeded) { await SignInManager.SignInAsync(user, isPersistent : false, rememberBrowser : false); // For more information on how to enable account confirmation and password reset please visit http://go.microsoft.com/fwlink/?LinkID=320771 // Send an email with this link // string code = await UserManager.GenerateEmailConfirmationTokenAsync(user.Id); // var callbackUrl = Url.Action("ConfirmEmail", "Account", new { userId = user.Id, code = code }, protocol: Request.Url.Scheme); // await UserManager.SendEmailAsync(user.Id, "Confirm your account", "Please confirm your account by clicking <a href=\"" + callbackUrl + "\">here</a>"); Data.easyfisdbDataContext db = new Data.easyfisdbDataContext(); var company = from d in db.MstCompanies select d; var companyId = company.FirstOrDefault().Id; var branch = from d in db.MstBranches where d.CompanyId == companyId select d; var branchId = branch.FirstOrDefault().Id; var account = from d in db.MstAccounts select d; var incomeAccountId = account.FirstOrDefault().Id; var supplierAdvancesAccountId = account.FirstOrDefault().Id; var customerAdvancesAccountId = account.FirstOrDefault().Id; var discount = from d in db.MstDiscounts select d; var discountId = discount.FirstOrDefault().Id; var officialReceiptName = "Official Receipt"; var inventoryType = "Moving Average"; var defaultSalesInvoiceDiscountId = discountId; var salesInvoiceName = "Sales Invoice"; Int32?salesInvoiceCheckedById = null; Int32?salesInvoiceApprovedById = null; var adminUser = from d in db.MstUsers where d.UserName.Equals("admin") select d; if (adminUser.Any()) { companyId = adminUser.FirstOrDefault().CompanyId; branchId = adminUser.FirstOrDefault().BranchId; incomeAccountId = adminUser.FirstOrDefault().IncomeAccountId; customerAdvancesAccountId = adminUser.FirstOrDefault().CustomerAdvancesAccountId; defaultSalesInvoiceDiscountId = adminUser.FirstOrDefault().DefaultSalesInvoiceDiscountId; salesInvoiceCheckedById = adminUser.FirstOrDefault().SalesInvoiceCheckedById; salesInvoiceApprovedById = adminUser.FirstOrDefault().SalesInvoiceApprovedById; } // ====================== // Create Registered User // ====================== Data.MstUser newMstUser = new Data.MstUser { UserId = user.Id, UserName = model.UserName, Password = model.Password, FullName = model.FullName, CompanyId = companyId, BranchId = branchId, IncomeAccountId = incomeAccountId, SupplierAdvancesAccountId = supplierAdvancesAccountId, CustomerAdvancesAccountId = customerAdvancesAccountId, InventoryType = inventoryType, DefaultSalesInvoiceDiscountId = defaultSalesInvoiceDiscountId, SalesInvoiceName = salesInvoiceName, SalesInvoiceCheckedById = salesInvoiceCheckedById, SalesInvoiceApprovedById = salesInvoiceApprovedById, OfficialReceiptName = officialReceiptName, IsIncludeCostStockReports = false, IsLocked = false, CreatedById = null, CreatedDateTime = DateTime.Now, UpdatedById = null, UpdatedDateTime = DateTime.Now }; db.MstUsers.InsertOnSubmit(newMstUser); db.SubmitChanges(); // ========================== // Current Registered User Id // ========================== var currentRegisteredUserId = newMstUser.Id; // ====================== // Update Registered User // ====================== var mstUsersData = from d in db.MstUsers where d.Id == currentRegisteredUserId select d; if (mstUsersData.Any()) { var updateMstUsersData = mstUsersData.FirstOrDefault(); updateMstUsersData.CreatedById = currentRegisteredUserId; updateMstUsersData.CreatedDateTime = DateTime.Now; updateMstUsersData.UpdatedById = currentRegisteredUserId; updateMstUsersData.UpdatedDateTime = DateTime.Now; db.SubmitChanges(); } // ============================= // Create Registered User Branch // ============================= Data.MstUserBranch newUserBranch = new Data.MstUserBranch { UserId = newMstUser.Id, BranchId = branchId }; db.MstUserBranches.InsertOnSubmit(newUserBranch); db.SubmitChanges(); return(RedirectToAction("Register", "Account")); } AddErrors(result); } } // If we got this far, something failed, redisplay form return(View(model)); }
public HttpResponseMessage AddUserBranch(Entities.MstUserBranch objUserBranch, String userId) { try { var currentUser = from d in db.MstUsers where d.UserId == User.Identity.GetUserId() select d; if (currentUser.Any()) { var currentUserId = currentUser.FirstOrDefault().Id; var userBranches = from d in db.MstUserForms where d.UserId == currentUserId && d.SysForm.FormName.Equals("UserDetail") select d; if (userBranches.Any()) { if (userBranches.FirstOrDefault().CanAdd) { var user = from d in db.MstUsers where d.Id == Convert.ToInt32(userId) select d; if (user.Any()) { if (!user.FirstOrDefault().IsLocked) { Data.MstUserBranch newUserBranch = new Data.MstUserBranch { UserId = Convert.ToInt32(userId), BranchId = objUserBranch.BranchId }; db.MstUserBranches.InsertOnSubmit(newUserBranch); db.SubmitChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, "You cannot add new user branch if the current user detail is locked.")); } } else { return(Request.CreateResponse(HttpStatusCode.NotFound, "These current user details are not found in the server. Please add new user first before proceeding.")); } } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. You have no rights to add user branch.")); } } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. You have no access for this user page.")); } } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, "Theres no current user logged in.")); } } catch (Exception e) { Debug.WriteLine(e); return(Request.CreateResponse(HttpStatusCode.InternalServerError, "Something's went wrong from the server.")); } }
public async Task <ActionResult> Register(RegisterViewModel model) { var response = HttpContext.Request.Form["g-recaptcha-response"]; string host = Request.Url.Host; string secretKey = ""; if (host.Equals("www.easyfis.com")) { secretKey = "6LeNBiMTAAAAAMZUdKMa_Q4_XRGLjOEjpVP96fge"; } if (host.Equals("innosoft.easyfis.com")) { secretKey = "6Ld-ACwUAAAAAN7eIeyjRupqGMTVIL-0QEtG1UXJ"; } if (host.Equals("abomar.easyfis.com")) { secretKey = "6Ld8JSwUAAAAAMNxLO4HigrdcgE_s9puaasKjp6A"; } if (host.Equals("tambayan.easyfis.com")) { secretKey = "6LcdCS0UAAAAANH_YY__9RYKl8tzpHYehdF5cdNK"; } if (host.Equals("cmm.easyfis.com")) { secretKey = "6LfVdi8UAAAAAHqj_Zllw3MEqDBKuXXxSm5RP2as"; } if (host.Equals("ncf.easyfis.com")) { secretKey = "6LeExTEUAAAAAPbP1FwdQyGr9AtIX4APY8AfzbKj"; } if (host.Equals("3abuilders.easyfis.com")) { secretKey = "6LchYDcUAAAAAHVlDaP6IhDd2YTyEnoSRdaojT25"; } if (host.Equals("mahb.easyfis.com")) { secretKey = "6Lf0bTgUAAAAANSW0EH2a8tX7JnjBxWgTTcTcD6i"; } if (host.Equals("htp.easyfis.com")) { secretKey = "6LcgEzoUAAAAAPlkDMxtBA-57Ar-E3pYfbtLskDI"; } if (host.Equals("myetp.easyfis.com")) { secretKey = "6LfGaz0UAAAAAB-dUsAmGqdtsMxQgoJfPggymmhP"; } if (host.Equals("greenware.easyfis.com")) { secretKey = "6LfHv0AUAAAAAASIFWnsD9ZdkN3f-bNWQ7XMGLPJ"; } if (host.Equals("arterra.easyfis.com")) { secretKey = "6LezWEQUAAAAAAn52pEfyFxPWnAcAOPgMGbBFw5D"; } if (host.Equals("kemique.easyfis.com")) { secretKey = "6LcdzEoUAAAAAGuQY0kfg4HdZlbuA2FkDKFy8hAp"; } if (host.Equals("racal.easyfis.com")) { secretKey = "6LffX0sUAAAAAKsLTyxgzo8Fuqsk1WRb4gx3iWnr"; } if (host.Equals("cogon.easyfis.com")) { secretKey = "6LdKs00UAAAAAM6LrdHJ3nvp8OJzG3G9lPIFmWxS"; } var client = new System.Net.WebClient(); var verificationResultJson = client.DownloadString(string.Format("https://www.google.com/recaptcha/api/siteverify?secret={0}&response={1}", secretKey, response)); var verificationResult = JsonConvert.DeserializeObject <CaptchaVerificationResult>(verificationResultJson); if (!verificationResult.Success) { ModelState.AddModelError("CaptiaError", "Invalid recaptcha challenge."); } else { if (ModelState.IsValid) { var user = new ApplicationUser { UserName = model.UserName, FullName = model.FullName, }; // var user = new ApplicationUser { UserName = model.Email, Email = model.Email }; var result = await UserManager.CreateAsync(user, model.Password); if (result.Succeeded) { await SignInManager.SignInAsync(user, isPersistent : false, rememberBrowser : false); // For more information on how to enable account confirmation and password reset please visit http://go.microsoft.com/fwlink/?LinkID=320771 // Send an email with this link // string code = await UserManager.GenerateEmailConfirmationTokenAsync(user.Id); // var callbackUrl = Url.Action("ConfirmEmail", "Account", new { userId = user.Id, code = code }, protocol: Request.Url.Scheme); // await UserManager.SendEmailAsync(user.Id, "Confirm your account", "Please confirm your account by clicking <a href=\"" + callbackUrl + "\">here</a>"); Data.easyfisdbDataContext db = new Data.easyfisdbDataContext(); var company = from d in db.MstCompanies select d; var companyId = company.FirstOrDefault().Id; var branch = from d in db.MstBranches where d.CompanyId == companyId select d; var branchId = branch.FirstOrDefault().Id; var account = from d in db.MstAccounts select d; var incomeAccountId = account.FirstOrDefault().Id; var supplierAdvancesAccountId = account.FirstOrDefault().Id; var customerAdvancesAccountId = account.FirstOrDefault().Id; var discount = from d in db.MstDiscounts select d; var discountId = discount.FirstOrDefault().Id; var officialReceiptName = "Official Receipt"; var inventoryType = "Moving Average"; var defaultSalesInvoiceDiscountId = discountId; var salesInvoiceName = "Sales Invoice"; Int32?salesInvoiceCheckedById = null; Int32?salesInvoiceApprovedById = null; var adminUser = from d in db.MstUsers where d.UserName.Equals("admin") select d; if (adminUser.Any()) { companyId = adminUser.FirstOrDefault().CompanyId; branchId = adminUser.FirstOrDefault().BranchId; incomeAccountId = adminUser.FirstOrDefault().IncomeAccountId; customerAdvancesAccountId = adminUser.FirstOrDefault().CustomerAdvancesAccountId; defaultSalesInvoiceDiscountId = adminUser.FirstOrDefault().DefaultSalesInvoiceDiscountId; salesInvoiceCheckedById = adminUser.FirstOrDefault().SalesInvoiceCheckedById; salesInvoiceApprovedById = adminUser.FirstOrDefault().SalesInvoiceApprovedById; } // ====================== // Create Registered User // ====================== Data.MstUser newMstUser = new Data.MstUser { UserId = user.Id, UserName = model.UserName, Password = model.Password, FullName = model.FullName, CompanyId = companyId, BranchId = branchId, IncomeAccountId = incomeAccountId, SupplierAdvancesAccountId = supplierAdvancesAccountId, CustomerAdvancesAccountId = customerAdvancesAccountId, InventoryType = inventoryType, DefaultSalesInvoiceDiscountId = defaultSalesInvoiceDiscountId, SalesInvoiceName = salesInvoiceName, SalesInvoiceCheckedById = salesInvoiceCheckedById, SalesInvoiceApprovedById = salesInvoiceApprovedById, OfficialReceiptName = officialReceiptName, IsIncludeCostStockReports = false, IsLocked = false, CreatedById = null, CreatedDateTime = DateTime.Now, UpdatedById = null, UpdatedDateTime = DateTime.Now }; db.MstUsers.InsertOnSubmit(newMstUser); db.SubmitChanges(); // ========================== // Current Registered User Id // ========================== var currentRegisteredUserId = newMstUser.Id; // ====================== // Update Registered User // ====================== var mstUsersData = from d in db.MstUsers where d.Id == currentRegisteredUserId select d; if (mstUsersData.Any()) { var updateMstUsersData = mstUsersData.FirstOrDefault(); updateMstUsersData.CreatedById = currentRegisteredUserId; updateMstUsersData.CreatedDateTime = DateTime.Now; updateMstUsersData.UpdatedById = currentRegisteredUserId; updateMstUsersData.UpdatedDateTime = DateTime.Now; db.SubmitChanges(); } // ============================= // Create Registered User Branch // ============================= Data.MstUserBranch newUserBranch = new Data.MstUserBranch { UserId = newMstUser.Id, BranchId = branchId }; db.MstUserBranches.InsertOnSubmit(newUserBranch); db.SubmitChanges(); return(RedirectToAction("Register", "Account")); } AddErrors(result); } } // If we got this far, something failed, redisplay form return(View(model)); }
public async Task <IHttpActionResult> Register(RegisterBindingModel model) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } var user = new ApplicationUser() { UserName = model.UserName, FullName = model.FullName }; IdentityResult result = await UserManager.CreateAsync(user, model.Password); if (!result.Succeeded) { return(GetErrorResult(result)); } else { Data.easyfisdbDataContext db = new Data.easyfisdbDataContext(); var company = from d in db.MstCompanies select d; Int32 companyId = company.FirstOrDefault().Id; var branch = from d in db.MstBranches where d.CompanyId == company.FirstOrDefault().Id select d; Int32 branchId = branch.FirstOrDefault().Id; var account = from d in db.MstAccounts select d; Int32 incomeAccountId = account.FirstOrDefault().Id; Int32 customerAdvancesAccountId = account.FirstOrDefault().Id; Int32 supplierAdvancesAccountId = account.FirstOrDefault().Id; var discount = from d in db.MstDiscounts select d; Int32 defaultSalesInvoiceDiscountId = discount.FirstOrDefault().Id; var inventoryType = "Moving Average"; var officialReceiptName = "Official Receipt"; var salesInvoiceName = "Sales Invoice"; Int32?salesInvoiceCheckedById = null; Int32?salesInvoiceApprovedById = null; var adminUser = from d in db.MstUsers where d.UserName.Equals("admin") select d; if (adminUser.Any()) { companyId = adminUser.FirstOrDefault().CompanyId; branchId = adminUser.FirstOrDefault().BranchId; incomeAccountId = adminUser.FirstOrDefault().IncomeAccountId; customerAdvancesAccountId = adminUser.FirstOrDefault().CustomerAdvancesAccountId; defaultSalesInvoiceDiscountId = adminUser.FirstOrDefault().DefaultSalesInvoiceDiscountId; salesInvoiceCheckedById = adminUser.FirstOrDefault().SalesInvoiceCheckedById; salesInvoiceApprovedById = adminUser.FirstOrDefault().SalesInvoiceApprovedById; } Data.MstUser newMstUser = new Data.MstUser { UserId = user.Id, UserName = model.UserName, Password = model.Password, FullName = model.FullName, CompanyId = companyId, BranchId = branchId, IncomeAccountId = incomeAccountId, SupplierAdvancesAccountId = supplierAdvancesAccountId, CustomerAdvancesAccountId = customerAdvancesAccountId, InventoryType = inventoryType, DefaultSalesInvoiceDiscountId = defaultSalesInvoiceDiscountId, SalesInvoiceName = salesInvoiceName, SalesInvoiceCheckedById = salesInvoiceCheckedById, SalesInvoiceApprovedById = salesInvoiceApprovedById, OfficialReceiptName = officialReceiptName, IsIncludeCostStockReports = false, IsLocked = false, CreatedById = null, CreatedDateTime = DateTime.Now, UpdatedById = null, UpdatedDateTime = DateTime.Now }; db.MstUsers.InsertOnSubmit(newMstUser); db.SubmitChanges(); var currentRegisteredUserId = newMstUser.Id; var mstUsersData = from d in db.MstUsers where d.Id == currentRegisteredUserId select d; if (mstUsersData.Any()) { var updateMstUsersData = mstUsersData.FirstOrDefault(); updateMstUsersData.CreatedById = currentRegisteredUserId; updateMstUsersData.CreatedDateTime = DateTime.Now; updateMstUsersData.UpdatedById = currentRegisteredUserId; updateMstUsersData.UpdatedDateTime = DateTime.Now; db.SubmitChanges(); } Data.MstUserBranch newUserBranch = new Data.MstUserBranch { UserId = newMstUser.Id, BranchId = branchId }; db.MstUserBranches.InsertOnSubmit(newUserBranch); db.SubmitChanges(); } return(Ok()); }