public IActionResult Update(bills Bill)
{
if (HttpContext.Session.GetString("accRole").Equals("Admin") || HttpContext.Session.GetString("accRole").Equals("Accountant"))
{
try
{
var result = db.bills.FirstOrDefault(item => item.Bill_id.Equals(Bill.Bill_id));
if (ModelState.IsValid)
{
result.Bill_status = Bill.Bill_status;
db.SaveChanges();
return(RedirectToAction("Index", "Bills"));
}
else
{
ViewBag.Msg = "Model State is invalid!";
}
return(View(@"~/Views/Admin/Bills/Update.cshtml", result));
}
catch (Exception ex)
{
ModelState.AddModelError("Error: ", ex.Message);
}
}
return(View(@"~/Views/Admin/ErrorPemission.cshtml"));
}
// GET: bills
public ActionResult Index()
{
int iid = Convert.ToInt16(Session["Hid"]);
List <bills> bil = db.bill.ToList().FindAll(x => x.homeid == iid);
LogicClass lg = new LogicClass();
if (bil.Count().Equals(0))
{
bills b = new bills();
b.homeid = iid;
b.waterCost = Math.Round(lg.getRandom(500, 1000), 2, MidpointRounding.AwayFromZero);
b.electricCost = Math.Round(lg.getRandom(500, 15000), 2, MidpointRounding.AwayFromZero);
db.bill.Add(b);
db.SaveChanges();
List <bills> bi = db.bill.ToList().FindAll(x => x.homeid == iid);
return(View(bi));
}
foreach (var item in bil)
{
if (item.waterCost.Equals(0) && item.electricCost.Equals(0))
{
item.electricCost = Math.Round(lg.getRandom(500, 1000), 2, MidpointRounding.AwayFromZero);
item.waterCost = Math.Round(lg.getRandom(500, 1500), 2, MidpointRounding.AwayFromZero);
db.SaveChanges();
}
}
return(View(bil));
}
// Hiển thị danh sách hóa đơn đã thanh toán
public List <bills> getBills1()
{
List <bills> li = new List <bills>();
string sql = "Select * From bills, schedules where bills.schedule_id=schedules.schedule_id AND bill_status=1 ORDER BY bill_id DESC";
con.Open();
SqlCommand cmd = new SqlCommand(sql, con);
SqlDataReader rd = cmd.ExecuteReader();
while (rd.Read())
{
bills bill = new bills();
bill.bill_id = (int)rd["bill_id"];
bill.schedule_id = (int)rd["schedule_id"];
bill.num_day = (int)rd["num_day"];
bill.price_room = Convert.ToInt32(rd["price_room"]);
bill.price_service = Convert.ToInt32(rd["price_service"]);
bill.total_price = Convert.ToInt32(rd["total_price"]);
bill.bill_status = (Boolean)rd["bill_status"];
bill.fullname = (string)rd["fullname"];
bill.phone = (string)rd["phone"];
li.Add(bill);
}
con.Close();
return(li);
}
public ActionResult DeleteConfirmed(int id)
{
bills bills = db.bill.Find(id);
db.bill.Remove(bills);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public IActionResult Create(bills bill)
{
if (HttpContext.Session.GetString("accRole").Equals("Admin") || HttpContext.Session.GetString("accRole").Equals("Accountant"))
{
try
{
if (bill.Bill_order_id != null)
{
var order = db.orders.Find(bill.Bill_order_id);
var orderStatus = order.Order_status;
if (!orderStatus.Equals("Complete"))
{
ViewBag.Msg = "You cannot invoice when the order is not completed";
return(View(@"~/Views/Admin/Bills/Create.cshtml"));
}
else
{
order.Order_status = "Billed";
}
}
if (bill.Bill_track_id != null)
{
var track = db.tracks.Find(bill.Bill_track_id);
var trackStatus = track.Track_status;
if (!trackStatus.Equals("Complete"))
{
ViewBag.Msg = "You cannot invoice when the track is not completed";
return(View(@"~/Views/Admin/Bills/Create.cshtml"));
}
else
{
track.Track_status = "Billed";
}
}
bill.Bill_status = "Unpaid";
db.bills.Add(bill);
db.SaveChanges();
return(RedirectToAction("Index", "Bills"));
}
catch (Exception ex)
{
ModelState.AddModelError("Error: ", ex.Message);
}
}
return(View(@"~/Views/Admin/ErrorPemission.cshtml"));
}
public ActionResult Edit([Bind(Include = "billid,homeid,waterCost,electricCost")] bills bills)
{
if (ModelState.IsValid)
{
db.Entry(bills).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.homeid = new SelectList(db.residents, "homeid", "citytown", bills.homeid);
return(View(bills));
}
public ActionResult Edit(bills bills)
{
if (ModelState.IsValid)
{
db.Entry(bills).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.currunciesId = new SelectList(db.curruncies, "id", "nameUnit", bills.currunciesId);
return(View(bills));
}
public ActionResult Create(bills bills)
{
if (ModelState.IsValid)
{
db.bills.Add(bills);
db.SaveChanges();
Session["idBill"] = bills.id;
return(RedirectToAction("Create", "items"));
}
ViewBag.currunciesId = new SelectList(db.curruncies, "id", "nameUnit", bills.currunciesId);
return(View(bills));
}
// GET: bills/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
bills bills = db.bill.Find(id);
if (bills == null)
{
return(HttpNotFound());
}
return(View(bills));
}
// GET: bills/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
bills bills = db.bills.Find(id);
if (bills == null)
{
return(HttpNotFound());
}
ViewBag.currunciesId = new SelectList(db.curruncies, "id", "nameUnit", bills.currunciesId);
return(View(bills));
}
private void paybill_Click(object sender, EventArgs e)
{
try
{
acctFrom = Convert.ToInt64(t4acct.Text);
account a = acct.Find(i => i.accountID == acctFrom);
bills b = (bills)billlist.SelectedItem;
a.balance -= b.amnt;
label12.Text = "Account updated! From " + (a.balance + b.amnt) + " to " + a.balance;
}
catch
{
billamnt.Text = "";
}
}
// GET: bills/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
bills bills = db.bill.Find(id);
if (bills == null)
{
return(HttpNotFound());
}
ViewBag.homeid = new SelectList(db.residents, "homeid", "citytown", bills.homeid);
return(View(bills));
}
public async Task <bool> UpdateAsync(bills bill)
{
var result = await fsql.Update <bills>()
.Set(a => a.billtypeid, bill.billtypeid)
.Set(a => a.isout, bill.isout)
.Set(a => a.moneys, bill.moneys)
.Set(a => a.moneydate, bill.moneydate)
.Set(a => a.moneyyear, bill.moneyyear)
.Set(a => a.moneymonth, bill.moneymonth)
.Set(a => a.moneyday, bill.moneyday)
.Set(a => a.memo, bill.memo)
.Set(a => a.updatedate, bill.updatedate)
.Where(it => it.ids == bill.ids)
.ExecuteAffrowsAsync();
return(result > 0);
}
/// <summary>
/// Add bill information
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button3_Click(object sender, RoutedEventArgs e)
{
if (amountBox.Text.Trim().Length > 0)
{
if (parent.Dbstate.Equals("Open"))
{
parent.query("insert into bills (amount,date,patientid,doctorid) values('" + parent.clean(amountBox.Text) + "',now()," + patientid + "," + subparent.DoctorId + ")");
bills _bill = new bills();
_bill.amount = amountBox.Text.Trim();
_bill.date = DateTime.Now.ToLocalTime().ToString();
_bill.doctor = doc_name;
listView1.Items.Add(_bill);
MessageBox.Show("Bill added", "TeleMedicine", MessageBoxButton.OK, MessageBoxImage.Information);
}
}
}
public async Task <ServiceResult <string> > update([FromBody] BillDto billDto)
{
var result = new ServiceResult <string>()
{
Result = string.Empty
};
bills _bill = this.mapper.Map <BillDto, bills>(billDto, opt => opt.Items[Constant.mobilename] = base.UserMobile);
bool bl = await this.Ibill.UpdateAsync(_bill);
if (!bl)
{
result.IsFailed("保存失败");
return(result);
}
return(result);
}
// GET: bills/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
bills bills = db.bills.Find(id);
//var bills = from a in db.bills
// join b in db.items
// on a.id equals b.billsId
// where a.id==id
// select a;
if (bills == null)
{
return(HttpNotFound());
}
return(View(bills));
}
public bool Save(bills bill)
{
var ids = fsql.Insert(bill).ExecuteAffrows();
return(ids > 0);
}
public async Task <bool> SaveAsync(bills bill)
{
var ids = await fsql.Insert(bill).ExecuteAffrowsAsync();
return(ids > 0);
}
/// <summary>
/// Load all information of a patient
/// </summary>
/// <param name="root"></param>
/// <param name="_sub"></param>
/// <param name="id"></param>
/// <param name="category"></param>
public profile(MainWindow root, doctor_frame _sub, int id, string category)
{
parent = root;
patientid = id;
subparent = _sub;
InitializeComponent();
DataTable qry = parent.query("select *,(select photoblob from photo where login_user_id=photo.id) as photo from patient where patientid=" + id);
foreach (DataRow rw in qry.Rows)
{
proPix.Source = parent.getImg((byte[])rw["photo"]);
fullname.Content = rw["lastname"] + " " + rw["firstname"];
patientCode.Content = rw["PCODE"].ToString();
email.Content = rw["email"].ToString();
lastnameBlock.Text = rw["lastname"].ToString();
firstnameBlock.Text = rw["firstname"].ToString();
phoneBlock.Text = rw["phoneno"].ToString();
genderBlock.Text = rw["sex"].ToString();
heightBlock.Text = rw["height"].ToString();
weightBlock.Text = rw["weight"].ToString();
addressBlock.Text = rw["address"].ToString();
bloodgroupBlock.Text = rw["bloodgroup"].ToString();
genotypeBlock.Text = rw["genotype"].ToString();
allergyBlock.Text = rw["allergies"].ToString();
}
qry = parent.query("select scheduleid,patientid, status as attended, schedule.date as schedule, date_added as created from schedule where patientid=" + patientid + " order by schedule desc");
foreach (DataRow rw in qry.Rows)
{
schedule.ScheduleHolder schedule = new schedule.ScheduleHolder();
schedule.ID = int.Parse(rw["scheduleid"].ToString());
schedule.PatientID = int.Parse(rw["patientid"].ToString());
schedule.attended = (rw["attended"].ToString());
schedule.schedule = (rw["schedule"].ToString());
schedule.created = (rw["created"].ToString());
comboBox.Items.Add(rw["schedule"].ToString());
listView0.Items.Add(schedule);
}
qry = parent.query("select concat(lastname,' ',firstname) from doctor where doctorid=" + subparent.DoctorId);
if (qry.Rows.Count > 0)
{
DataRow row = qry.Rows[0];
doc_name = row[0].ToString();
}
qry = parent.query("select *,(select concat(lastname,' ',firstname) from doctor where doctor.doctorid=bills.doctorid) as doctor from bills where patientid=" + patientid);
foreach (DataRow rw in qry.Rows)
{
bills _bill = new bills();
_bill.amount = rw["amount"].ToString();
_bill.date = rw["date"].ToString();
_bill.doctor = rw["doctor"].ToString();
listView1.Items.Add(_bill);
}
if (category.Equals("appointment"))
{
tabControl.SelectedIndex = 4;
}
qry = parent.query("select *,(select concat(lastname,' ',firstname) from doctor where doctor.doctorid=record.doctorid) as doctor from record where patientid=" + id);
foreach (DataRow rw in qry.Rows)
{
id = int.Parse(rw["recordid"].ToString());
string caption = "";
string comment = rw["comment"].ToString();
if (comment.Length > 20)
{
caption = comment.Substring(0, 15) + "...";
}
else
{
caption = comment;
}
addToList(id, rw["doctor"].ToString(), caption, rw["date_added"].ToString());
}
recordCount.Content = qry.Rows.Count + " record(s)";
}
private void button4_Click(object sender, EventArgs e)
{
bills form = new bills();
form.ShowDialog();
}
