public static string AddOrUpdateChiTietDonHang(int ID, string MaHieuMatHang, string MaHangTheoDon, int IDDonHang, string TenMatHang, string NgayGiaoHang,
float SoLuong, int IDDonViTinh, int SoLuongMau, string MauSacMatNgoai, float ChieuDai, float ChieuRong, float ChieuCao, int IDLoaiKichThuoc,
int IDLoaiSanPham, int SoLop, int?TongDao, double?ChatDai, double?Xa, int?IDLoaiGiay, float KhoGiay, double DinhLuong, int?LoaiSongSanXuat,
int?LoaiSongXuatBan, double Tai, double Le, int?SoLuongTam, int?SoLuongHop, float DienTichSanXuat, float DienTichXuatBan, int CongDoanCuoi,
int DonGia, float ThanhTien, string GhiChu, int[] DSLoaiSong)
{
string returnMessage = "";
try
{
xRPDataContext dts = new xRPDataContext();
var user = (from u in dts.aspnet_Users where u.UserName == HttpContext.Current.User.Identity.Name select u).FirstOrDefault();
int? id = ID;
DateTime dtNgayGiaoHang = DateTime.ParseExact(NgayGiaoHang, "dd/MM/yyyy", CultureInfo.InvariantCulture);
if (ID == 0)
{
returnMessage = dts.Sp_Qldh_MatHang_Add_Edit_Deli("ADD", (int?)null, MaHieuMatHang, IDDonHang, TenMatHang, dtNgayGiaoHang, SoLuong, IDDonViTinh,
SoLuongMau, MauSacMatNgoai, ChieuDai, ChieuRong, ChieuCao, IDLoaiKichThuoc, IDLoaiSanPham, SoLop, TongDao,
ChatDai, Xa, null, KhoGiay, DinhLuong, LoaiSongSanXuat, LoaiSongXuatBan, Tai, Le, SoLuongTam, SoLuongHop,
DienTichSanXuat, DienTichXuatBan, CongDoanCuoi, DonGia, ThanhTien,
GhiChu, MaHangTheoDon, 0, user.UserId, user.UserId, ref id, Util.GetIP(), Util.GetPCName()).FirstOrDefault().Column1;
}
else
{
returnMessage = dts.Sp_Qldh_MatHang_Add_Edit_Deli("EDIT", ID, MaHieuMatHang, IDDonHang, TenMatHang, dtNgayGiaoHang, SoLuong, IDDonViTinh,
SoLuongMau, MauSacMatNgoai, ChieuDai, ChieuRong, ChieuCao, IDLoaiKichThuoc, IDLoaiSanPham, SoLop, TongDao,
ChatDai, Xa, null, KhoGiay, DinhLuong, LoaiSongSanXuat, LoaiSongXuatBan, Tai, Le, SoLuongTam, SoLuongHop,
DienTichSanXuat, DienTichXuatBan, CongDoanCuoi, DonGia, ThanhTien,
GhiChu, MaHangTheoDon, 0, user.UserId, user.UserId, ref id, Util.GetIP(), Util.GetPCName()).FirstOrDefault().Column1;
}
if (id.HasValue && id.Value > 0)
{
int?idsong = 0;
var delList = dts.Sp_Qldh_MatHangTheoSong_Select(0, (int?)null, 0, 1).Where(t => t.IDMatHang == id.Value && !DSLoaiSong.Contains(t.IDSong.Value));
foreach (var ls in delList)
{
dts.Sp_Qldh_MatHangTheoSong_Deli("DEL0", ls.ID, user.UserId, Util.GetIP(), Util.GetPCName());
}
foreach (int ls in DSLoaiSong)
{
var y = dts.Sp_Qldh_MatHangTheoSong_Select(0, (int?)null, 0, 1).Where(t => t.IDMatHang.Value == id.Value && t.IDSong.Value == ls).FirstOrDefault();
if (y == null)
{
dts.Sp_Qldh_MatHangTheoSong_Add_Edit_Deli("ADD", (int?)null, id.Value, ls, user.UserId, user.UserId, ref idsong, Util.GetIP(), Util.GetPCName());
}
else
{
dts.Sp_Qldh_MatHangTheoSong_Add_Edit_Deli("EDIT", y.ID, id.Value, ls, y.MaNguoiTao.Value, user.UserId, ref idsong, Util.GetIP(), Util.GetPCName());
}
}
}
dts.Dispose();
if (!string.IsNullOrEmpty(returnMessage))
{
return(returnMessage);
}
}
catch (Exception ex)
{
return("ERROR: " + ex.Message);
}
return("SUCCESS");
}
