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); } }