private void getGrid1()
{
dsCamDo.tbCamDo.Clear();
gridCamDo.DataSource = null;
Model.camdochieuduongEntities camdochieuduongEntity = new Model.camdochieuduongEntities();
var listGiaoDich = camdochieuduongEntity.GiaoDiches.ToList();
foreach (Model.GiaoDich GD in listGiaoDich)
{
if (GD.Canceled != "X")
{
DataRow dr = dsCamDo.tbCamDo.NewRow();
dr["IDBienNhan"] = GD.IDBienNhan;
dr["KhachHang"] = GD.KhachHang;
dr["NgayCam"] = GD.NgayCam;
dr["MoTa"] = GD.MoTa;
dr["NgayCam"] = GD.NgayCam;
dr["DienThoai"] = GD.DienThoai;
dr["TruHotCon"] = GD.TruHotCon;
dr["TienCam"] = GD.TienCam;
dr["GiaTri"] = GD.GiaTri;
dr["InBienNhan"] = GD.InBienNhan;
dsCamDo.tbCamDo.Rows.Add(dr);
gridCamDo.DataSource = dsCamDo.tbCamDo;
}
}
}
private void btntgChuoc_Click(object sender, EventArgs e)
{
setDisable();
//Loop through all row
for (int i = 0; i < gridView2.DataRowCount; i++)
{
//Check and Update Giao Dich
Model.camdochieuduongEntities camdochieuduongEntity = new Model.camdochieuduongEntities();
Model.GiaoDich GD = camdochieuduongEntity.GiaoDiches.Find(gridView2.GetRowCellValue(i, "IDBienNhan").ToString());
if (GD.DaChuoc == null)
{
//Update Giao Dich Chuoc Do dang lam
GD.DaChuoc = "X";
GD.LoaiGiaoDich = Constants.ChuocDo;
GD.TienLai = Convert.ToInt64(gridView2.GetRowCellValue(i, "TienLai").ToString());
camdochieuduongEntity.SaveChanges();
//Update cac don cu cua don nay
UpdateChuocHistory(gridView2.GetRowCellValue(i, "DonGoc").ToString());
}
else
{
System.Windows.Forms.MessageBox.Show("Lỗi. Đơn này đã chuộc rồi!!");
}
}
setInit();
}
private void GetHistory(string DonGoc)
{
gridtgHistory1.History.Clear();
gridtgHistory.DataSource = null;
Model.camdochieuduongEntities camdochieuduongEntity = new Model.camdochieuduongEntities();
var listGiaoDich = camdochieuduongEntity.GiaoDiches.Where(x => x.DonGoc == DonGoc).ToList();
foreach (Model.GiaoDich GD in listGiaoDich)
{
if (GD.Canceled != "X")
{
DataRow dr = gridtgHistory1.History.NewRow();
dr["IDBienNhan"] = GD.IDBienNhan;
dr["KhachHang"] = GD.KhachHang;
dr["NgayCam"] = GD.NgayCam;
dr["MoTa"] = GD.MoTa;
dr["TienLai"] = GD.TienLai;
dr["TienCam"] = GD.TienCam;
dr["LoaiGiaoDich"] = GD.LoaiGiaoDich;
dr["ThayTheCho"] = GD.ThayTheCho;
gridtgHistory1.History.Rows.Add(dr);
gridtgHistory.DataSource = gridtgHistory1.History;
}
}
}
public void showThuChi()
{
gridThuChi.DataSource = null;
dsThuChi.tbThuChi.Clear();
var fromdate = txttctungay.Value.Date;
var todate = txttcdenngay.Value.AddDays(1).Date;
Model.camdochieuduongEntities camdochieuduongEntity = new Model.camdochieuduongEntities();
var listThuChi = camdochieuduongEntity.ThuChis.Where(x => x.NgayNhap >= fromdate && x.NgayNhap <= todate).ToList();
foreach (Model.ThuChi TC in listThuChi)
{
if (TC.Cancel != "X")
{
DataRow dr = dsThuChi.tbThuChi.NewRow();
dr["MaThuChi"] = TC.MaThuChi;
dr["NgayNhap"] = TC.NgayNhap;
dr["LoaiGiaoDich"] = TC.LoaiGiaoDich;
dr["SoTien"] = TC.SoTien;
dr["MoTa"] = TC.MoTa;
dr["Cancel"] = TC.Cancel;
dsThuChi.tbThuChi.Rows.Add(dr);
}
}
gridThuChi.DataSource = dsThuChi.tbThuChi;
}
public void getKiemHang()
{
gridKiemHang.DataSource = null;
dsKiemHang.tbKiemHang.Clear();
int count = 0;
long sum = 0;
var fromdate = txtkhtungay.Value.Date;
var todate = txtkhdenngay.Value.AddDays(1).Date;
Model.camdochieuduongEntities camdochieuduongEntity = new Model.camdochieuduongEntities();
var listGiaoDich = camdochieuduongEntity.GiaoDiches.Where(x => x.NgayCam >= fromdate && x.NgayCam <= todate).ToList();
foreach (Model.GiaoDich GD in listGiaoDich)
{
if (GD.LoaiGiaoDich == Constants.CamDo && GD.DaChuoc != "X" && GD.Canceled != "X")
{
count++;
sum = sum + Convert.ToInt64(GD.TienCam);
DateTime NgayCam = GD.NgayCam.Value.Date;
DateTime NgayToiHan = NgayCam.AddDays(30);
DateTime currDate = DateTime.Now.Date;
double SoNgay = (currDate - NgayCam).TotalDays + 1;
DataRow dr = dsKiemHang.tbKiemHang.NewRow();
dr["IDBienNhan"] = GD.IDBienNhan;
dr["KhachHang"] = GD.KhachHang;
dr["NgayCam"] = GD.NgayCam;
dr["NgayToiHan"] = NgayToiHan;
dr["SoNgay"] = SoNgay;
dr["LoaiGiaoDich"] = GD.LoaiGiaoDich;
dr["TienCam"] = GD.TienCam;
dr["MoTa"] = GD.MoTa;
dr["DienThoai"] = GD.DienThoai;
double SoTienCam = Convert.ToInt64(GD.TienCam);
double laisuat = 0;
double songayapdung = Convert.ToDouble(txtchsongayapdung.Text);
if (SoTienCam >= 10000000)
{ //Lon hon hoac = 10tr, 2%
laisuat = Convert.ToDouble(txtchlaitren10tr.Text);
}
else
{
laisuat = Convert.ToDouble(txtchlaiduoi10tr.Text);
}
var roundTienLai = Math.Round((SoNgay * SoTienCam * laisuat / 100 / songayapdung / 1000), MidpointRounding.AwayFromZero);
dr["TienLai"] = roundTienLai * 1000;
dsKiemHang.tbKiemHang.Rows.Add(dr);
}
}
gridKiemHang.DataSource = dsKiemHang.tbKiemHang;
txtkhtongsomon.Text = String.Format("{0:n0}", count);
txtkhtongtiencam.Text = String.Format("{0:n0}", sum);
}
private void UpdateChuocHistory(string DonGoc)
{
Model.camdochieuduongEntities camdochieuduongEntity = new Model.camdochieuduongEntities();
var listGiaoDich = camdochieuduongEntity.GiaoDiches.Where(x => x.DonGoc == DonGoc).ToList();
foreach (Model.GiaoDich GD in listGiaoDich)
{
GD.DaChuoc = "X";
camdochieuduongEntity.SaveChanges();
}
}
private void btntgThayGiay_Click(object sender, EventArgs e)
{
setDisable();
//Loop through all row
for (int i = 0; i < gridView2.DataRowCount; i++)
{
//Check and Update Giao Dich
Model.camdochieuduongEntities camdochieuduongEntity = new Model.camdochieuduongEntities();
Model.GiaoDich GD = camdochieuduongEntity.GiaoDiches.Find(gridView2.GetRowCellValue(i, "IDBienNhan").ToString());
if (GD.ThayTheBang == null)
{
//Dang ki ID moi
var IDBienNhanNew = camdochieuduong.Function.myFunction.CreateIDBienNhan();
//Tao Giao Dich Thay giay
camdochieuduong.Function.myFunction.CreateGiaoDich(
IDBienNhanNew,
DateTime.Now.ToString(),
gridView2.GetRowCellValue(i, "KhachHang").ToString(),
gridView2.GetRowCellValue(i, "DienThoai").ToString(),
gridView2.GetRowCellValue(i, "MoTa").ToString(),
gridView2.GetRowCellValue(i, "GiaTri").ToString(),
gridView2.GetRowCellValue(i, "TienCam").ToString(),
gridView2.GetRowCellValue(i, "TruHotCon").ToString(),
gridView2.GetRowCellValue(i, "IDBienNhan").ToString(),
GD.DonGoc,
Constants.ThayGiay,
"0");
//Update Giao Dich cu
GD.ThayTheBang = IDBienNhanNew;
GD.TienLai = Convert.ToInt64(gridView2.GetRowCellValue(i, "TienLai").ToString());
camdochieuduongEntity.SaveChanges();
//In bien nhan moi
string a4printer = ConfigurationManager.AppSettings.Get("a4printer");
myFunction.PrintToPrinterA4(IDBienNhanNew, a4printer);
//////In giay nho Tam thoi disable
////long ChenhLech = Convert.ToInt64(gridView2.GetRowCellValue(i, "TienCam").ToString()) - Convert.ToInt64(GD.TienCam);
////var CamThem = "";
////if (ChenhLech > 0)
////{
//// CamThem = "Thêm " + String.Format("{0:n0}", ChenhLech) + " Đ";
////}else if (ChenhLech < 0)
////{
//// CamThem = "Bớt " + String.Format("{0:n0}", ChenhLech) + " Đ";
////}
////var ThayGiayCho = "Thay cho: " + gridView2.GetRowCellValue(i, "IDBienNhan").ToString();
////myFunction.PrintToPrinterA8(IDBienNhanNew, CamThem, ThayGiayCho);
}
else
{
System.Windows.Forms.MessageBox.Show("Lỗi. Đơn này đã thay giấy rồi!!");
}
}
setInit();
}
public static bool CheckConnection()
{
try
{
Model.camdochieuduongEntities camdochieuduongEntity = new Model.camdochieuduongEntities();
camdochieuduongEntity.Database.Connection.Open();
camdochieuduongEntity.Database.Connection.Close();
}
catch (SqlException)
{
return(false);
}
return(true);
}
private void btntcSave_Click(object sender, EventArgs e)
{
//Save data
Model.camdochieuduongEntities camdochieuduongEntity = new Model.camdochieuduongEntities();
Model.ThuChi thuchi = new Model.ThuChi();
thuchi.LoaiGiaoDich = cmbtcthuchi.Text;
thuchi.NgayNhap = DateTime.Parse(txttcngaynhap.Text);
thuchi.SoTien = Convert.ToInt64(txttcsotien.Text.Replace(",", ""));;
thuchi.MoTa = txttcmota.Text;
camdochieuduongEntity.ThuChis.Add(thuchi);
camdochieuduongEntity.SaveChanges();
showThuChi();
}
private void btntk1Print_Click(object sender, EventArgs e)
{
GridView gridView = gridTimKiem.FocusedView as GridView;
var selectId = gridView.GetFocusedRowCellValue("IDBienNhan").ToString();
string a4printer = ConfigurationManager.AppSettings.Get("a4printer");
myFunction.PrintToPrinterA4(selectId, a4printer);
//Update Giao Dich Table
Model.camdochieuduongEntities camdochieuduongEntity = new Model.camdochieuduongEntities();
Model.GiaoDich GD = camdochieuduongEntity.GiaoDiches.Find(selectId);
GD.InBienNhan++;
camdochieuduongEntity.SaveChanges();
////Get new data to Grid
getGrid1();
getTimKiem();
}
private void btntcCancel_Click(object sender, EventArgs e)
{
GridView gridView = gridThuChi.FocusedView as GridView;
var selectId = Convert.ToInt64(gridView.GetFocusedRowCellValue("MaThuChi"));
//Update Thu Chi Table
Model.camdochieuduongEntities camdochieuduongEntity = new Model.camdochieuduongEntities();
Model.ThuChi TC = camdochieuduongEntity.ThuChis.Find(selectId);
if (TC.NgayNhap.Value.Date == DateTime.Now.Date)
{
TC.Cancel = "X";
camdochieuduongEntity.SaveChanges();
showThuChi();
}
else
{
MessageBox.Show("Không thể xóa phiếu thu chi ngày quá khứ");
}
}
private void setInit()
{
txtngaycam.Text = DateTime.Now.ToString();
txtkhachhang.Text = "";
txtdienthoai.Text = "";
txtmota.Text = "";
txtgiatrimonhang.Text = "0";
txttiencam.Text = "0";
txttruhotcon.Text = "";
txtmadonthaygiay.Text = "";
gridThayGiay.DataSource = null;
gridGiaoDich._gridGiaoDich.Clear();
gridtgHistory1.History.Clear();
gridtgHistory.DataSource = null;
btntgChuoc.Enabled = true;
btntgThayGiay.Enabled = true;
btnSave.Enabled = true;
btnClear.Enabled = true;
btntk1Cancel.Enabled = true;
//Thay Giay
lblSum.Text = "0";
//
txttk1loaigiaodich.Items.Clear();
txttk1loaigiaodich.Items.Add(Constants.CamDo);
txttk1loaigiaodich.Items.Add(Constants.ThayGiay);
txttk1loaigiaodich.Items.Add(Constants.ChuocDo);
txttk1loaigiaodich.Items.Add(Constants.BaoMat);
//thuchi
txttcngaynhap.Text = DateTime.Now.ToString();
cmbtcthuchi.Items.Clear();
cmbtcthuchi.Items.Add(Constants.Thu);
cmbtcthuchi.Items.Add(Constants.Chi);
//Cau Hinh
Model.camdochieuduongEntities camdochieuduongEntity = new Model.camdochieuduongEntities();
Model.CauHinh CH = camdochieuduongEntity.CauHinhs.Find(Constants.CamDo);
txtchlaitren10tr.Text = CH.LaiTren10Tr.ToString();
txtchlaiduoi10tr.Text = CH.LaiDuoi10Tr.ToString();
txtchsongayapdung.Text = CH.SoNgayApDung.ToString();
txtchsongaytoihan.Text = CH.SoNgayToiHan.ToString();
}
private void btnBaoMat_Click(object sender, EventArgs e)
{
setDisable();
//Loop through all row
for (int i = 0; i < gridView2.DataRowCount; i++)
{
//Check and Update Giao Dich
Model.camdochieuduongEntities camdochieuduongEntity = new Model.camdochieuduongEntities();
Model.GiaoDich GD = camdochieuduongEntity.GiaoDiches.Find(gridView2.GetRowCellValue(i, "IDBienNhan").ToString());
if (GD.BaoMat == null)
{
//Update Giao Dich cu
GD.BaoMat = "X";
GD.LoaiGiaoDich = Constants.BaoMat;
camdochieuduongEntity.SaveChanges();
}
else
{
System.Windows.Forms.MessageBox.Show("Lỗi. Đơn này đã báo mất rồi");
}
}
setInit();
}
private void btnSaveConfig_Click(object sender, EventArgs e)
{
Model.camdochieuduongEntities camdochieuduongEntity = new Model.camdochieuduongEntities();
Model.CauHinh CH = camdochieuduongEntity.CauHinhs.Find(Constants.CamDo);
if (CH == null)
{
CH.Type = Constants.CamDo;
CH.LaiTren10Tr = Convert.ToInt64(txtchlaitren10tr.Text);
CH.LaiDuoi10Tr = Convert.ToInt64(txtchlaiduoi10tr.Text);
CH.SoNgayApDung = Convert.ToInt16(txtchsongayapdung.Text);
CH.SoNgayToiHan = Convert.ToInt16(txtchsongaytoihan.Text);
camdochieuduongEntity.CauHinhs.Add(CH);
}
else
{
CH.LaiTren10Tr = Convert.ToDecimal(txtchlaitren10tr.Text);
CH.LaiDuoi10Tr = Convert.ToDecimal(txtchlaiduoi10tr.Text);
CH.SoNgayApDung = Convert.ToInt16(txtchsongayapdung.Text);
CH.SoNgayToiHan = Convert.ToInt16(txtchsongaytoihan.Text);
}
camdochieuduongEntity.SaveChanges();
MessageBox.Show("Lưu Xong");
}
public void getTimKiem()
{
gridTimKiem.DataSource = null;
dsTimKiem.tbTimKiem.Clear();
var fromdate = txttk1tungay.Value.Date;
var todate = txttk1denngay.Value.AddDays(1).Date;
if (txttk1tiencamtu.Text == "")
{
txttk1tiencamtu.Text = "0";
}
if (txttk1tiencamden.Text == "")
{
txttk1tiencamden.Text = "0";
}
var tiencamtu = Convert.ToInt64(txttk1tiencamtu.Text);
var tiencamden = Convert.ToInt64(txttk1tiencamden.Text);
Model.camdochieuduongEntities camdochieuduongEntity = new Model.camdochieuduongEntities();
var listGiaoDich = camdochieuduongEntity.GiaoDiches.Where(x => x.NgayCam >= fromdate && x.NgayCam <= todate &&
(x.IDBienNhan.Contains(txttk1madonhang.Text) || (txttk1madonhang.Text == "")) &&
(x.KhachHang.Contains(txttk1khachhang.Text) || (txttk1khachhang.Text == "")) &&
(x.DienThoai.Contains(txttk1dienthoai.Text) || (txttk1dienthoai.Text == "")) &&
(x.MoTa.Contains(txttk1mota.Text) || (txttk1mota.Text == "")) &&
(x.LoaiGiaoDich.Contains(txttk1loaigiaodich.Text) || (txttk1loaigiaodich.Text == "")) &&
(x.TienCam >= tiencamtu || (txttk1tiencamtu.Text == "0")) &&
(x.TienCam <= tiencamden || (txttk1tiencamden.Text == "0"))
).ToList();
foreach (Model.GiaoDich GD in listGiaoDich)
{
if (GD.Canceled != "X")
{
DataRow dr = dsTimKiem.tbTimKiem.NewRow();
dr["IDBienNhan"] = GD.IDBienNhan;
dr["KhachHang"] = GD.KhachHang;
dr["NgayCam"] = GD.NgayCam;
dr["LoaiGiaoDich"] = GD.LoaiGiaoDich;
dr["TienLai"] = GD.TienLai;
dr["TienCam"] = GD.TienCam;
dr["MoTa"] = GD.MoTa;
dr["DienThoai"] = GD.DienThoai;
if (GD.DaChuoc != "X")
{
dr["TonKho"] = "Còn Hàng";
}
else
{
dr["TonKho"] = "Đã Chuộc";
}
//summary
if (GD.LoaiGiaoDich == Constants.CamDo)
{
dr["ThanhToan"] = GD.TienCam;;
}
else if (GD.LoaiGiaoDich == Constants.ChuocDo)
{
dr["ThanhToan"] = GD.TienCam + GD.TienLai;
}
else if (GD.LoaiGiaoDich == Constants.ThayGiay)
{
dr["ThanhToan"] = GD.TienLai;
}
dsTimKiem.tbTimKiem.Rows.Add(dr);
}
}
gridTimKiem.DataSource = dsTimKiem.tbTimKiem;
}
private void btntkSearch_Click(object sender, EventArgs e)
{
gridThongKe.DataSource = null;
dsThongKe.tbGiaoDich.Clear();
long tongtiencam = 0;
long tongtienchuoc = 0;
long tongtienlai = 0;
long tongtienthu = 0;
long tongtienchi = 0;
long tienconlai = 0;
var fromdate = txttktungay.Value.Date;
var todate = txttkdenngay.Value.AddDays(1).Date;
Model.camdochieuduongEntities camdochieuduongEntity = new Model.camdochieuduongEntities();
var listGiaoDich = camdochieuduongEntity.GiaoDiches.Where(x => x.NgayCam >= fromdate && x.NgayCam <= todate).ToList();
foreach (Model.GiaoDich GD in listGiaoDich)
{
DataRow dr = dsThongKe.tbGiaoDich.NewRow();
dr["IDBienNhan"] = GD.IDBienNhan;
dr["KhachHang"] = GD.KhachHang;
dr["NgayCam"] = GD.NgayCam;
dr["GioCam"] = GD.NgayCam;
dr["LoaiGiaoDich"] = GD.LoaiGiaoDich;
dr["TienLai"] = GD.TienLai;
dr["TienCam"] = GD.TienCam;
dr["MoTa"] = GD.MoTa;
dr["TruHotCon"] = GD.TruHotCon;
dr["DienThoai"] = GD.DienThoai;
dsThongKe.tbGiaoDich.Rows.Add(dr);
//summary
if (GD.LoaiGiaoDich == Constants.CamDo)
{
dr["ThanhToan"] = GD.TienCam;
tongtiencam = tongtiencam + Convert.ToInt64(GD.TienCam);
tongtienlai = tongtienlai + Convert.ToInt64(GD.TienLai);
}
else if (GD.LoaiGiaoDich == Constants.ChuocDo)
{
dr["ThanhToan"] = GD.TienCam + GD.TienLai;
tongtienchuoc = tongtienchuoc + Convert.ToInt64(GD.TienCam) + Convert.ToInt64(GD.TienLai);
}
else if (GD.LoaiGiaoDich == Constants.ThayGiay)
{
dr["ThanhToan"] = GD.TienLai;
tongtienlai = tongtienlai + Convert.ToInt64(GD.TienLai);
}
}
gridThongKe.DataSource = dsThongKe.tbGiaoDich;
//ThuChi
var listThuChi = camdochieuduongEntity.ThuChis.Where(x => x.NgayNhap >= fromdate && x.NgayNhap <= todate).ToList();
foreach (Model.ThuChi TC in listThuChi)
{
if (TC.Cancel != "X" && TC.LoaiGiaoDich == Constants.Thu)
{
tongtienthu = tongtienthu + Convert.ToInt64(TC.SoTien);
}
if (TC.Cancel != "X" && TC.LoaiGiaoDich == Constants.Chi)
{
tongtienchi = tongtienchi + Convert.ToInt64(TC.SoTien);
}
}
gridThuChi.DataSource = dsThuChi.tbThuChi;
tienconlai = tongtienchuoc - tongtiencam + tongtienthu - tongtienchi;
txttktongtienchuoc.Text = String.Format("{0:n0}", tongtienchuoc);
txttktongtiencam.Text = String.Format("{0:n0}", tongtiencam);
txttktongtienlai.Text = String.Format("{0:n0}", tongtienlai);
txttktongtienthu.Text = String.Format("{0:n0}", tongtienthu);
txttktongtienchi.Text = String.Format("{0:n0}", tongtienchi);
txttktienconlai.Text = String.Format("{0:n0}", tienconlai);
}
private void txtmadonthaygiay_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyData == Keys.Enter)
{
//Get ID Thay Giay
Model.camdochieuduongEntities camdochieuduongEntity = new Model.camdochieuduongEntities();
Model.GiaoDich GD = camdochieuduongEntity.GiaoDiches.Find(txtmadonthaygiay.Text);
if (GD != null)
{
bool exists = gridGiaoDich._gridGiaoDich.AsEnumerable().Where(c => c.Field <string>("IDBienNhan").Equals(GD.IDBienNhan)).Count() > 0;
if (!exists) //not exist in table display grid
{
if (GD.DaChuoc == "X")
{
MessageBox.Show("Lỗi. Đơn này đã chuộc rồi!!");
}
else if (GD.Canceled == "X")
{
MessageBox.Show("Lỗi. Đơn này đã Hủy rồi!!");
}
else
{
DataRow dr = gridGiaoDich._gridGiaoDich.NewRow();
dr["IDBienNhan"] = GD.IDBienNhan;
dr["KhachHang"] = GD.KhachHang;
//dr["NgayCam"] = DateTime.Parse(GD.NgayCam).Date;
dr["NgayCam"] = GD.NgayCam;
dr["MoTa"] = GD.MoTa;
dr["TienCam"] = GD.TienCam;
dr["GiaTri"] = GD.GiaTri;
dr["DienThoai"] = GD.DienThoai;
dr["TruHotCon"] = GD.TruHotCon;
dr["DonGoc"] = GD.DonGoc;
DateTime currDate = DateTime.Now.Date;
DateTime toDate = GD.NgayCam.Value.Date;
double SoNgay = (currDate - toDate).TotalDays + 1;
dr["SoNgay"] = SoNgay;
double SoTienCam = Convert.ToInt64(GD.TienCam);
double laisuat = 0;
double songayapdung = Convert.ToDouble(txtchsongayapdung.Text);
if (SoTienCam >= 10000000)
{ //Lon hon hoac = 10tr, 2%
laisuat = Convert.ToDouble(txtchlaitren10tr.Text);
}
else
{
laisuat = Convert.ToDouble(txtchlaiduoi10tr.Text);
}
var roundTienLai = Math.Round((SoNgay * SoTienCam * laisuat / 100 / songayapdung / 1000), MidpointRounding.AwayFromZero);
dr["TienLai"] = roundTienLai * 1000;
gridGiaoDich._gridGiaoDich.Rows.Add(dr);
gridThayGiay.DataSource = gridGiaoDich._gridGiaoDich;
//clear ma don hang
txtmadonthaygiay.Text = "";
//Get History
GetHistory(GD.DonGoc);
//Sum
long Sum = Convert.ToInt64(gridView2.Columns["TienCam"].SummaryItem.SummaryValue.ToString()) + Convert.ToInt64(gridView2.Columns["TienLai"].SummaryItem.SummaryValue.ToString());
lblSum.Text = String.Format("{0:n0}", Sum);
}
}
}
}
}
