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