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