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
}
}
