public Int32 postUser(Entities.MstUser user)
{
try
{
var userId = (from d in db.MstUsers where d.AspNetUserId == User.Identity.GetUserId() select d).FirstOrDefault().Id;
var id = User.Identity.GetUserId();
Data.MstUser newUser = new Data.MstUser();
newUser.UserName = "******";
newUser.Password = "******";
newUser.FullName = "n/a";
newUser.UserCardNumber = "n/a";
newUser.EntryUserId = userId;
newUser.EntryDateTime = DateTime.Today;
newUser.UpdateUserId = userId;
newUser.UpdateDateTime = DateTime.Today;
newUser.IsLocked = false;
newUser.AspNetUserId = id;
db.MstUsers.InsertOnSubmit(newUser);
db.SubmitChanges();
return(newUser.Id);
}
catch (Exception e)
{
Debug.WriteLine(e);
return(0);
}
}
public HttpResponseMessage AddUser(ApiModels.MstUser objUser)
{
try
{
Data.MstUser newUser = new Data.MstUser
{
Id = objUser.Id,
FirstName = objUser.FirstName,
LastName = objUser.LastName,
Password = objUser.Password,
UserTypeId = objUser.UserTypeId,
AspNetUserId = objUser.AspNetUserId,
UserName = objUser.UserName,
Email = objUser.Email
};
db.MstUsers.InsertOnSubmit(newUser);
db.SubmitChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
catch (Exception e)
{
return(Request.CreateResponse(HttpStatusCode.InternalServerError, e.Message));
}
}
public async Task <ActionResult> Register(RegisterViewModel model)
{
if (ModelState.IsValid)
{
var user = new ApplicationUser()
{
UserName = model.UserName
};
var result = await UserManager.CreateAsync(user, model.Password);
if (result.Succeeded)
{
await SignInAsync(user, isPersistent : false);
// Add or update MstUser table
Data.MagentaTradersDBDataContext db = new Data.MagentaTradersDBDataContext();
var Users = from d in db.MstUsers where d.UserName == model.UserName select d;
if (Users.Any())
{
var UpdatedUser = Users.FirstOrDefault();
UpdatedUser.AspNetUserId = db.AspNetUsers.Where(d => d.UserName == model.UserName).FirstOrDefault().Id;
db.SubmitChanges();
}
else
{
Data.MstUser NewUser = new Data.MstUser();
NewUser.UserName = model.UserName;
NewUser.FirstName = "NA";
NewUser.LastName = "NA";
NewUser.EmailAddress = "NA";
NewUser.PhoneNumber = "NA";
NewUser.AspNetUserId = db.AspNetUsers.Where(d => d.UserName == model.UserName).FirstOrDefault().Id;
db.MstUsers.InsertOnSubmit(NewUser);
db.SubmitChanges();
}
return(RedirectToAction("Index", "Home"));
}
else
{
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));
}
IdentityUser user = new IdentityUser
{
UserName = model.UserName
};
IdentityResult result = await UserManager.CreateAsync(user, model.Password);
IHttpActionResult errorResult = GetErrorResult(result);
if (errorResult != null)
{
return(errorResult);
}
// ===============
// DB Data Context
// ===============
Data.FilbrokerDBDataContext db = new Data.FilbrokerDBDataContext();
// ==============================
// Get the registered ASP User Id
// ==============================
string registeredAspUserId = user.Id;
// ===============
// Insert New User
// ===============
Data.MstUser newUser = new Data.MstUser()
{
Username = model.UserName,
FullName = model.FullName,
Password = model.Password,
Status = "ACTIVE",
AspNetId = registeredAspUserId
};
db.MstUsers.InsertOnSubmit(newUser);
db.SubmitChanges();
return(Ok());
}
public async Task <IHttpActionResult> Register(RegisterBindingModel model)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var user = new ApplicationUser()
{
UserName = model.UserName, Email = model.Email
};
IdentityResult result = await UserManager.CreateAsync(user, model.Password);
if (!result.Succeeded)
{
return(GetErrorResult(result));
}
else
{
Data.dmtipacsdbDataContext db = new Data.dmtipacsdbDataContext();
var userTypes = from d in db.MstUserTypes
where d.UserType.Equals("Doctor")
select d;
Data.MstUser newUser = new Data.MstUser
{
UserName = model.UserName,
FullName = model.FullName,
Address = model.Address,
ContactNumber = model.ContactNumber,
UserTypeId = userTypes.FirstOrDefault().Id,
AspNetUserId = user.Id
};
db.MstUsers.InsertOnSubmit(newUser);
db.SubmitChanges();
return(Ok());
}
}
public HttpResponseMessage Delete(int Id)
{
Data.MstUser DeleteUser = db.MstUsers.Where(d => d.Id == Id).First();
if (DeleteUser != null)
{
db.MstUsers.DeleteOnSubmit(DeleteUser);
try
{
db.SubmitChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
catch
{
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound));
}
}
public async Task <IHttpActionResult> Register(RegisterBindingModel model)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var user = new ApplicationUser()
{
UserName = model.Username, Email = model.Email
};
IdentityResult result = await UserManager.CreateAsync(user, model.Password);
if (!result.Succeeded)
{
return(GetErrorResult(result));
}
else
{
Data.librarydbDataContext db = new Data.librarydbDataContext();
Data.MstUser mstUser = new Data.MstUser
{
FirstName = model.FirstName,
LastName = model.LastName,
Password = model.Password,
UserTypeId = model.UserTypeId,
AspNetUserId = user.Id
};
db.MstUsers.InsertOnSubmit(mstUser);
db.SubmitChanges();
return(Ok());
}
}
public int Post(Models.User value)
{
try
{
Data.MstUser NewUser = new Data.MstUser();
NewUser.UserName = value.UserName;
NewUser.FirstName = value.FirstName;
NewUser.LastName = value.LastName;
NewUser.EmailAddress = value.EmailAddress;
NewUser.PhoneNumber = value.PhoneNumber;
db.MstUsers.InsertOnSubmit(NewUser);
db.SubmitChanges();
return(NewUser.Id);
}
catch
{
return(0);
}
}
public HttpResponseMessage Delete(int Id)
{
Data.MstUser DeleteUser = db.MstUsers.Where(d => d.Id == Id).First();
if (DeleteUser != null)
{
db.MstUsers.DeleteOnSubmit(DeleteUser);
try
{
db.SubmitChanges(); // Delete MSTUSER
var aspNetUser = from d in db.AspNetUsers where d.UserName == DeleteUser.UserName select d;
if (aspNetUser.Any())
{
var aspNetUserRoles = from d in db.AspNetUserRoles where d.UserId == aspNetUser.First().Id select d;
foreach (Data.AspNetUserRole role in aspNetUserRoles)
{
db.AspNetUserRoles.DeleteOnSubmit(role); // Delete ASPNET User Roles
}
db.SubmitChanges();
}
db.AspNetUsers.DeleteOnSubmit(aspNetUser.First()); // Delete ASPNET User
db.SubmitChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
catch
{
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound));
}
}
public HttpResponseMessage AddUser(Entities.MstUser objMstUser)
{
try
{
Data.MstUser mstUser = new Data.MstUser
{
FirstName = objMstUser.FirstName,
LastName = objMstUser.LastName,
Password = objMstUser.Password,
UserTypeId = objMstUser.UserTypeId,
};
db.MstUsers.InsertOnSubmit(mstUser);
db.SubmitChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
catch (Exception e)
{
Debug.WriteLine(e);
return(Request.CreateResponse(HttpStatusCode.InternalServerError, "Something's went wrong from the server."));
}
}
public Int32 PostMstUser(MstUser user)
{
try
{
Data.MstUser newMstUser = new Data.MstUser()
{
Username = user.Username,
FullName = user.FullName,
Password = user.Password,
Status = user.Status,
AspNetId = user.AspNetId
};
db.MstUsers.InsertOnSubmit(newMstUser);
db.SubmitChanges();
return(newMstUser.Id);
}
catch (Exception e)
{
Debug.WriteLine(e);
return(0);
}
}
public Int32 postUser()
{
try
{
Data.MstUser newUser = new Data.MstUser();
newUser.UserName = "******";
newUser.Password = "******";
newUser.FullName = "n/a";
newUser.UserCardNumber = "n/a";
newUser.EntryUserId = UserId();
newUser.EntryDateTime = DateTime.Today;
newUser.UpdateUserId = UserId();
newUser.UpdateDateTime = DateTime.Today;
newUser.IsLocked = false;
db.MstUsers.InsertOnSubmit(newUser);
db.SubmitChanges();
return(newUser.Id);
}
catch (Exception e)
{
return(0);
}
}
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 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";
}
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", "ERROR: 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 branch = from d in db.MstBranches where d.CompanyId == company.FirstOrDefault().Id select d;
var account = from d in db.MstAccounts select d;
var discount = from d in db.MstDiscounts select d;
var companyId = company.FirstOrDefault().Id;
var branchId = branch.FirstOrDefault().Id;
var incomeAccountId = account.FirstOrDefault().Id;
var supplierAdvancesAccountId = account.FirstOrDefault().Id;
var customerAdvancesAccountId = account.FirstOrDefault().Id;
var officialReceiptName = "Official Receipt";
var inventoryType = "Moving Average";
var defaultSalesInvoiceDiscountId = discount.FirstOrDefault().Id;
var salesInvoiceName = "Sales Invoice";
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;
}
Data.MstUser newMstUser = new Data.MstUser();
newMstUser.UserId = user.Id;
newMstUser.UserName = model.UserName;
newMstUser.Password = model.Password;
newMstUser.FullName = model.FullName;
newMstUser.CompanyId = companyId;
newMstUser.BranchId = branchId;
newMstUser.IncomeAccountId = incomeAccountId;
newMstUser.SupplierAdvancesAccountId = supplierAdvancesAccountId;
newMstUser.CustomerAdvancesAccountId = customerAdvancesAccountId;
newMstUser.OfficialReceiptName = officialReceiptName;
newMstUser.InventoryType = inventoryType;
newMstUser.DefaultSalesInvoiceDiscountId = defaultSalesInvoiceDiscountId;
newMstUser.SalesInvoiceName = salesInvoiceName;
newMstUser.IsLocked = true;
newMstUser.CreatedById = 0;
newMstUser.CreatedDateTime = DateTime.Now;
newMstUser.UpdatedById = 0;
newMstUser.UpdatedDateTime = DateTime.Now;
db.MstUsers.InsertOnSubmit(newMstUser);
db.SubmitChanges();
var mstUsersData = from d in db.MstUsers where d.Id == newMstUser.Id select d;
if (mstUsersData.Any())
{
var updateMstUsersData = mstUsersData.FirstOrDefault();
updateMstUsersData.CreatedById = newMstUser.Id;
updateMstUsersData.UpdatedById = newMstUser.Id;
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());
}
public async Task <ActionResult> Register(RegisterViewModel model)
{
if (ModelState.IsValid)
{
var user = new ApplicationUser {
UserName = model.UserName, Email = ""
};
var result = await UserManager.CreateAsync(user, model.Password);
if (result.Succeeded)
{
await SignInManager.SignInAsync(user, isPersistent : false, rememberBrowser : false);
String fullname = model.LastName + ", " + model.FirstName + " " + model.MiddleName;
Data.lendingsystemDataContext db = new Data.lendingsystemDataContext();
Data.MstUser newUser = new Data.MstUser()
{
AspNetUserId = user.Id,
Username = model.UserName,
Password = model.Password,
FullName = fullname,
IsLocked = true,
UserType = "Customer"
};
db.MstUsers.InsertOnSubmit(newUser);
db.SubmitChanges();
Data.MstCustomer newCustomer = new Data.MstCustomer()
{
FullName = fullname,
BirthDate = Convert.ToDateTime(model.BirthDate),
Gender = model.Gender,
Address = model.Address,
ContactNumber = model.ContactNumber,
Photo = "NA",
UserId = newUser.Id,
IsLocked = true,
CreatedByUserId = newUser.Id,
CreatedDateTime = DateTime.Now,
UpdatedByUserId = newUser.Id,
UpdatedDateTime = DateTime.Now
};
db.MstCustomers.InsertOnSubmit(newCustomer);
db.SubmitChanges();
// For more information on how to enable account confirmation and password reset please visit https://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>");
return(RedirectToAction("Index", "Home"));
}
AddErrors(result);
}
// If we got this far, something failed, redisplay form
return(View(model));
}
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<ActionResult> Register(RegisterViewModel model)
{
var response = HttpContext.Request.Form["g-recaptcha-response"];
string secretKey = "6LeNBiMTAAAAAMZUdKMa_Q4_XRGLjOEjpVP96fge";
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", "ERROR: 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 branch = from d in db.MstBranches where d.CompanyId == company.FirstOrDefault().Id select d;
var account = from d in db.MstAccounts select d;
Data.MstUser newMstUser = new Data.MstUser();
newMstUser.UserName = model.UserName;
newMstUser.Password = model.Password;
newMstUser.FullName = model.FullName;
newMstUser.IsLocked = true;
newMstUser.CreatedById = 0;
newMstUser.CreatedDateTime = DateTime.Now;
newMstUser.UpdatedById = 0;
newMstUser.UpdatedDateTime = DateTime.Now;
newMstUser.UserId = user.Id;
newMstUser.CompanyId = company.FirstOrDefault().Id;
newMstUser.BranchId = branch.FirstOrDefault().Id;
newMstUser.IncomeAccountId = account.FirstOrDefault().Id;
newMstUser.SupplierAdvancesAccountId = account.FirstOrDefault().Id;
newMstUser.CustomerAdvancesAccountId = account.FirstOrDefault().Id;
newMstUser.OfficialReceiptName = "Official Receipt";
db.MstUsers.InsertOnSubmit(newMstUser);
db.SubmitChanges();
var mstUsersData = from d in db.MstUsers where d.UserId == user.Id select d;
if (mstUsersData.Any())
{
var mstUserId = (from d in db.MstUsers.OrderByDescending(d => d.Id) where d.UserId == user.Id select d.Id).FirstOrDefault();
var updateMstUsersData = mstUsersData.FirstOrDefault();
updateMstUsersData.CreatedById = mstUserId;
updateMstUsersData.UpdatedById = mstUserId;
db.SubmitChanges();
}
return RedirectToAction("Register", "Account");
}
//AddErrors(result);
}
}
// If we got this far, something failed, redisplay form
return View(model);
}
public async Task <ActionResult> Register(RegisterViewModel model)
{
if (model.UserName == null)
{
return(View(model));
}
if (ModelState.IsValid)
{
var user = new ApplicationUser()
{
UserName = model.UserName
};
var result = await UserManager.CreateAsync(user, model.Password);
var response = HttpContext.Request.Form["g-recaptcha-response"] == null ? "" : HttpContext.Request.Form["g-recaptcha-response"];
string secretKey = "6Lc5GBoTAAAAAOQFNfUBzRtzN_I-vmyJzGugEx65";
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("", "ERROR: Invalid recaptcha challenge.");
}
else
{
if (result.Succeeded)
{
// Add or update MstUser table
try
{
await SignInAsync(user, isPersistent : false);
Data.MagentaTradersDBDataContext db = new Data.MagentaTradersDBDataContext();
var Users = from d in db.MstUsers where d.UserName == model.UserName select d;
if (Users.Any())
{
var UpdatedUser = Users.FirstOrDefault();
UpdatedUser.AspNetUserId = db.AspNetUsers.Where(d => d.UserName == model.UserName).FirstOrDefault().Id;
db.SubmitChanges();
}
else
{
Data.MstUser NewUser = new Data.MstUser();
NewUser.UserName = model.UserName;
NewUser.FirstName = model.FirstName == null || model.FirstName.Length == 0 ? "NA" : model.FirstName;
NewUser.LastName = model.LastName == null || model.LastName.Length == 0 ? "NA" : model.LastName;
NewUser.EmailAddress = model.EmailAddress == null || model.EmailAddress.Length == 0 ? "NA" : model.EmailAddress;
NewUser.PhoneNumber = model.PhoneNumber == null || model.PhoneNumber.Length == 0 ? "NA" : model.PhoneNumber;
NewUser.Address = model.Address == null || model.Address.Length == 0 ? "" : model.Address;
NewUser.ReferralUserName = model.ReferralUserName == null || model.ReferralUserName.Length == 0 ? "" : model.ReferralUserName;
NewUser.AspNetUserId = db.AspNetUsers.Where(d => d.UserName == model.UserName).FirstOrDefault().Id;
DateTime dateCreated = DateTime.Now;
SqlDateTime dateCreatedSQL = new SqlDateTime(new DateTime(dateCreated.Year, +
dateCreated.Month, +
dateCreated.Day));
NewUser.DateCreated = dateCreatedSQL.Value;
db.MstUsers.InsertOnSubmit(NewUser);
db.SubmitChanges();
Data.AspNetUserRole NewRole1 = new Data.AspNetUserRole();
NewRole1.AspNetUser = db.AspNetUsers.Where(d => d.UserName == model.UserName).FirstOrDefault();
NewRole1.AspNetRole = db.AspNetRoles.Where(d => d.Name == "Quest").FirstOrDefault();
db.AspNetUserRoles.InsertOnSubmit(NewRole1);
db.SubmitChanges();
Data.AspNetUserRole NewRole2 = new Data.AspNetUserRole();
NewRole2.AspNetUser = db.AspNetUsers.Where(d => d.UserName == model.UserName).FirstOrDefault();
NewRole2.AspNetRole = db.AspNetRoles.Where(d => d.Name == "Chart").FirstOrDefault();
db.AspNetUserRoles.InsertOnSubmit(NewRole2);
db.SubmitChanges();
Data.AspNetUserRole NewRole3 = new Data.AspNetUserRole();
NewRole3.AspNetUser = db.AspNetUsers.Where(d => d.UserName == model.UserName).FirstOrDefault();
NewRole3.AspNetRole = db.AspNetRoles.Where(d => d.Name == "Web99").FirstOrDefault();
db.AspNetUserRoles.InsertOnSubmit(NewRole3);
db.SubmitChanges();
}
return(RedirectToAction("Index", "Help"));
//return RedirectToAction("Index", "Home");
}
catch (Exception e)
{
ModelState.AddModelError("", "ERROR: Try again. " + e.ToString());
}
}
else
{
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, Email = model.Email
};
IdentityResult result = await UserManager.CreateAsync(user, model.Password);
if (result.Succeeded)
{
Data.SodexDatabaseDataContext db = new Data.SodexDatabaseDataContext();
var card = from d in db.MstCards where d.CardNumber.Equals(model.MotherCardNumber) select d;
if (card.Any())
{
Data.MstUser newUser = new Data.MstUser()
{
AspNetUserId = user.Id,
Username = model.UserName,
UserTypeId = 3,
FullName = model.FullName,
Address = model.Address,
Email = model.Email,
ContactNumber = model.ContactNumber,
MotherCardNumber = "NA",
Status = "Enable"
};
db.MstUsers.InsertOnSubmit(newUser);
db.SubmitChanges();
}
else
{
Data.MstUser newUser = new Data.MstUser()
{
AspNetUserId = user.Id,
Username = model.UserName,
UserTypeId = 2,
FullName = model.FullName,
Address = model.Address,
Email = model.Email,
ContactNumber = model.ContactNumber,
MotherCardNumber = model.MotherCardNumber,
Status = "Enable"
};
db.MstUsers.InsertOnSubmit(newUser);
db.SubmitChanges();
Data.MstCard newCard = new Data.MstCard
{
CardNumber = model.MotherCardNumber,
FullName = model.FullName,
Address = model.Address,
Email = model.Email,
ContactNumber = model.ContactNumber,
UserId = newUser.Id,
Balance = 0,
Particulars = newUser.FullName + " " + DateTime.Now.ToString(),
Status = "Enable"
};
db.MstCards.InsertOnSubmit(newCard);
db.SubmitChanges();
}
return(Ok());
}
else
{
return(GetErrorResult(result));
}
}
public int Post(Models.MstUser user)
{
try
{
var isLocked = true;
var identityUserId = User.Identity.GetUserId();
var mstUserId = (from d in db.MstUsers where "" + d.Id == identityUserId select d.Id).SingleOrDefault();
var date = DateTime.Now;
Data.MstUser newUser = new Data.MstUser();
newUser.UserName = user.UserName;
newUser.IsLocked = isLocked;
newUser.Password = user.Password;
newUser.FullName = user.FullName;
newUser.UserCardNumber = user.UserCardNumber;
newUser.EntryUserId = mstUserId;
newUser.EntryDateTime = date;
newUser.UpdateUserId = mstUserId;
newUser.UpdateDateTime = date;
db.MstUsers.InsertOnSubmit(newUser);
db.SubmitChanges();
return newUser.Id;
}
catch
{
return 0;
}
}
public async Task <ActionResult> Register(RegisterViewModel model)
{
Data.easyfisdbDataContext db = new Data.easyfisdbDataContext();
var currentUser = from d in db.MstUsers where d.UserId == User.Identity.GetUserId() select d;
if (currentUser.FirstOrDefault().UserName.Equals("admin"))
{
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>");
int newUserId = 0;
var adminUser = from d in db.MstUsers where d.UserName.Equals("admin") select d;
if (adminUser.Any())
{
Data.MstUser newUser = new Data.MstUser
{
UserId = user.Id,
UserName = model.UserName,
Password = model.Password,
FullName = model.FullName,
CompanyId = adminUser.FirstOrDefault().CompanyId,
BranchId = adminUser.FirstOrDefault().BranchId,
IncomeAccountId = adminUser.FirstOrDefault().IncomeAccountId,
SupplierAdvancesAccountId = adminUser.FirstOrDefault().SupplierAdvancesAccountId,
CustomerAdvancesAccountId = adminUser.FirstOrDefault().CustomerAdvancesAccountId,
InventoryType = adminUser.FirstOrDefault().InventoryType,
DefaultSalesInvoiceDiscountId = adminUser.FirstOrDefault().DefaultSalesInvoiceDiscountId,
SalesInvoiceName = adminUser.FirstOrDefault().SalesInvoiceName,
SalesInvoicePrefix = adminUser.FirstOrDefault().SalesInvoicePrefix,
SalesInvoiceCheckedById = adminUser.FirstOrDefault().SalesInvoiceCheckedById,
SalesInvoiceApprovedById = adminUser.FirstOrDefault().SalesInvoiceApprovedById,
OfficialReceiptName = adminUser.FirstOrDefault().OfficialReceiptName,
OfficialReceiptPrefix = adminUser.FirstOrDefault().OfficialReceiptPrefix,
IsIncludeCostStockReports = adminUser.FirstOrDefault().IsIncludeCostStockReports,
ActivateAuditTrail = adminUser.FirstOrDefault().ActivateAuditTrail,
IsSIVATAnalysisIncluded = adminUser.FirstOrDefault().IsSIVATAnalysisIncluded,
IsSIDuplicateDocumentReferenceAllowed = adminUser.FirstOrDefault().IsSIDuplicateDocumentReferenceAllowed,
CustomerReturnAccountId = adminUser.FirstOrDefault().CustomerReturnAccountId,
SupplierReturnAccountId = adminUser.FirstOrDefault().SupplierReturnAccountId,
IsLocked = false,
CreatedById = adminUser.FirstOrDefault().Id,
CreatedDateTime = DateTime.Now,
UpdatedById = adminUser.FirstOrDefault().Id,
UpdatedDateTime = DateTime.Now
};
db.MstUsers.InsertOnSubmit(newUser);
db.SubmitChanges();
newUserId = newUser.Id;
return(Redirect("/Software/UsersDetail?id=" + newUserId));
}
}
AddErrors(result);
}
}
}
else
{
ModelState.AddModelError("AdminError", "As of now, only the Admin has rights to register new user. Please contact Administrator.");
}
// If we got this far, something failed, redisplay form
return(View(model));
}
