public ActionResult Register(Register model) { OKhachHang khachHang = new OKhachHang { TenKhach = model.FullName, DienThoai = model.Phone, Email = model.Email, }; khService.Add(khachHang); int idKhach = khService.GetLastId(); OAccount account = new OAccount { Email = khachHang.Email, MaKhach = idKhach, MatKhau = model.Password, TenDN = model.UserName, MaQuyen = 3, }; if (accountService.Register(account)) { Session["Account"] = account; //Random rd = new Random(); //string strRandom; //strRandom = rd.Next(1, 1000).ToString(); //Session["RandomText"] = strRandom; //SendMailActive(account.Email, strRandom); return(RedirectToAction("Index", "Home")); } return(View("Login")); }
public ActionResult Create() { OAccount data = new OAccount(); data.TrangThai = false; ViewBag.Customers = new SelectList(khService.GetAll(), "MaKhach", "TenKhach"); ViewBag.ListRoles = new SelectList(accountService.GetAllRole(), "MaQuyen", "TenQuyen"); return(View(data)); }
public OAccount GetById(string matk) { conn.connect(); var comm = new SqlCommand("Account_GetByMaTK", conn.db); comm.CommandType = System.Data.CommandType.StoredProcedure; comm.Parameters.Add("@MaTK", SqlDbType.UniqueIdentifier).Value = Guid.Parse(matk); DataTable dt = new DataTable(); dt.Load(comm.ExecuteReader()); OAccount oAccount = new OAccount(); oAccount = Help.DAL.ConvertDataTable <OAccount>(dt).FirstOrDefault(); conn.Close(); return(oAccount); }
public OAccount Get(string username, string password) { conn.connect(); var comm = new SqlCommand("Account_Get", conn.db); comm.CommandType = System.Data.CommandType.StoredProcedure; comm.Parameters.Add("@UserName", SqlDbType.NVarChar).Value = username; comm.Parameters.Add("@Password", SqlDbType.NVarChar).Value = password; DataTable dt = new DataTable(); dt.Load(comm.ExecuteReader()); OAccount oAccount = new OAccount(); oAccount = Help.DAL.ConvertDataTable <OAccount>(dt).FirstOrDefault(); conn.Close(); return(oAccount); }
public bool UnLock(OAccount item) { conn.connect(); var comm = new SqlCommand("Account_UnLock", conn.db); comm.CommandType = CommandType.StoredProcedure; if (comm == null) { return(false); } comm.Parameters.Add("@MaTK", SqlDbType.UniqueIdentifier).Value = item.MaTK; if (comm.ExecuteNonQuery() != 0) { return(true); } return(false); }
public bool Register(OAccount account) { conn.connect(); var comm = new SqlCommand("Account_Register", conn.db); comm.CommandType = System.Data.CommandType.StoredProcedure; comm.Parameters.Add("@UserName", SqlDbType.NVarChar).Value = account.TenDN; comm.Parameters.Add("@Password", SqlDbType.NVarChar).Value = Help.Helper.EncodeSHA1(account.MatKhau); comm.Parameters.Add("@Email", SqlDbType.NVarChar).Value = account.Email; comm.Parameters.Add(new SqlParameter("@MaKhach", account.MaKhach ?? (object)DBNull.Value)); SqlDataReader reader = comm.ExecuteReader(); OAccount oAccount = new OAccount(); conn.Close(); return(true); }
public ActionResult Update(string matk, string username, string email) { var account = new OAccount { TenDN = username, Email = email, MaTK = Guid.Parse(matk) }; if (accountService.Update(account)) { if (Session["Admin"] != null) { Session["Admin"] = account; } return(Json(new { Success = true, Message = "Sửa thông tin thành công!", Model = account })); } return(Json(new { Success = false, Message = "Sửa thông tin thất bại!" })); }
public bool Active(OAccount item) { conn.connect(); var comm = new SqlCommand("Account_Active", conn.db); comm.CommandType = CommandType.StoredProcedure; if (comm == null) { return(false); } comm.Parameters.Add("@UserName", SqlDbType.NVarChar).Value = item.TenDN; comm.Parameters.Add("@Password", SqlDbType.NVarChar).Value = Help.Helper.EncodeSHA1(item.MatKhau); if (comm.ExecuteNonQuery() != 0) { return(true); } return(false); }
public bool ChangePass(OAccount item, string newpass) { conn.connect(); var comm = new SqlCommand("Account_ChangePass_Admin", conn.db); comm.CommandType = CommandType.StoredProcedure; if (comm == null) { return(false); } comm.Parameters.Add("@UserName", SqlDbType.NVarChar).Value = item.TenDN; comm.Parameters.Add("@OldPass", SqlDbType.NVarChar).Value = Help.Helper.EncodeSHA1(item.MatKhau); comm.Parameters.Add("@NewPass", SqlDbType.NVarChar).Value = Help.Helper.EncodeSHA1(newpass); if (comm.ExecuteNonQuery() != 0) { return(true); } return(false); }
public void Add(OAccount account) { conn.connect(); var comm = new SqlCommand("Account_Add", conn.db); comm.CommandType = System.Data.CommandType.StoredProcedure; comm.Parameters.Add("@TenDN", SqlDbType.NVarChar).Value = account.TenDN; comm.Parameters.Add("@MatKhau", SqlDbType.NVarChar).Value = Help.Helper.EncodeSHA1(account.MatKhau); comm.Parameters.Add("@Email", SqlDbType.NVarChar).Value = account.Email; comm.Parameters.Add("@MaQuyen", SqlDbType.Int).Value = account.MaQuyen; comm.Parameters.Add("@TrangThai", SqlDbType.Bit).Value = account.TrangThai; comm.Parameters.Add(new SqlParameter("@MaKhach", account.MaKhach ?? (object)DBNull.Value)); SqlDataReader reader = comm.ExecuteReader(); OAccount oAccount = new OAccount(); conn.Close(); }
public bool Update(OAccount item) { conn.connect(); var comm = new SqlCommand("Account_Update", conn.db); comm.CommandType = CommandType.StoredProcedure; if (comm == null) { return(false); } comm.Parameters.Add("@MaTK", SqlDbType.UniqueIdentifier).Value = item.MaTK; comm.Parameters.Add("@UserName", SqlDbType.NVarChar).Value = item.TenDN; comm.Parameters.Add(new SqlParameter("@Email", item.Email ?? (object)DBNull.Value)); if (comm.ExecuteNonQuery() != 0) { return(true); } return(false); }
public ActionResult Create(OAccount model) { if (ModelState.IsValid) { try { accountService.Add(model); return(RedirectToAction("Search", "QuanLyNguoiDung")); } catch (Exception e) { } } ViewBag.IsEdit = true; ViewBag.Customers = new SelectList(khService.GetAll(), "MaKhach", "TenKhach"); ViewBag.ListRoles = new SelectList(accountService.GetAllRole(), "MaQuyen", "TenQuyen"); return(View(model)); }
private async void Save_Click(object sender, RoutedEventArgs e) { if (numberBox.Text.Length < numberBox.MaxLength || !numberRx.IsMatch(numberBox.Text)) { numberBox.Focus(FocusState.Programmatic); return; } if (passwordBox.Password.Length == 0 || carrierBox.SelectedIndex == 1 && passwordBox.Password.Length != BitePasswordLength) { passwordBox.Focus(FocusState.Programmatic); return; } if (Network.Disconnected) { await new MessageDialog(DisplayResources.Strings.GetString("NetworkOffline")).ShowAsync(); return; } SetEnabled(false); var statusBar = StatusBar.GetForCurrentView(); statusBar.ProgressIndicator.Text = DisplayResources.Strings.GetString("LoggingIn"); await statusBar.ProgressIndicator.ShowAsync(); string number = numberBox.Text; Account account = null; string errorMessage = null, errorMessageId = null; try { switch (carrierBox.SelectedIndex) { case 0: errorMessageId = "ZZLoginFailure"; account = await ZZAccount.Login(client, numberBox.Text, passwordBox.Password); break; case 1: errorMessageId = "BiteLoginFailure"; account = await BiteAccount.Login(client, numberBox.Text, passwordBox.Password.ToUpper()); break; case 2: errorMessageId = "OLoginFailure"; account = await OAccount.Login(client, numberBox.Text, passwordBox.Password); break; } if (account == null) { errorMessage = DisplayResources.Strings.GetString(errorMessageId); } } catch (Exception ex) { errorMessage = ex.Message + Environment.NewLine + DisplayResources.Strings.GetString(errorMessageId); } await statusBar.ProgressIndicator.HideAsync(); if (errorMessage != null) { await new MessageDialog(errorMessage).ShowAsync(); SetEnabled(true); return; } account.RefreshInterval = TimeSpan.FromMinutes(30); account.Caption = string.Concat(number.Substring(0, 2), " ", number.Substring(2, 3), " ", number.Substring(5, 3)); app.Accounts.Add(account); Settings.SetAccounts(app.Accounts); app.HaveAccountsChanged = false; Settings.AddAccount(account); statusBar.ProgressIndicator.Text = DisplayResources.Strings.GetString("Refreshing"); await statusBar.ProgressIndicator.ShowAsync(); errorMessage = null; try { await account.SetBalance(client); } catch (Exception) { // Ja nespēja noskaidrot atlikumu, ļauj lietotājam to vēlāk pamēģināt. } await statusBar.ProgressIndicator.HideAsync(); app.Account = account; Frame.Navigate(typeof(EditAccountPage)); }
private static OAccount findParentLevel(OAccount acc, int levelRemain) { while (levelRemain > 0) { OAccount result = findParentLevel(acc.Parent, levelRemain - 1); return result; } return acc; }
/// <summary> /// Return a Data Table representing the Budget Detail Summary Report table structure. /// </summary> /// <param name="location"></param> /// <param name="YTD"></param> /// <returns>DataTable</returns> public static DataTable BudgetDetailSummaryReport(OLocation location, DateTime YTD, OAccount account) { // Validate User Access Right // TO DO // Create Account Condition ExpressionCondition cond = Query.True; if (null != account) cond = cond & TablesLogic.tBudgetTransactionLog.Account.HierarchyPath.Like(account.HierarchyPath + "%"); DateTime formattedYTD = new DateTime(YTD.Year, YTD.Month, 1); DataTable result = new DataTable("BudgetDetailSummary"); // Table structure: Expenses | Y____ Budget (a) | Current Month Actual | // YTD Actual (b) | YTD Budget (c) | Variance (=(e)/(a)) | Budget Balance ((a)-(b)) result.Columns.Add("ParentAccount"); result.Columns.Add("Expenses"); result.Columns.Add("YearBudget", typeof(decimal)); result.Columns.Add("CurrentMonthActual", typeof(decimal)); result.Columns.Add("YTDActual", typeof(decimal)); result.Columns.Add("YTDBudget", typeof(decimal)); result.Columns.Add("Variance", typeof(decimal)); result.Columns.Add("BudgetBalance", typeof(decimal)); OBudgetPeriod budgetPeriod = TablesLogic.tBudgetPeriod.Load( TablesLogic.tBudgetPeriod.Budget.ApplicableLocations.ObjectID == location.ObjectID & TablesLogic.tBudgetPeriod.StartDate <= formattedYTD & TablesLogic.tBudgetPeriod.EndDate >= formattedYTD ); if (budgetPeriod == null) return result; OBudget budget = budgetPeriod.Budget; DataList<OBudgetPeriodOpeningBalance> openingBalances = budgetPeriod.BudgetPeriodOpeningBalances; int count = 1; foreach (OBudgetPeriodOpeningBalance balance in openingBalances) { DataRow row = result.NewRow(); row["Expenses"] = balance.Account.Parent.ObjectName; row["ParentAccount"] = balance.Account.ObjectName; row["YearBudget"] = balance.TotalOpeningBalance; decimal currentMonthActual = TablesLogic.tBudgetTransactionLog .Select(TablesLogic.tBudgetTransactionLog.TransactionAmount.Sum()) .Where(TablesLogic.tBudgetTransactionLog.IsDeleted == 0 & TablesLogic.tBudgetTransactionLog.BudgetID == budget.ObjectID & TablesLogic.tBudgetTransactionLog.AccountID == balance.AccountID & TablesLogic.tBudgetTransactionLog.TransactionType.In(1, 2, 12, 13, 14) & TablesLogic.tBudgetTransactionLog.DateOfExpenditure >= formattedYTD & TablesLogic.tBudgetTransactionLog.DateOfExpenditure <= formattedYTD.AddMonths(1) & cond); row["CurrentMonthActual"] = currentMonthActual; decimal YTDActual = TablesLogic.tBudgetTransactionLog .Select(TablesLogic.tBudgetTransactionLog.TransactionAmount.Sum()) .Where(TablesLogic.tBudgetTransactionLog.IsDeleted == 0 & TablesLogic.tBudgetTransactionLog.BudgetID == budget.ObjectID & TablesLogic.tBudgetTransactionLog.AccountID == balance.AccountID & TablesLogic.tBudgetTransactionLog.TransactionType.In(1, 2, 12, 13, 14) & TablesLogic.tBudgetTransactionLog.DateOfExpenditure >= budgetPeriod.StartDate & TablesLogic.tBudgetTransactionLog.DateOfExpenditure <= formattedYTD.AddMonths(1) & cond); row["YTDActual"] = YTDActual; decimal YTDBudget = 0; switch (formattedYTD.Month) { case 12: YTDBudget += balance.OpeningBalance12.Value; goto case 11; case 11: YTDBudget += balance.OpeningBalance11.Value; goto case 10; case 10: YTDBudget += balance.OpeningBalance10.Value; goto case 9; case 9: YTDBudget += balance.OpeningBalance09.Value; goto case 8; case 8: YTDBudget += balance.OpeningBalance08.Value; goto case 7; case 7: YTDBudget += balance.OpeningBalance07.Value; goto case 6; case 6: YTDBudget += balance.OpeningBalance06.Value; goto case 5; case 5: YTDBudget += balance.OpeningBalance05.Value; goto case 4; case 4: YTDBudget += balance.OpeningBalance04.Value; goto case 3; case 3: YTDBudget += balance.OpeningBalance03.Value; goto case 2; case 2: YTDBudget += balance.OpeningBalance02.Value; goto case 1; case 1: YTDBudget += balance.OpeningBalance01.Value; break; } row["YTDBudget"] = YTDBudget; decimal budgetBalance = balance.TotalOpeningBalance.Value - Convert.ToDecimal(row["YTDActual"]); row["BudgetBalance"] = budgetBalance; row["Variance"] = (balance.TotalOpeningBalance.Value != 0) ? budgetBalance / balance.TotalOpeningBalance.Value : 0; result.Rows.Add(row); } return result; }
public ActionResult DatHang() { string strChuoi = ""; decimal total = 0; ShoppingCartModels model = new ShoppingCartModels(); model.Cart = (Carts)Session["Cart"]; if (Session["Account"] == null || Session["Account"].ToString() == "") { //return RedirectToAction("Login", "Account"); return(Json(new { Success = false, Url = Url.Action("Login", "Account") })); } OAccount account = (OAccount)Session["Account"]; OAccount kh = accountService.Get(account.TenDN, account.MatKhau); if (kh == null) { return(Redirect("Error")); } OHoaDonBan ddh = new OHoaDonBan { MaKhach = kh.MaKhach, TrangThai = 0, }; hdbService.Add(ddh); int idHdb = hdbService.GetLastId(); foreach (var item in model.Cart.ListItem) { cTHDBService.Add(new OCTHDB { MaHDB = idHdb, MaSanPham = item.ProductId, SoLuong = item.Quantity, ThanhTien = item.Total, }); strChuoi += "<li> Tên sản phẩm: " + item.ProductName + "</li> "; strChuoi += "<li> Giá: " + item.Price.ToString("#,##") + " đ</li> "; strChuoi += "<li> Số lượng: " + item.Quantity + "</li> "; total += item.Total; var product = sachService.Get(new OSanPham { MaSanPham = item.ProductId }); var newproduct = sachService.Get(new OSanPham { MaSanPham = item.ProductId }); if (product != null) { newproduct.SoLuong = product.SoLuong - item.Quantity; sachService.Update(newproduct); } } strChuoi += "<li>Tổng tiền: " + total.ToString("#,##") + " đ </li>"; SendEmail(kh.Email, strChuoi); Session["Cart"] = null; return(Json(new { Success = true, Message = "Đặt hàng thành công. Bạn hãy check email nhé !" })); }
/// <summary> /// Creates a tree node from the specified OAccount /// object. /// </summary> /// <param name="account"></param> /// <returns></returns> protected TreeNode CreateNode(OAccount account) { if (account != null) return CreateTreeNode( account.ObjectName, account.ObjectID.ToString(), account.Type == 0 ? ConfigurationManager.AppSettings["ImageUrl_LocationLogical"] : ConfigurationManager.AppSettings["ImageUrl_LocationPhysical"], "OAccount", account.Type == 0 ? selectCategory : selectItem); return null; }