Ejemplo n.º 1
0
        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);
            }
        }