/// <summary>
/// Cập nhật kiểm định
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public ActionResult Edit(int?id)
{
Kiemdinh kiemDinh = db.Kiemdinhs.FirstOrDefault(p => p.KiemdinhID == id);
Hoadonnuoc hoaDonNuoc = db.Hoadonnuocs.Find(kiemDinh.HoaDonId);
int kiemDinhKHID = kiemDinh.KhachhangID.Value;
ViewData["kiemDinh"] = kiemDinh;
ViewData["khachHang"] = db.Khachhangs.Find(kiemDinh.KhachhangID);
ViewBag.chiSoThangTruoc = ChiSo.getChiSoThang(hoaDonNuoc.ThangHoaDon.Value.ToString(), hoaDonNuoc.NamHoaDon.Value.ToString(), hoaDonNuoc.KhachhangID.Value);
ViewBag.id = id;
return(View(kiemDinh));
}
public ActionResult Create(FormCollection form)
{
#region FormRequest
String maKhachHang = String.IsNullOrEmpty(form["maKhachHang"]) ? "0" : form["maKhachHang"];
String thangKiemDinh = String.IsNullOrEmpty(form["thang"]) ? DateTime.Now.Month.ToString() : form["thang"];
String namKiemDinh = String.IsNullOrEmpty(form["nam"]) ? DateTime.Now.Year.ToString() : form["nam"];
int quanHuyenID = Convert.ToInt32(form["quan"]);
ViewBag.Thang = thangKiemDinh;
ViewBag.Nam = namKiemDinh;
#endregion
Kiemdinh kD = new Kiemdinh();
var khachHang = (from i in db.Khachhangs
join r in db.Hoadonnuocs on i.KhachhangID equals r.KhachhangID
where i.MaKhachHang == maKhachHang && r.ThangHoaDon.ToString() == thangKiemDinh && r.NamHoaDon.ToString() == namKiemDinh
select new KhachHangModel
{
MaKH = i.MaKhachHang,
KHID = i.KhachhangID,
tenKhachHang = i.Ten,
QuanhuyenID = i.QuanhuyenID == null ? 0 : i.QuanhuyenID.Value,
PhuongxaID = i.PhuongxaID == null ? 0 : i.PhuongxaID.Value,
CumdancuID = i.CumdancuID == null ? 0 : i.CumdancuID.Value,
TuyenKHID = i.TuyenKHID == null ? 0 : i.TuyenKHID.Value,
}).FirstOrDefault();
if (khachHang != null)
{
maKhachHang = khachHang.MaKH;
var hoaDonNuoc = db.Hoadonnuocs.FirstOrDefault(p => p.KhachhangID == khachHang.KHID && p.ThangHoaDon.ToString() == thangKiemDinh && p.NamHoaDon.ToString() == namKiemDinh);
var kiemDinhHoaDonNuocID = 0;
if (hoaDonNuoc != null)
{
kiemDinhHoaDonNuocID = hoaDonNuoc.HoadonnuocID;
}
var isKiemDinhExist = db.Kiemdinhs.FirstOrDefault(p => p.HoaDonId == kiemDinhHoaDonNuocID);
if (isKiemDinhExist == null)
{
#region ViewBag
ViewBag.message = null;
ViewBag.khachHang = khachHang;
ViewBag.maKH = maKhachHang;
ViewBag.khachHangID = khachHang.KHID;
ViewBag.chiSoThangTruoc = ChiSo.getChiSoThang(thangKiemDinh, namKiemDinh, khachHang.KHID);
ViewBag.result = true;
ViewBag.HoaDonID = kiemDinhHoaDonNuocID;
#endregion
}
else
{
ViewBag.message = "Thông tin kiểm định đã tồn tại";
ViewBag.result = false;
ViewBag.maKH = maKhachHang;
return(View());
}
return(View(kD));
}
else
{
ViewBag.message = "Không tìm thấy hóa đơn có mã khách hàng ";
ViewBag.result = false;
ViewBag.maKH = maKhachHang;
}
return(View());
}
public void ExcelToDatabase(string path)
{
try
{
StringBuilder str = new StringBuilder();
str.Append("INSERT ALL ");
DataTable tb = ReadExcel(path); // content of excel
List <Customer> customerList = new List <Customer>();
List <ChiSo> chisoList = new List <ChiSo>();
for (int i = 0; i < tb.Rows.Count; i++)
{
Customer customer = new Customer();
ChiSo cs = new ChiSo();
customer.MA_DDO = (tb.Rows[i]["MA_DDO"]).ToString();
customer.MA_SOGCS = (tb.Rows[i]["MA_SOGCS"]).ToString();
customer.STT = Convert.ToInt32(tb.Rows[i]["STT"]);
customer.TEN_KHANG = (tb.Rows[i]["TEN_KHANG"]).ToString();
customer.DCHI_HDON = (tb.Rows[i]["DCHI_HDON"]).ToString();
customer.SO_TBI = (tb.Rows[i]["SO_TBI"]).ToString();
customer.MA_CAPDA = Convert.ToInt32(tb.Rows[i]["MA_CAPDA"]);
customer.KIMUA_CSPK = Convert.ToInt32(tb.Rows[i]["KIMUA_CSPK"]);
customer.SO_HO = Convert.ToInt32(tb.Rows[i]["SO_HO"]);
customer.MA_TRAM = (tb.Rows[i]["MA_TRAM"]).ToString();
customer.TEN_TRAM = (tb.Rows[i]["TEN_TRAM"]).ToString();
customer.LOAI_TRAM = (tb.Rows[i]["LOAI_TRAM"]).ToString();
customer.DINH_DANH = (tb.Rows[i]["DINH_DANH"]).ToString();
customer.SO_DTHOAI = (tb.Rows[i]["SO_DTHOAI"]).ToString();
customer.ID_HDONG = (tb.Rows[i]["ID_HDONG"]).ToString();
customer.TEN_DVIDCHINH = (tb.Rows[i]["TEN_DVIDCHINH"]).ToString();
customer.MA_KHANG = (tb.Rows[i]["MA_KHANG"]).ToString();
customer.NGAY_TAO = DateTime.Now;
customer.NGUOI_TAO = "Duy"; //dua tu login vao
customerList.Add(customer);
cs.MA_DDO = (tb.Rows[i]["MA_DDO"]).ToString();
cs.NAM = Convert.ToInt32(tb.Rows[i]["NAM"]);
cs.THANG = Convert.ToInt32(tb.Rows[i]["THANG"]);
cs.SAN_LUONG = Convert.ToDouble(tb.Rows[i]["SAN_LUONG"]);
cs.NGAY_TAO = DateTime.Now;
cs.NGUOI_TAO = "DUY";
chisoList.Add(cs);
}
foreach (var item in chisoList)
{
str.AppendLine("into MH_CHISO_DUBAO(MA_DDO,THANG,NAM,SAN_LUONG,NGAY_TAO,NGUOI_TAO) values ('" + item.MA_DDO + "'," + item.THANG + "," + item.NAM + "," + item.SAN_LUONG + ", to_date('" + DateTime.Now + "','MM/DD/YYYY HH:MI:SS AM'), 'DUY') ");
}
str.AppendLine("SELECT 1 FROM DUAL ");
OracleCommand command_chiso = new OracleCommand(str.ToString(), dbConnect.Connection);
command_chiso.CommandType = CommandType.Text;
dbConnect.OpenConn();
int inserted = command_chiso.ExecuteNonQuery();
dbConnect.CloseConn();
}
catch (Exception Ex)
{
return;
}
}
