public ActionResult Index()
{
var session = (DoAn.Common.Session.UserLogin)Session[DoAn.Common.Constants.USER_SESSION];
if (session != null)
{
var model = new List <HoaDonNhapModel>();
var list = db.HoaDonNhaps.ToList();
int i = 0;
foreach (var item in list)
{
i++;
var itemmodel = new HoaDonNhapModel();
itemmodel.Id = item.Id;
itemmodel.STT = i;
itemmodel.TenNCC = new NhaCungCapDao().getById(item.MaNCC).TenNCC;
itemmodel.TenDangNhap = new KhachHangDao().viewDetail(item.MaNhanVien).TenDangNhap;
itemmodel.TongTien = item.TongTien;
itemmodel.NgayNhap = item.NgayNhap;
itemmodel.ChietKhau = String.Format("{0:0,0}", item.ChietKhau);
model.Add(itemmodel);
}
return(View(model));
}
else
{
return(RedirectToAction("Index", "Home"));
}
}
public ActionResult CreateHDN()
{
var session_mahdn = (DoAn.Common.Session.MaHoaDonNhap)Session[DoAn.Common.Constants.MAHDN_SESSION];
var list_cthdn = new List <CTHDNhapModel>();
var model = new HoaDonNhapModel();
if (session_mahdn != null)
{
var list = db.ChiTietHDNs.Where(x => x.MaHDN == session_mahdn.Id).ToList();
int i = 0;
foreach (var item in list)
{
i++;
var item_cthdn = new CTHDNhapModel();
item_cthdn.Id = item.Id;
item_cthdn.STT = i;
item_cthdn.TenNguyenLieu = new NguyenLieuDao().getByid(item.MaNguyenLieu).TenNguyenLieu;
item_cthdn.TenDonViTinh = new NguyenLieuDao().getByid(item.MaNguyenLieu).DonViTinh;
item_cthdn.SoLuong = item.SoLuong.ToString();
item_cthdn.GiaNhap = item.GiaNhap.ToString();
item_cthdn.ChietKhau = item.ChietKhau.ToString();
item_cthdn.ThanhTien = item.ThanhTien;
list_cthdn.Add(item_cthdn);
}
var tongtienhdn = db.ChiTietHDNs.Where(x => x.MaHDN == session_mahdn.Id).Sum(x => x.ThanhTien);
model.TongTien = tongtienhdn;
}
else
{
list_cthdn = null;
}
ViewBag.ListChiTietHDN = list_cthdn;
model.SelectNCC = new SelectList(db.NhaCungCaps, "Id", "TenNCC", 0);
return(View(model));
}
public ActionResult XemChiTietHDN(string mahoadon)
{
var model = new List <CTHDNhapModel>();
var list = db.ChiTietHDNs.Where(x => x.MaHDN == mahoadon).ToList();
int i = 0;
foreach (var item in list)
{
var itemmodel = new CTHDNhapModel();
i++;
itemmodel.TenNguyenLieu = new NguyenLieuDao().getByid(item.MaNguyenLieu).TenNguyenLieu;
itemmodel.TenDonViTinh = new NguyenLieuDao().getByid(item.MaNguyenLieu).DonViTinh;
//itemmodel.TenDonViTinh = new DonViTinhDao().getByid(item.MaDonViTinh).TenDonViTinh;
itemmodel.GiaNhap = item.GiaNhap.ToString();
itemmodel.SoLuong = item.SoLuong.ToString();
itemmodel.ChietKhau = item.ChietKhau.ToString();
itemmodel.ThanhTien = item.ThanhTien;
itemmodel.STT = i;
model.Add(itemmodel);
}
var hoadonnhap = db.HoaDonNhaps.FirstOrDefault(x => x.Id == mahoadon);
var hdnmodel = new HoaDonNhapModel();
hdnmodel.TenDangNhap = db.KhachHangs.FirstOrDefault(x => x.Id == hoadonnhap.MaNhanVien).TenDangNhap;
hdnmodel.NgayNhap = hoadonnhap.NgayNhap;
hdnmodel.TenNCC = db.NhaCungCaps.FirstOrDefault(x => x.Id == hoadonnhap.MaNCC).TenNCC;
hdnmodel.TongTien = hoadonnhap.TongTien;
hdnmodel.ChietKhau = String.Format("{0:0,0}", hoadonnhap.ChietKhau);
var chietkhau = new DoAn.Common.Function.ConvertMoney().ConvertTien(hdnmodel.ChietKhau);
hdnmodel.PhaiTra = (hdnmodel.TongTien - chietkhau);
ViewBag.HoaDonNhap = hdnmodel;
return(View(model));
}
public HoaDonNhapModel Them(HoaDonNhapModel hdn)
{
var kq = _res.Them(hdn);
var tg = GetHDNbyID(kq.MaHDN);
foreach (var item in tg.chitiet)
{
_res.TangSLSP(item.MaSanPham, item.Soluong);
}
return(kq);
}
public ActionResult CreateHDN(HoaDonNhapModel model)
{
var session_hdn = (ChuoiCuaHangTraSua.Common.MaHoaDonNhap)Session[ChuoiCuaHangTraSua.Common.Constants.MAHDN_SESSION];
var hoadonnhap = new HoaDonNhap();
hoadonnhap.Id = session_hdn.Id;
hoadonnhap.MaNCC = model.MaNhaCungCap;
hoadonnhap.MaNhanVien = 3;
DateTime now = DateTime.Now;
hoadonnhap.NgayNhap = now;
hoadonnhap.TongTien = db.ChiTietHDNs.Where(x => x.MaHDN == session_hdn.Id).Sum(x => x.ThanhTien);
hoadonnhap.ChietKhau = new ChuoiCuaHangTraSua.Common.ConvertMoney().ConvertTien(model.ChietKhau);
db.HoaDonNhaps.Add(hoadonnhap);
db.SaveChanges();
return(RedirectToAction("Index", "HoaDonNhapAdmin"));
}
public ActionResult Index()
{
var model = new List <HoaDonNhapModel>();
var list = db.HoaDonNhaps.ToList();
int i = 0;
foreach (var item in list)
{
i++;
var itemmodel = new HoaDonNhapModel();
itemmodel.Id = item.Id;
itemmodel.STT = i;
itemmodel.TenNCC = new NhaCungCapDao().getById(item.MaNCC).TenNCC;
itemmodel.TenDangNhap = new KhachHangDao().viewDetail(item.MaNhanVien).TenDangNhap;
itemmodel.TongTien = item.TongTien;
itemmodel.NgayNhap = item.NgayNhap;
itemmodel.ChietKhau = String.Format("{0:0,0}", item.ChietKhau);
model.Add(itemmodel);
}
return(View(model));
}
public HoaDonNhapModel Them(HoaDonNhapModel hdn)
{
string msgError = "";
try
{
var dt = _dbHelper.ExecuteSProcedureReturnDataTable(out msgError, "themhdn",
"@mancc", hdn.MaNCC,
"@mashop", hdn.MaShop,
"@chitiet", hdn.chitiet != null ? MessageConvert.SerializeObject(hdn.chitiet) : null);
if (!string.IsNullOrEmpty(msgError))
{
throw new Exception(msgError);
}
return(dt.ConvertTo <HoaDonNhapModel>().FirstOrDefault());
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Handles the CellDoubleClick event of the dgv control.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="DataGridViewCellEventArgs"/> instance containing the event data.</param>
private void dgv_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
currentModel = (HoaDonNhapModel)dataGridView.CurrentSelected(currentModelList);
controller.ShowHoaDonNhapView(currentModel);
}
/// <summary>
/// Handles the Click event of the bntLuaChon control.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="EventArgs" /> instance containing the event data.</param>
private void bntLuaChon_Click(object sender, EventArgs e)
{
currentModel = (HoaDonNhapModel)dataGridView.CurrentSelected(currentModelList);
//MessageBox.Show(currentModel.MaGiayDep);
}
/// <summary>
/// To the entity.
/// </summary>
/// <param name="model">The model.</param>
/// <param name="destination">The destination.</param>
/// <returns>HoaDonNhap.</returns>
public static HoaDonNhap ToEntity(this HoaDonNhapModel model, HoaDonNhap destination)
{
return(model.MapTo(destination));
}
/// <summary>
/// To the entity.
/// </summary>
/// <param name="model">The model.</param>
/// <returns>HoaDonNhap.</returns>
public static HoaDonNhap ToEntity(this HoaDonNhapModel model)
{
return(model.MapTo <HoaDonNhapModel, HoaDonNhap>());
}
public ActionResult CreateHDN(HoaDonNhapModel model)
{
if (ModelState.IsValid)
{
var session_hdn = (DoAn.Common.Session.MaHoaDonNhap)Session[DoAn.Common.Constants.MAHDN_SESSION];
var hoadonnhap = new HoaDonNhap();
hoadonnhap.Id = session_hdn.Id;
hoadonnhap.MaNCC = model.MaNhaCungCap;
hoadonnhap.MaNhanVien = 3;
DateTime now = DateTime.Now;
hoadonnhap.NgayNhap = now;
hoadonnhap.TongTien = db.ChiTietHDNs.Where(x => x.MaHDN == session_hdn.Id).Sum(x => x.ThanhTien);
if (model.ChietKhau == null)
{
hoadonnhap.ChietKhau = 0;
}
else
{
hoadonnhap.ChietKhau = new DoAn.Common.Function.ConvertMoney().ConvertTien(model.ChietKhau);
}
db.HoaDonNhaps.Add(hoadonnhap);
Session[DoAn.Common.Constants.MAHDN_SESSION] = null;
db.SaveChanges();
return(RedirectToAction("Index", "HoaDonNhapAdmin"));
}
else
{
var session_mahdn = (DoAn.Common.Session.MaHoaDonNhap)Session[DoAn.Common.Constants.MAHDN_SESSION];
var list_cthdn = new List <CTHDNhapModel>();
var viewmodel = new HoaDonNhapModel();
if (session_mahdn != null)
{
var list = db.ChiTietHDNs.Where(x => x.MaHDN == session_mahdn.Id).ToList();
int i = 0;
foreach (var item in list)
{
i++;
var item_cthdn = new CTHDNhapModel();
item_cthdn.Id = item.Id;
item_cthdn.STT = i;
item_cthdn.TenNguyenLieu = new NguyenLieuDao().getByid(item.MaNguyenLieu).TenNguyenLieu;
item_cthdn.TenDonViTinh = new NguyenLieuDao().getByid(item.MaNguyenLieu).DonViTinh;
item_cthdn.SoLuong = item.SoLuong.ToString();
item_cthdn.GiaNhap = item.GiaNhap.ToString();
item_cthdn.ChietKhau = item.ChietKhau.ToString();
item_cthdn.ThanhTien = item.ThanhTien;
list_cthdn.Add(item_cthdn);
}
var tongtienhdn = db.ChiTietHDNs.Where(x => x.MaHDN == session_mahdn.Id).Sum(x => x.ThanhTien);
model.TongTien = tongtienhdn;
}
else
{
list_cthdn = null;
}
model.SelectNCC = new SelectList(db.NhaCungCaps, "Id", "TenNCC", 0);
ViewBag.ListChiTietHDN = list_cthdn;
return(View(model));
}
}
public HoaDonNhapModel them([FromBody] HoaDonNhapModel hdn)
{
var kq = ihdn.Them(hdn);
return(kq);
}
/// <summary>
/// Initializes the form.
/// </summary>
/// <param name="value">The value.</param>
public void InitializeForm(HoaDonNhapModel value)
{
//txtMaCV.Text = value;
}
/// <summary>
/// Posts the view.
/// </summary>
/// <param name="value">The value.</param>
public void PostView(HoaDonNhapModel value)
{
currentHoaDonNhapModel = value;
currentListDataTable = null;
dataGridView.Columns.Clear();
var g = new DataGridViewCheckBoxColumn {
Name = "CB", HeaderText = "", Width = 24, AutoSizeMode = DataGridViewAutoSizeColumnMode.None, ReadOnly = true
};
dataGridView.Columns.Add(g);
dataSourceDataTable = value.ChiTietHDNModel.ToDataTable();
dataSourceDataTable.AcceptChanges();
dataBindingSource.DataSource = dataSourceDataTable;
dataGridView.DataSource = dataBindingSource;
//dataGridView.DataSource = new BindingSource { DataSource = value.ChiTietHDNModel };
dataGridView.Columns[Rf.Name <ChiTietHdnModel>(c => c.ID)].Display(false);
dataGridView.Columns[Rf.Name <ChiTietHdnModel>(c => c.SanPhamID)].Display(false);
dataGridView.Columns[Rf.Name <ChiTietHdnModel>(c => c.SanPham)].Display(false);
dataGridView.Columns[Rf.Name <ChiTietHdnModel>(c => c.HoaDonNhapID)].Display(false);
dataGridView.Columns[Rf.Name <ChiTietHdnModel>(c => c.HoaDonNhap)].Display(false);
dataGridView.Columns[Rf.Name <ChiTietHdnModel>(c => c.SoHDN)].Display(false);
dataGridView.Columns[Rf.Name <ChiTietHdnModel>(c => c.IDModel)].Display(false);
if (dataGridView.Columns[Rf.Name <ChiTietHdnModel>(c => c.MaGiayDep)] != null)
{
dataGridView.Columns[Rf.Name <ChiTietHdnModel>(c => c.MaGiayDep)].DisplayIndex = 1;
}
if (value != null)
{
if (value.SoHDN != null)
{
txtMaHoaDon.Text = value.SoHDN;
}
if (value.MaNV != null)
{
txtMaNhanVien.Text = value.MaNV;
}
if (value.MaNCC != null)
{
txtMaNCC.Text = value.MaNCC;
}
if (value.NgayNhap != null)
{
txtNgayNhap.Text = value.NgayNhap.ToDateString();
}
if (value.TongTien != null)
{
txtTongTien.Text = value.TongTien.ToString();
}
}
txtMaNhanVien.Text = AppMediator.MANHANVIEN;
dataGridView.ClearSelection();
dataGridView.CurrentCell = null;
if (isEditMode)
{
bntLuu.Enabled = false;
bntTaoMoi.Enabled = true;
bntXoa.Enabled = false;
bntLuaChon.Enabled = false;
txtMaHoaDon.Focus();
}
else
{
bntLuu.Enabled = false;
bntTaoMoi.Enabled = false;
bntXoa.Enabled = false;
}
currentModel = null;
}
