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