public bool them(LichSuDTO lsDTO)
{
string query = string.Empty;
query += "insert into LICHSUDANGNHAP(maus,thoigiandn) values(@maus,@thoigiandn)";
using (MySqlConnection con = new MySqlConnection(connectionString))
{
using (MySqlCommand cmd = new MySqlCommand())
{
cmd.Connection = con;
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = query;
cmd.Parameters.AddWithValue("@maus", lsDTO.MaUS);
cmd.Parameters.AddWithValue("@thoigiandn", lsDTO.ThoiGianDN);
try
{
con.Open();
cmd.ExecuteNonQuery();
con.Close();
con.Dispose();
}
catch (Exception ex)
{
con.Close();
return(false);
}
}
}
return(true);
}
public firmLichSuDN(UsersDTO us, LichSuDTO ls)
{
InitializeComponent();
usDTO.MaUS = us.MaUS;
usDTO.TaiKhoan = us.TaiKhoan;
usDTO.MatKhau = us.MatKhau;
usDTO.MaNV = us.MaNV;
usDTO.MaQH = us.MaQH;
lsDTO.MaUS = ls.MaUS;
lsDTO.ThoiGianDN = ls.ThoiGianDN;
}
public ActionResult CreateLS(LichSuDTO model)
{
var IdLS = Guid.NewGuid();
var dataLS = new LichSu
{
BenA = model.BenA,
ChucVu = model.ChucVu,
DaiDien = model.DaiDien,
DiaChi = model.DiaChi,
DiaDienTrinhDien = model.DiaDienTrinhDien,
DienThoai = model.DienThoai,
GiaTriHopDong = model.GiaTriHopDong,
NgayTao = model.NgayTao,
Tong = model.Tong,
GioiTinh = model.GioiTinh,
Mst = model.Mst,
ThoiGianLapDat = model.ThoiGianLapDat,
ThoiGianThucHien = model.ThoiGianThucHien,
Vat = model.Vat,
Id = IdLS,
TrangThai = false,
MaKh = model.maKH,
SoHd = model.soHD,
SoTk = model.soTK,
NgayKy = model.ngayKy,
TenCt = model.tenCT
};
_context.LichSus.Add(dataLS);
foreach (ChiTietLichSu item in model.Chitiet)
{
item.Id = Guid.NewGuid();
item.LichSuId = IdLS;
_context.ChiTietLichSus.Add(item);
}
_context.SaveChanges();
return(NoContent());
}
public bool them(LichSuDTO lsDTO)
{
bool re = lsDAL.them(lsDTO);
return(re);
}
