public static string AddOrUpdatePhieuXuat(int ID, string MaHieuPhieuXuat, string NgayXuat, int?MaDonViNhan, int?MaKhoVatTu, int?MaTinhChatNhapXuat, int?MaKhoVatTuDen, int?TinhTrang, string GhiChu, int KieuVatTu) { string returnMessage = ""; DateTime dtNgayXuat = DateTime.Now; try { dtNgayXuat = DateTime.ParseExact(NgayXuat, "dd/MM/yyyy", CultureInfo.InvariantCulture); } catch (Exception ex) { dtNgayXuat = 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_PhieuXuat_Add_Edit_Deli("ADD", (int?)null, dts.fc_SinhMa(tc == null?"":tc.MaTinhChatNhapXuat, "*"), MaDonViNhan, dtNgayXuat, MaKhoVatTu, MaKhoVatTuDen, MaTinhChatNhapXuat, KieuVatTu, TinhTrang, GhiChu, user.UserId, user.UserId, ref id, Util.GetIP(), Util.GetPCName()).FirstOrDefault().Column1; } else { returnMessage = dts.Sp_Qlvt_PhieuXuat_Add_Edit_Deli("Edit", ID, MaHieuPhieuXuat, MaDonViNhan, dtNgayXuat, MaKhoVatTu, MaKhoVatTuDen, MaTinhChatNhapXuat, KieuVatTu, TinhTrang, GhiChu, (Guid?)null, 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); } }