public IActionResult Process(double change) { int? id = HttpContext.Session.GetInt32("Id"); accounts UserAccount = _context.accounts.Where(p => p.userid == (int)id).FirstOrDefault(); if (UserAccount == null) { accounts newaccount = new accounts() { userid = (long)id, change = change, created_at = DateTime.Now, updated_at = DateTime.Now }; _context.Add(newaccount); _context.SaveChanges(); } else { accounts newaccount = new accounts() { userid = (long)id, change = change, created_at = DateTime.Now, updated_at = DateTime.Now }; _context.Add(newaccount); _context.SaveChanges(); } return(RedirectToAction("Status", new{ id = id })); }
private Account Map(accounts accountDB) { Account account = new Account(); FieldMap(accountDB, account); return(account); }
public void Delete(Account account) { accounts accountDB = ctx.accounts.Where(x => x.id == account.Id).FirstOrDefault(); ctx.accounts.DeleteObject(accountDB); ctx.SaveChanges(); }
public override void Save() { if (string.IsNullOrEmpty(Txt_name.Text)) { Txt_name.ErrorText = "يرجى إدخال اسم الخزنة !"; return; } else { var db = new SalesDataContext(); accounts Account; if (Treasury.id == 0) { Action = "Insert"; Account = new accounts(); db.treasurys.InsertOnSubmit(Treasury); db.accounts.InsertOnSubmit(Account); } else { Action = "Update"; db.treasurys.Attach(Treasury); Account = db.accounts.Single(S => S.id == Treasury.account_id); } SetData(); Account.name = Treasury.name; db.SubmitChanges(); Treasury.account_id = Account.id; db.SubmitChanges(); Txt_name.Text = string.Empty; Txt_name.Focus(); base.Save(); } }
public void Update(Account account) { accounts accountDB = ctx.accounts.ToList().Where(x => x.id == account.Id).FirstOrDefault(); FieldMap(account, accountDB); ctx.SaveChanges(); }
protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e) { if (e.CommandName == "del") { using (var db = new CstwebEntities()) { int id = Convert.ToInt32(e.CommandArgument); teachers tea = db.teachers.FirstOrDefault(a => a.id == id); accounts ac = db.accounts.FirstOrDefault(a => a.teacherid == id); db.teachers.Remove(tea); db.accounts.Remove(ac); db.SaveChanges(); Response.Write("<script>alert('删除成功');window.location = 'teachers.aspx';</script>"); } } else if (e.CommandName == "res") { using (var db = new CstwebEntities()) { int id = Convert.ToInt32(e.CommandArgument); accounts ac = db.accounts.FirstOrDefault(a => a.teacherid == id); ac.password = PasswordHash.PasswordHash.CreateHash(ac.account); db.SaveChanges(); Response.Write("<script>alert('重置成功');window.location = 'teachers.aspx';</script>"); } } }
public async Task <IActionResult> Putaccounts([FromRoute] string id, [FromBody] accounts accounts) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != accounts.accountid) { return(BadRequest()); } _context.Entry(accounts).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!accountsExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
private void Form1_Load(object sender, EventArgs e) { accounts a = new accounts(); List<accounts> b = new List<accounts>(); string[] xd = File.ReadAllLines(Environment.CurrentDirectory + @"\accounts.txt",Encoding.Default); foreach (var x in xd) { int suan = 0; foreach (var z in x.Split('|')) { if (suan == 0) { a.oauth = z; } else { a.nickname = z; } suan = suan + 1; } b.Add(a); } foreach (var c in b) { chatstart(c.oauth, channel, c.nickname); Thread.Sleep(100); } }
private accounts Map(Account account) { accounts accountDB = new accounts(); FieldMap(account, accountDB); return(accountDB); }
private void btnInloggen_Click(object sender, EventArgs e) { accounts acct = new accounts(); acct.rekeningNummer = txbRekeningNummer.Text; string pincode = txbPincode.Text; acct.user_password = pincode; bool verify = acct.checkPassword(); if (verify) { if (acct.is_admin == true) { this.Hide(); changeUser adminPage = new changeUser(); adminPage.ShowDialog(); } else { MessageBox.Show("U heeft niet de rechten om als admin in te mogen loggen!"); } } else { MessageBox.Show("Uw pincode en/of rekeningnummer zijn onjuist!"); } }
public IActionResult ProfileUpdate(accounts account) { if (HttpContext.Session.GetString("accId") != null) { string PasswordMd5 = Encryptor.GetMd5Hash(account.Account_password); var ac = db.accounts.FirstOrDefault(m => m.Account_id.Equals(account.Account_id)); var password = ac.Account_password; var phone = db.accounts.FirstOrDefault(item => item.Account_phone.Equals(account.Account_phone)); var email = db.accounts.FirstOrDefault(item => item.Account_email.Equals(account.Account_email)); try { var result = db.accounts.Find(account.Account_id); result.Account_name = account.Account_name; if (!string.IsNullOrWhiteSpace(PasswordMd5)) { if (password == null) { result.Account_password = PasswordMd5; } } else { ViewBag.Msg = "Please enter Password"; } if (phone == null) { result.Account_phone = account.Account_phone; } else { ViewBag.Msg = "This account phone has already existed!"; } if (email == null) { result.Account_email = account.Account_email; } else { ViewBag.Msg = "This account email has already existed!"; } result.Account_address = account.Account_address; db.SaveChanges(); return(RedirectToAction("Index", "Web")); } catch (Exception ex) { ModelState.AddModelError("Error: ", ex.Message); } } return(View(@"~/Views/Web/ErrorPermission.cshtml")); }
public ActionResult DeleteConfirmed(int id) { accounts accounts = db.accounts.Find(id); db.accounts.Remove(accounts); db.SaveChanges(); return(RedirectToAction("Index")); }
public Account GetById(int id) { accounts accountDB = ctx.accounts.Where(x => x.id == id).FirstOrDefault(); Account account = Map(accountDB); return(account); }
public Account GetByAccountNumber(int accountNumber) { accounts accountDB = ctx.accounts.Where(x => x.account_number == accountNumber).FirstOrDefault(); Account account = Map(accountDB); return(account); }
public IActionResult Create(accounts account) { if (HttpContext.Session.GetString("accRole").Equals("Admin")) { try { var id = db.accounts.FirstOrDefault(item => item.Account_id.Equals(account.Account_id)); var phone = db.accounts.FirstOrDefault(item => item.Account_phone.Equals(account.Account_phone)); var email = db.accounts.FirstOrDefault(item => item.Account_email.Equals(account.Account_email)); if (id == null && phone == null && email == null) { if (ModelState.IsValid) { var PasswordMd5 = Encryptor.GetMd5Hash(account.Account_password); account.Account_password = PasswordMd5; db.accounts.Add(account); db.SaveChanges(); return(RedirectToAction("Index", "Accounts")); } else { ViewBag.Msg = "Model State is invalid!"; } } if (id != null) { ViewBag.Msg = "This account id has already existed!"; } if (phone != null) { ViewBag.Msg = "This account phone has already existed!"; } if (email != null && !email.Equals("*****@*****.**")) { ViewBag.Msg = "This account email has already existed!"; } if (HttpContext.Session.GetString("accRole").Equals("Technician")) { return(View(@"~/Views/Admin/Orders.cshtml")); } return(View(@"~/Views/Admin/accounts/Create.cshtml")); } catch (Exception ex) { ModelState.AddModelError("Error: ", ex.Message); } } return(View(@"~/Views/Admin/ErrorPemission.cshtml")); }
private void FieldMap(Account account, accounts accountDB) { accountDB.customer_id = account.Customer.Id; accountDB.account_number = account.AccountNumber; accountDB.broker_id = account.Broker.Id; accountDB.balance = account.Balance; accountDB.name = account.Name; accountDB.generic_s_number = account.GenericAccountNumber; }
public static void ReadAreas(accounts acc, String usrHash) { if (Service.IService != null) { getAreasResponse areaResponse = null; try { //faz a leitura das areas areaResponse = Service.IService.getAreas(new getAreasRequest(usrHash)); } catch { areaResponse = null; } if (areaResponse != null) { //leitura feita corretamente area docRecent = new area(); docRecent.active = true; docRecent.edit = true; docRecent.nome = "Arquivos recentes"; docRecent.id = DOC_RECENT_ID; Addin.Areas.Add(docRecent); area[] areas = areaResponse.@return; if (areas != null && areas.Length > 0) { var condition = areas.Where(a => a.nome != null && !String.IsNullOrEmpty(a.nome.TrimStart().TrimEnd()) && a.active); if (condition != null) { Addin.Areas.AddRange(condition); for (Int32 i = 0; i < Addin.Areas.Count; i++) { //coloca a area privada na MY_ACCOUNT_POS da array if (Addin.Areas[i].id == MY_ACCOUNT_ID && i != MY_ACCOUNT_POS) { area aux = Addin.Areas[MY_ACCOUNT_POS]; Addin.Areas[MY_ACCOUNT_POS] = Addin.Areas[i]; Addin.Areas[i] = aux; } } area trash = new area(); trash.active = true; trash.edit = true; trash.nome = "Lixeira"; trash.id = TRASH_ID; Addin.Areas.Add(trash); } } } } }
public ActionResult Edit([Bind(Include = "account_id,customer_id,balance")] accounts accounts) { if (ModelState.IsValid) { db.Entry(accounts).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.customer_id = new SelectList(db.customers, "customer_id", "full_name", accounts.customer_id); return(View(accounts)); }
public IActionResult Update(accounts account) { if (HttpContext.Session.GetString("accRole").Equals("Admin")) { try { var result = db.accounts.Find(account.Account_id); var phone = db.accounts.FirstOrDefault(item => item.Account_phone.Equals(account.Account_phone)); var email = db.accounts.FirstOrDefault(item => item.Account_email.Equals(account.Account_email)); if (phone != null && account.Account_phone != result.Account_phone) { ViewBag.Msg = "This account phone has already existed!"; return(View(@"~/Views/Admin/accounts/Update.cshtml", result)); } if (email != null && account.Account_email != result.Account_email) { ViewBag.Msg = "This account phone has already existed!"; return(View(@"~/Views/Admin/accounts/Update.cshtml", result)); } var PasswordMd5 = Encryptor.GetMd5Hash(account.Account_password); if (ModelState.IsValid) { result.Account_name = account.Account_name; result.Account_password = PasswordMd5; result.Account_role = account.Account_role; result.Account_phone = account.Account_phone; result.Account_address = account.Account_address; result.Account_status = account.Account_status; db.SaveChanges(); return(RedirectToAction("Index", "Accounts")); } else { ViewBag.Msg = "Model State is invalid!"; } return(View(@"~/Views/Admin/accounts/Update.cshtml", result)); } catch (Exception ex) { ModelState.AddModelError("Error: ", ex.Message); } } return(View(@"~/Views/Admin/ErrorPemission.cshtml")); }
// GET: Account/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } accounts accounts = db.accounts.Find(id); if (accounts == null) { return(HttpNotFound()); } return(View(accounts)); }
protected void BtnSubmit_Click(object sender, EventArgs e) { using (var db = new CstwebEntities()) { int id = Convert.ToInt16(Session["teacherid"].ToString()); accounts ac = db.accounts.FirstOrDefault(a => a.teacherid == id); if (PasswordHash.PasswordHash.ValidatePassword(TxtOldPw.Text, ac.password)) { string str = PasswordHash.PasswordHash.CreateHash(NewPw1.Text); ac.password = str; db.SaveChanges(); Response.Write("<script>alert('修改成功')</script>"); } } }
// GET: Account/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } accounts accounts = db.accounts.Find(id); if (accounts == null) { return(HttpNotFound()); } ViewBag.customer_id = new SelectList(db.customers, "customer_id", "full_name", accounts.customer_id); return(View(accounts)); }
public void Persist(Account account) { //Insert if (account.Id == 0) { accounts accountDB = Map(account); ctx.accounts.AddObject(accountDB); ctx.SaveChanges(); account.Id = accountDB.id; } else { Update(account); } }
public async Task <IActionResult> Postaccounts([FromBody] accountModel ac) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } var accounts = new accounts(); accounts.account_number = CHIS.Core.Infrastructure.AccountGenerator.Generate(10); accounts.account_type_id = int.Parse(ac.account_type_id); accounts.address1 = ac.address1; accounts.address2 = ac.address2; accounts.alias = ""; accounts.card_holder = ""; accounts.card_number = ""; accounts.city = ac.city; accounts.country = ac.country; accounts.created = DateTime.Now; accounts.created_by = ""; accounts.created_on = DateTime.Now; accounts.credit_card_type = ""; accounts.credit_limit = decimal.Parse(ac.credit_limit); accounts.email = ac.email; accounts.exp_date = DateTime.Now; accounts.fax = ac.fax; accounts.first_name = ac.first_name; accounts.group_name = ac.group_name; accounts.hotel_representative_id = int.Parse(ac.hotel_representative_id); accounts.last_name = ac.last_name; accounts.modified = DateTime.Now; accounts.opening_balance = 0M; accounts.payment_term = 0M; accounts.phone = ac.phone; accounts.postal_code = ac.postal_code; accounts.reg_number = ""; accounts.reg_number1 = ""; accounts.reg_number2 = ""; accounts.remark = ac.remark; accounts.state = ac.state; _context.accounts.Add(accounts); await _context.SaveChangesAsync(); return(CreatedAtAction("Getaccounts", new { id = accounts.id }, accounts)); }
protected void BtnSubmit_Click(object sender, EventArgs e) { if (TxtAccount.Text.Trim() == "") { Response.Write("<script>alert('用户名不能为空')</script>"); } else if (TxtPassword.Text.Trim() == "") { Response.Write("<script>alert('密码不能为空')</script>"); } else { using (var db = new CstwebEntities()) { try { accounts ac = db.accounts.FirstOrDefault(a => a.account == TxtAccount.Text.Trim()); if (PasswordHash.PasswordHash.ValidatePassword(TxtPassword.Text.Trim(), ac.password)) { if (ac.accountlevel == 0) { Session["admin"] = ac.id; Response.Write("<script language=javascript>window.location = 'index.aspx';</script>"); } else if (ac.accountlevel == 1) { Session["teacherid"] = ac.teacherid; Response.Write("<script language=javascript>window.location = 'index2.aspx';</script>"); } else { Response.Write("<script>alert(用户名或密码错误)</script>"); } } else { Response.Write("<script>alert('用户名或密码错误')</script>"); } } catch { Response.Write("<script>alert('用户名或密码错误')</script>"); } } } }
public async Task <IActionResult> Postaccounts([FromBody] accounts accounts) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } accounts a = accounts; // string mySalt = BCrypt.Net.BCrypt.GenerateSalt(); // a.password = BCrypt.Net.BCrypt.HashPassword(accounts.password, mySalt); _context.fcocaccounts.Add(a); await _context.SaveChangesAsync(); return(CreatedAtAction("Getaccounts", new { id = accounts.accountid }, accounts)); }
internal static void persistAccount(Account conta, EntityState entityState, ZeusDataSource _transaction) { accounts obj = new accounts { BLOKED = conta.BLOKED, EMAIL = conta.EMAIL, GROUPID = conta.GROUPID, ID = conta.ID, KEY = conta.KEY, LASTDAY = conta.LASTDAY, NAME = conta.NAME, PASSWORD = conta.PASSWORD, PREMDAYS = conta.PREMDAYS, WARNINGS = conta.WARNINGS }; _transaction.Entry <accounts>(obj).State = entityState; }
static void CreateAccount() { using (UnitOfWork work = new UnitOfWork(new hotel_dbContext())) { var account = new accounts() { account_number = "test", account_type_id = 1, address1 = "Test", address2 = "test", alias = "", card_holder = "", card_number = "", city = "", country = "", created = DateTime.Now, created_by = "", created_on = DateTime.Now, credit_card_type = "", credit_limit = 500, postal_code = "", email = "", exp_date = DateTime.Now, fax = "", first_name = "", last_name = "", opening_balance = 0, modified = DateTime.Now, payment_term = 0, phone = "", reg_number = "", reg_number1 = "", reg_number2 = "", remark = "", state = "" }; work.Accounts.Add(account); work.Complete(); } }
private void FieldMap(accounts accountDB, Account account) { account.Customer = new Customer() { Id = accountDB.customers.Id, DocumentType = accountDB.customers.document_type, DocumentNumber = accountDB.customers.document_number, FirstName = accountDB.customers.first_name, LastName = accountDB.customers.last_name }; account.AccountNumber = accountDB.account_number; account.Broker = new Broker() { Id = accountDB.brokers.id, Code = accountDB.brokers.code, Name = accountDB.brokers.name }; account.Id = accountDB.id; account.Name = accountDB.name; account.GenericAccountNumber = accountDB.generic_s_number; }
public override void Save() { if (IsEmpty() == false) { return; } else { var db = new SalesDataContext(); accounts Account; if (Cust_Supp.id == 0) { Action = "Insert"; db.customers_suppliers.InsertOnSubmit(Cust_Supp); Account = new accounts(); db.accounts.InsertOnSubmit(Account); } else { Action = "Update"; db.customers_suppliers.Attach(Cust_Supp); Account = db.accounts.First(S => S.id == Cust_Supp.account_id); } SetData(); Account.name = Cust_Supp.name; //db.SubmitChanges(); Cust_Supp.account_id = Account.id; db.SubmitChanges(); //Txt_Name.Text = string.Empty; //Txt_Address.Text = string.Empty; //Txt_Mobile.Text = string.Empty; //Txt_Email.Text = string.Empty; //Txt_Name.Focus(); base.Save(); } }
public IActionResult post_reservations([FromBody] Posted_Data data) { var bookingForm = data.bookingForm; var userForm = data.userForm; var businessForm = data.businessForm; var rooms = data.rms; var paymentForm = data.paymentForm; var userId = int.Parse(userForm.id); accounts ac = null; if (userId > 0) { ac = _context.accounts.Where(a => a.id == userId).FirstOrDefault(); ac.address1 = userForm.address1; ac.address2 = userForm.address2; ac.city = userForm.city; ac.country = userForm.country; ac.email = userForm.email; ac.fax = userForm.fax; ac.first_name = userForm.first_name; ac.last_name = userForm.last_name; ac.phone = userForm.phone; ac.postal_code = userForm.postal_code; ac.state = userForm.state; _context.SaveChanges(); } else { ac = new accounts(); ac.account_number = CHIS.Core.Infrastructure.AccountGenerator.Generate(10); var account_type = _context.account_types.Select(a => a).OrderBy(a => a.id).FirstOrDefault(); if (account_type != null) { ac.account_type_id = account_type.id; } ac.address1 = userForm.address1; ac.address2 = userForm.address2; ac.alias = "AC"; ac.card_holder = ""; ac.city = userForm.city; ac.country = userForm.country; ac.created = DateTime.Now; ac.created_by = "1"; ac.created_on = DateTime.Now; ac.credit_card_type = ""; ac.credit_limit = 500M; ac.email = userForm.email; ac.exp_date = DateTime.Now; ac.fax = userForm.fax; ac.first_name = userForm.first_name; ac.last_name = userForm.last_name; ac.modified = DateTime.Now; ac.opening_balance = 0M; ac.payment_term = 0M; ac.phone = userForm.phone; ac.postal_code = userForm.postal_code; ac.reg_number = ""; ac.reg_number1 = ""; ac.reg_number2 = ""; ac.remark = ""; ac.state = userForm.state; _context.accounts.Add(ac); _context.SaveChanges(); } var rs = new reservations(); rs.account_id = ac.id; var arrival_string = bookingForm.arrival.Split("/"); var new_arrival_date = String.Format("{0}-{1}-{2}", arrival_string[2], arrival_string[0], arrival_string[1]); rs.arrival = DateTime.Parse(new_arrival_date); rs.book_by = bookingForm.book_by; rs.book_on = DateTime.Now; rs.business_source_id = int.Parse(businessForm.business_source_id); rs.code = Guid.NewGuid().ToString(); rs.created = DateTime.Now; rs.departure = rs.arrival.Value.AddDays(int.Parse(bookingForm.num_of_night)); rs.modified = DateTime.Now; rs.num_of_night = int.Parse(bookingForm.num_of_night); rs.reservation_number = CHIS.Core.Infrastructure.AccountGenerator.Generate(8); rs.reservation_status = "Reserved"; rs.account_number = paymentForm.account_number; var onDiscounts = Boolean.Parse(paymentForm.apply_discount); if (onDiscounts) { rs.apply_discount = 1; rs.discount_code = paymentForm.discount_code; rs.discount_plan = int.Parse(paymentForm.discount_plan); rs.discount_value = Decimal.Parse(paymentForm.discount_value); } else { rs.apply_discount = 0; rs.discount_code = ""; //rs.discount_plan = 0; rs.discount_value = 0M; } rs.bank_name = paymentForm.bank_name; rs.branch_name = paymentForm.branch_name; rs.cheque = paymentForm.cheque; rs.amount_paid = Decimal.Parse(paymentForm.amount); rs.balance = Decimal.Parse(paymentForm.balance); rs.total_booking = Decimal.Parse(paymentForm.total_amount); rs.payment_status = "incomplete"; rs.last_payment_id = 0; _context.reservations.Add(rs); _context.SaveChanges(); foreach (var room in rooms) { var dd = new reserved_rooms(); dd.arrival = rs.arrival; dd.balance = Decimal.Parse(paymentForm.balance); dd.created = rs.created; dd.departure = DateTime.Now; dd.modified = DateTime.Now; dd.num_of_night = rs.num_of_night; dd.original_owner = ac.first_name + " " + ac.last_name; dd.paid = Decimal.Parse(paymentForm.amount); dd.reservation_id = rs.id; dd.modified = DateTime.Now; dd.reserved_status = "Reserved"; dd.room_id = int.Parse(room.id); dd.room_type_id = int.Parse(room.room_type_id); dd.serial_number = CHIS.Core.Infrastructure.AccountGenerator.Generate(8); dd.status = "Open"; dd.total = Decimal.Parse(paymentForm.total_amount); dd.transfer_owner = ""; dd.num_of_night = rs.num_of_night; dd.num_of_adult = int.Parse(room.extra_adult); dd.num_of_children = int.Parse(room.extra_children); dd.room_name = room.room_name; dd.room_type_name = room.room_type_name; _context.reserved_rooms.Add(dd); _context.SaveChanges(); rs.reserved_rooms.Add(dd); } foreach (var rr in rs.reserved_rooms) { for (int i = 0; i < rs.num_of_night; i++) { var tran = new reservation_transaction(); var rate = getRoomRate(rs.arrival.Value.AddDays(i), rr.room_type_id); tran.total_reservation = rate.amount.Value; tran.total_children = rr.num_of_children * rate.extra_child; tran.total_adult = rr.num_of_adult * rate.extra_adult; tran.total = tran.total_adult + tran.total_children + tran.total_reservation; tran.balance = tran.total; tran.created = DateTime.Now; tran.modified = DateTime.Now; tran.paid = Decimal.Parse(paymentForm.amount); tran.rate = rate.amount; tran.reservation_id = rs.id; tran.reserved_room_id = rr.id; tran.status = "Reserved"; tran.transaction_date = rs.arrival.Value.AddDays(i); tran.rate_type = _context.rate_types.Where(a => a.id == rate.rate_type_id).FirstOrDefault().rate_type_name; tran.rate_name = rate.rate_name; tran.payment_method = paymentForm.payment_method; tran.room_name = rr.room_name; tran.room_Type = rr.room_type_name; _context.reservation_transaction.Add(tran); _context.SaveChanges(); rs.reservation_transaction.Add(tran); } } reservation_payments payment = new reservation_payments(); payment.created = DateTime.Now; payment.modified = DateTime.Now; payment.paid = Decimal.Parse(paymentForm.amount); payment.payment_method = paymentForm.payment_method; payment.reservation_id = rs.id; payment.status = ""; payment.total_amount = Decimal.Parse(paymentForm.total_amount); payment.transaction_date = DateTime.Now; payment.transaction_type = "Reservation Payment"; payment.balance = Decimal.Parse(paymentForm.balance); var apply_discount = Boolean.Parse(paymentForm.apply_discount); if (apply_discount) { payment.on_discount = 1; var discount = 0M; decimal.TryParse(paymentForm.discount_value, out discount); payment.discount_value = discount; var discount_id = int.Parse(paymentForm.discount_plan); var MainDiscount = _context.discount_plans.Where(a => a.id == discount_id).FirstOrDefault(); payment.discount_name = MainDiscount.plan_name; if (MainDiscount.plan_category.Trim() == "c100") { var discount2 = (payment.discount_value / 100M) * payment.total_amount; payment.total_amount_with_discount = payment.total_amount.Value - discount2.Value; payment.balance = payment.total_amount_with_discount - payment.paid; rs.discount_amount = discount2.Value; } else { var amount = payment.total_amount - payment.discount_value; payment.total_amount_with_discount = amount.Value; payment.balance = payment.total_amount_with_discount - payment.paid; rs.discount_amount = payment.discount_value; } } else { payment.on_discount = 0; payment.discount_name = ""; payment.discount_type = 0; payment.discount_value = 0; payment.total_amount_with_discount = 0M; } _context.reservation_payments.Add(payment); _context.SaveChanges(); rs.total_amount_with_discount = payment.total_amount_with_discount; rs.balance = payment.balance; rs.last_payment_id = payment.id; if (rs.balance <= 0) { rs.payment_status = "Completed"; } else { rs.payment_status = "Incomplete"; } _context.SaveChanges(); rs = _context.reservations.Where(a => a.id == rs.id).Include(a => a.account_).Include(a => a.reservation_payments).Include(a => a.reserved_rooms).FirstOrDefault(); return(Ok(rs)); }
public static void ReadAreas(accounts acc) { String usrHash = Util.Crypto.Encrypt(acc.id.ToString()); ReadAreas(acc, usrHash); }
protected void BtnSubmit_Click(object sender, EventArgs e) { if (Txtname.Text.Trim() == "") Response.Write("<script>alert('姓名不能为空')</script>"); else if (TxtMail.Text.Trim() == "") Response.Write("<script>alert('邮箱不能为空')</script>"); else if (TxtOffice.Text.Trim() == "") Response.Write("<script>alert('办公室地址不能为空')</script>"); else if (TxtPhone.Text.Trim() == "") Response.Write("<script>alert('办公室电话不能为空')</script>"); else if (Txtfield.Text.Trim() == "") Response.Write("<script>alert('研究领域不能为空')</script>"); else if (TxtCourse.Text.Trim() == "") Response.Write("<script>alert('教授课程不能为空')</script>"); else if (TxtID.Text.Trim() == "") Response.Write("<script>alert('教工号不能为空')</script>"); else using (var db = new CstwebEntities()) { try { if (teaid == 0) { var tea = new teachers(); tea.name = Txtname.Text.Trim(); tea.mail = TxtMail.Text.Trim(); tea.office = TxtOffice.Text.Trim(); tea.photo = ImgIco.ImageUrl.ToString(); tea.phone = TxtPhone.Text.Trim(); tea.field = Txtfield.Text.Trim(); tea.course = TxtCourse.Text.Trim(); int i = Convert.ToInt32(DDLLevel.SelectedValue); tea.teacherlevel = i; i = Convert.ToInt32(DDLTitle.SelectedValue); tea.title = i; if (Txtetc.Text.Trim() != "") tea.etc = strp(Txtetc.Text.Trim()); if (TxtHome.Text.Trim() != "") tea.home = TxtHome.Text.Trim(); if (TxtStudy.Text.Trim() != "") tea.education = strp(TxtStudy.Text.Trim()); if (TxtReward.Text.Trim() != "") tea.reward = strp(TxtReward.Text.Trim()); if (TxtPartjob.Text.Trim() != "") tea.parttimejob = strp(TxtPartjob.Text.Trim()); if (TxtPaper.Text.Trim() != "") tea.paper = strp(TxtPaper.Text.Trim()); if (TxtProject.Text.Trim() != "") tea.project = strp(TxtProject.Text.Trim()); tea.time = System.DateTime.Now; db.teachers.Add(tea); db.SaveChanges(); var id1 = db.teachers.FirstOrDefault(a => a.name == Txtname.Text.Trim()).id; accounts ac = new accounts(); ac.account = TxtID.Text.Trim(); ac.password = PasswordHash.PasswordHash.CreateHash(TxtID.Text.Trim()); ac.teacherid = id1; ac.accountlevel = 1; db.accounts.Add(ac); db.SaveChanges(); Response.Write("<script language=javascript>alert('添加成功');window.location = 'teachers.aspx';</script>"); } else { teachers tea = db.teachers.First<teachers>(a => a.id == teaid); tea.name = Txtname.Text.Trim(); tea.mail = TxtMail.Text.Trim(); tea.office = TxtOffice.Text.Trim(); tea.photo = ImgIco.ImageUrl.ToString(); tea.phone = TxtPhone.Text.Trim(); tea.field = Txtfield.Text.Trim(); tea.course = TxtCourse.Text.Trim(); int i = Convert.ToInt32(DDLLevel.SelectedValue); tea.teacherlevel = i; i = Convert.ToInt32(DDLTitle.SelectedValue); tea.title = i; if (Txtetc.Text.Trim() != "") tea.etc = strp(Txtetc.Text.Trim()); //else tea.etc = null; if (TxtHome.Text.Trim() != "") tea.home = TxtHome.Text.Trim(); //else tea.home = null; if (TxtStudy.Text.Trim() != "") tea.education = strp(TxtStudy.Text.Trim()); //else tea.education = null; if (TxtReward.Text.Trim() != "") tea.reward = strp(TxtReward.Text.Trim()); //else tea.reward = null; if (TxtPartjob.Text.Trim() != "") tea.parttimejob = strp(TxtPartjob.Text.Trim()); //else tea.parttimejob = null; if (TxtPaper.Text.Trim() != "") tea.paper = strp(TxtPaper.Text.Trim()); //else tea.paper = null; if (TxtProject.Text.Trim() != "") tea.project = strp(TxtProject.Text.Trim()); //else tea.project = null; tea.time = System.DateTime.Now; db.SaveChanges(); Response.Write("<script language=javascript>alert('修改成功');window.location = 'teachers.aspx';</script>"); } } catch { Response.Write("<script>alert('失败')</script>"); } } }