public static string AddOrUpdateDonHang(int ID, int MaHieuKhachHang, string MaHieuDonHang,
string NgayDatHang, string NgayGiaoHang, int TinhTrang, string GhiChu)
{
string returnMessage = "";
try
{
DateTime dtNgayDatHang = DateTime.ParseExact(NgayDatHang, "dd/MM/yyyy", CultureInfo.InvariantCulture);
DateTime dtNgayGiaoHang = DateTime.ParseExact(NgayGiaoHang, "dd/MM/yyyy", CultureInfo.InvariantCulture);
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;
if (ID == 0)
{
returnMessage = dts.Sp_Qldh_DonHang_Add_Edit_Deli("ADD", (int?)null, MaHieuKhachHang, dts.fc_SinhMa("MADONHANG", "*"), dtNgayDatHang, dtNgayGiaoHang, TinhTrang, GhiChu, "", user.UserId, user.UserId, ref id, Util.GetIP(), Util.GetPCName()).FirstOrDefault().Column1;
}
else
{
returnMessage = dts.Sp_Qldh_DonHang_Add_Edit_Deli("EDIT", ID, MaHieuKhachHang, MaHieuDonHang, dtNgayDatHang, dtNgayGiaoHang, TinhTrang, GhiChu, "", user.UserId, user.UserId, ref id, Util.GetIP(), Util.GetPCName()).FirstOrDefault().Column1;
}
dts.Dispose();
if (!string.IsNullOrEmpty(returnMessage))
{
return(returnMessage);
}
return(id.HasValue ? id.Value.ToString() : "");
}
catch (Exception ex)
{
return("ERROR: " + ex.Message);
}
}
protected void FillData(int id)
{
var dbContext = new xRPDataContext();
var item = dbContext.Qlvt_VatTus.FirstOrDefault(i => i.ID == id);
if (item != null)
{
//-----Fill and selected cbo----
BindCbo(item.MaLoaiVatTu.Value);
//-------------------------------
txtDinhLuong.Text = item.DinhLuong.ToString();
//txtDonViTinh.Text = item.DonViTinh;
txtDonViTinh.Text = new xRPDataContext().Qlvt_DonViTinhs.FirstOrDefault(i => i.ID == item.IDDonViTinh).DonViTinh;
hdfDonViTinh.Value = item.IDDonViTinh.ToString();
txtGhiChu.Text = item.GhiChu;
txtKichThuocVatTu.Text = item.KichThuocVatTu.ToString();
txtMaVatTu.Text = item.MaHieuVatTu;
txtTenVatTu.Text = item.TenVatTu;
txtTonToiThieu.Text = item.SoLuongTonToiThieu.Value.ToString();
try
{
chkKichHoat.Checked = item.KichHoat.Value;
}
catch
{
chkKichHoat.Checked = false;
}
}
dbContext.Dispose();
}
protected void BindCbo(int selectedId)
{
var dbContext = new xRPDataContext();
cboLoaiVatTu.DataSource = dbContext.Qlvt_LoaiVatTus;
cboLoaiVatTu.DataTextField = "TenLoaiVatTu";
cboLoaiVatTu.DataValueField = "ID";
cboLoaiVatTu.DataBind();
cboLoaiVatTu.SelectedIndex = cboLoaiVatTu.Items.IndexOf(cboLoaiVatTu.Items.FindByValue(selectedId.ToString()));
dbContext.Dispose();
}
public static string AddOrUpdatePhieuNhap(int ID, string MaHieuPhieuNhap, int?MaPhieuXuat, string NgayNhap, int?MaNhaCungCap, int MaKhoVatTu, int MaTinhChatNhapXuat,
int TinhTrang, string GhiChu, int KieuVatTu)
{
int?mpx = null;
if (MaPhieuXuat.HasValue && MaPhieuXuat.Value != 0)
{
mpx = MaPhieuXuat.Value;
}
int?ncc = null;
if (MaNhaCungCap.HasValue && MaNhaCungCap.Value != 0)
{
ncc = MaNhaCungCap.Value;
}
string returnMessage = "";
DateTime dtNgayNhap = DateTime.Now;
try
{
DateTime.ParseExact(NgayNhap, "dd/MM/yyyy", CultureInfo.InvariantCulture);
}
catch (Exception)
{
dtNgayNhap = DateTime.Now;
}
try
{
xRPDataContext dts = new xRPDataContext();
var user = (from u in dts.aspnet_Users where u.UserName == HttpContext.Current.User.Identity.Name select u).FirstOrDefault();
var tc = dts.Qlvt_TinhChatNhapXuats.Where(t => t.ID == MaTinhChatNhapXuat).FirstOrDefault();
int? id = ID == 0 ? 0 : ID;
if (ID == 0)
{
returnMessage = dts.Sp_Qlvt_PhieuNhap_Add_Edit_Deli("ADD", (int?)null, dts.fc_SinhMa(tc == null?"":tc.MaTinhChatNhapXuat, "*"), mpx, dtNgayNhap, ncc, MaKhoVatTu, MaTinhChatNhapXuat, KieuVatTu, TinhTrang, GhiChu, user.UserId, user.UserId, (Guid?)null, ref id, Util.GetIP(), Util.GetPCName()).FirstOrDefault().Column1;
}
else
{
returnMessage = dts.Sp_Qlvt_PhieuNhap_Add_Edit_Deli("Edit", ID, MaHieuPhieuNhap, mpx, dtNgayNhap, ncc, MaKhoVatTu, MaTinhChatNhapXuat, KieuVatTu
, TinhTrang, GhiChu, user.UserId, user.UserId, user.UserId, ref id, Util.GetIP(), Util.GetPCName()).FirstOrDefault().Column1;
}
dts.Dispose();
if (!string.IsNullOrEmpty(returnMessage))
{
return(returnMessage);
}
return(id.HasValue ? id.Value.ToString() : returnMessage);
}
catch (Exception ex)
{
return("ERROR: " + ex.Message);
}
}
public static string AddOrUpdateItem(int itemID, string ma, string ten, int loai, double kichThuoc, double dinhLuong, string donViTinh, bool kichHoat, int tonToiThieu, string ghiChu)
{
try
{
Guid currentUserID = Guid.NewGuid();
string currentUser = "";
#region Get current User
MembershipUser membershipUser = Membership.GetUser(HttpContext.Current.User.Identity.Name);
if (membershipUser != null)
{
currentUser = membershipUser.UserName;
currentUserID = (Guid)membershipUser.ProviderUserKey;
}
#endregion get current User
//Initial data context variable, this class is declared in .dbml file in xRPDAL namespace
var dbContext = new xRPDataContext();
int? id = 0;
var item = dbContext.Qlvt_VatTus.FirstOrDefault(i => i.ID == itemID && (i.Xoa != null && !i.Xoa.Value));
string result = "";
int paramKichHoat = kichHoat != true ? 0 : 1;
if (item == null) //Create new instance of LoaiVatTu
{
result = dbContext.Sp_Qlvt_VatTu_Add_Edit_Deli("ADD", null, loai, ten.Trim(), ma.Trim().ToUpper(), kichThuoc, dinhLuong, int.Parse(donViTinh), ghiChu, tonToiThieu, paramKichHoat, currentUserID, null, ref id, Util.GetIP(), Util.GetPCName()).FirstOrDefault().Column1;
}
else
{
result = dbContext.Sp_Qlvt_VatTu_Add_Edit_Deli("EDIT", itemID, loai, ten.Trim(), ma.Trim().ToUpper(), kichThuoc, dinhLuong, int.Parse(donViTinh), ghiChu, tonToiThieu, paramKichHoat, item.MaNguoiTao, currentUserID, ref id, Util.GetIP(), Util.GetPCName()).FirstOrDefault().Column1;
}
dbContext.Dispose();
if (!string.IsNullOrEmpty(result))
{
return(result);
}
}
catch (Exception ex)
{
return("ERROR: " + ex.Message);
}
return("SUCCESS");
}
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");
}
