private void loadID() { ChiTietSuDung lastDV = db.ChiTietSuDungs.OrderByDescending(x => x.MaCTSD).FirstOrDefault(); string lastID = lastDV != null ? lastDV.MaCTSD : ""; string nextID = IdGenerate.genId(lastID, "CTSD"); txtMaCTSD.Text = nextID; }
private void dgvCTSD_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { btnEnd.Enabled = true; btnStart.Enabled = false; btnTinhtien.Enabled = false; currentCTSD = (dgvCTSD.DataSource as List <ChiTietSuDung>).Skip(e.RowIndex).FirstOrDefault(); bindToTextbox(); }
public ActionResult DeleteConfirmed(int id) { ChiTietSuDung chiTietSuDung = db.ChiTietSuDungs.Find(id); db.ChiTietSuDungs.Remove(chiTietSuDung); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "ID,IDSIM,TGBD,TGKT,SoPhutSD7h23h,SoPhutSD23h7h")] ChiTietSuDung chiTietSuDung) { if (ModelState.IsValid) { db.Entry(chiTietSuDung).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.IDSIM = new SelectList(db.ThongTinSIMs, "IDSIM", "SoDienThoai", chiTietSuDung.IDSIM); return(View(chiTietSuDung)); }
// GET: ChiTietSuDungs/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ChiTietSuDung chiTietSuDung = db.ChiTietSuDungs.Find(id); if (chiTietSuDung == null) { return(HttpNotFound()); } return(View(chiTietSuDung)); }
// GET: ChiTietSuDungs/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ChiTietSuDung chiTietSuDung = db.ChiTietSuDungs.Find(id); if (chiTietSuDung == null) { return(HttpNotFound()); } ViewBag.IDSIM = new SelectList(db.ThongTinSIMs, "IDSIM", "SoDienThoai", chiTietSuDung.IDSIM); return(View(chiTietSuDung)); }
private void Insert_Click(object sender, EventArgs e) { List <ChiTietSuDung> ctsd = (from chitiet in db.ChiTietSuDung select chitiet).ToList(); db.ChiTietSuDung.RemoveRange(ctsd); db.SaveChanges(); OpenFileDialog open = new OpenFileDialog(); open.Title = "Chọn file Log để lưu vào CSDL"; open.Filter = "TXT files|*.txt"; open.InitialDirectory = @"../../../"; if (open.ShowDialog() == DialogResult.OK) { string filename = open.FileName; string[] fileContent = File.ReadAllLines(filename); string[] columns = null; foreach (string dataLine in fileContent) { if (dataLine.Equals("")) { continue; } else { columns = dataLine.Split('|'); for (int i = 0; i < columns.Length; i++) { columns[i] = columns[i].Replace("\t", ""); } var chitiet = new ChiTietSuDung(); chitiet.MaChiTiet = dal.AutoID(); chitiet.IDSIM = columns[0].ToString(); chitiet.TGBD = Convert.ToDateTime(columns[1]); chitiet.TGKT = Convert.ToDateTime(columns[2]); chitiet.SoPhutSD = CalculateMinutes(Convert.ToDateTime(chitiet.TGBD), Convert.ToDateTime(chitiet.TGKT)); int fee1minutes = 0; int fee2minutes = 0; CalculateFeeMinutes(Convert.ToDateTime(chitiet.TGBD), Convert.ToDateTime(chitiet.TGKT), ref fee1minutes, ref fee2minutes); decimal price1 = Convert.ToDecimal((from gia in db.GiaCuoc where gia.MaGiaCuoc == "GC01" select gia.Gia).FirstOrDefault()); decimal price2 = Convert.ToDecimal((from gia in db.GiaCuoc where gia.MaGiaCuoc == "GC02" select gia.Gia).FirstOrDefault()); decimal fee1 = fee1minutes * price1; decimal fee2 = fee2minutes * price2; chitiet.PhiCuocGoi = fee1 + fee2; chitiet.Flag = true; db.ChiTietSuDung.Add(chitiet); db.SaveChanges(); } } MessageBox.Show("Lưu dữ liệu thành công!\nFile log: " + open.FileName, "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } else { // Do nothing } }