public static Boolean CapNhatTrangThaiXeRanh(String SoHopDong)
{
var entity = new QuanLyThueXeEntities();
try
{
var hd = entity.HopDongs.Where(n => n.SoHopDong == SoHopDong);
foreach (var item in hd)
{
var cthd = entity.CT_HopDongs.Where(n => n.SoHopDong == item.SoHopDong);
foreach (var c in cthd)
{
Xe result = entity.Xes.SingleOrDefault(n => n.MaXe == c.MaXe);
result.Status = "0";
}
}
entity.SaveChanges();
return(true);
}
catch (Exception ex)
{
entity.Dispose();
return(false);
}
}
private void BtnCapnhat_Click_1(object sender, EventArgs e)
{
if (txtGiaDienSau.Text != "" || txtGiaNuocSau.Text != "" || txtGiaRacSau.Text != "" || txtGiaWifiSau.Text != "" | txtGiaXeSau.Text != "")
{
//List<Điện> listDV = DB.DỊch_vụ.ToList();
Điện dbGiaDien = DB.Điện.FirstOrDefault(p => p.Mã_điện == "DD");
Nước dbGiaNuoc = DB.Nước.FirstOrDefault(p => p.Mã_nước == "NN");
Xe dbGiaXe = DB.Xes.FirstOrDefault(p => p.Mã_xe == "GX");
Wifi dbWifi = DB.Wifis.FirstOrDefault(p => p.Mã_wifi == "WF");
Rác dbRac = DB.Rác.FirstOrDefault(p => p.Mã_rác == "RC");
dbGiaDien.Giá_điện = int.Parse(txtGiaDienSau.Text);
dbGiaNuoc.Giá_nước = int.Parse(txtGiaNuocSau.Text);
dbGiaXe.Giá_xe = int.Parse(txtGiaXeSau.Text);
dbWifi.Giá_wifi = int.Parse(txtGiaWifiSau.Text);
dbRac.Giá_rác = int.Parse(txtGiaRacSau.Text);
DB.SaveChanges();
foreach (TextBox txt in pnlSau.Controls)
{
txt.Clear();
}
Bingrid();
MessageBox.Show("Cập nhật thành công", "Thông báo");
}
else
{
MessageBox.Show("Vui lòng nhập đầy đủ thông tin", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
private void Bingrid()
{
//List<Điện> listDien;
//List<Nước> listNuoc;
//List<Wifi> listWifi;
//List<Rác> listRac;
//List<Xe> listGiuXe;
foreach (TextBox txt in pnlGiaTruoc.Controls)
{
txt.ReadOnly = true;
}
Điện dbDien = DB.Điện.FirstOrDefault(p => p.Mã_điện == "DD");
txtGiaDienTruoc.Text = dbDien.Giá_điện.ToString().Trim();
Nước dbNuoc = DB.Nước.FirstOrDefault(p => p.Mã_nước == "NN");
txtGiaNuocTruoc.Text = dbNuoc.Giá_nước.ToString().Trim();
Wifi dbWifi = DB.Wifis.FirstOrDefault(p => p.Mã_wifi == "WF");
txtGiaWifiTruoc.Text = dbWifi.Giá_wifi.ToString().Trim();
Xe dbXe = DB.Xes.FirstOrDefault(p => p.Mã_xe == "GX");
txtGiaXeTruoc.Text = dbXe.Giá_xe.ToString().Trim();
Rác dbRac = DB.Rác.FirstOrDefault(p => p.Mã_rác == "RC");
txtGiaRacTruoc.Text = dbRac.Giá_rác.ToString().Trim();
}
public async Task DeleteBusAsync(Xe bus)
{
if (bus == null)
{
throw new ArgumentNullException(nameof(bus));
}
// Find all trips of this bus
var busTrips = await _context.Chuyenxes.Where(p => p.MaXe == bus.MaXe).ToListAsync();
// Find and delete all tickets, seats that relations with those bus trips
foreach (var busTrip in busTrips)
{
var ticketsByBusTrip = await _context.Vexes.Where(p => p.MaChuyenXe == busTrip.MaChuyenXe).ToListAsync();
_context.Vexes.RemoveRange(ticketsByBusTrip);
}
// Delete all trips that relations with this bus
_context.Chuyenxes.RemoveRange(busTrips);
// Delete this bus
_context.Xes.Remove(bus);
await _context.SaveChangesAsync();
}
public static Boolean CapNhatTrangThaiXeDangChay()
{
var entity = new QuanLyThueXeEntities();
try
{
var hd = entity.HopDongs.Where(n => n.MaTrangThai == "1");
foreach (var item in hd)
{
var cthd = entity.CT_HopDongs.Where(n => n.SoHopDong == item.SoHopDong);
foreach (var c in cthd)
{
if (c.NgayDi < DateTime.Now)
{
Xe result = entity.Xes.SingleOrDefault(n => n.MaXe == c.MaXe);
result.Status = "2";
}
}
}
entity.SaveChanges();
return(true);
}
catch (Exception ex)
{
entity.Dispose();
return(false);
}
}
public void editXe(Xe x)
{
try
{
openConnection();
SqlCommand cmd = new SqlCommand("SuaXe", Conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ID_Xe", x.ID_Xe);
cmd.Parameters.AddWithValue("@ID_HangXe", x.ID_HangXe);
cmd.Parameters.AddWithValue("@BienSoXe", x.BienSoXe);
cmd.Parameters.AddWithValue("@DoiXe", x.DoiXe);
cmd.Parameters.AddWithValue("@SoKhung", x.SoKhung);
cmd.Parameters.AddWithValue("@SoMay", x.SoMay);
cmd.Parameters.AddWithValue("@SoKM", x.SoKM);
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
new Exception("Error: " + ex.Message);
}
finally
{
closeConnection();
}
}
protected void Page_Load(object sender, EventArgs e)
{
var Id = Request["ID"];
var idNull = string.IsNullOrEmpty(Id);
var logged = Security.IsAuthenticated();
Item = new Xe();
view.Visible = false;
Missing.Visible = true;
using (var con = DAL.con())
{
if (!idNull)
{
Item = logged
? XeDal.SelectByIdUsername(con, Convert.ToInt32(Id), Security.Username)
: XeDal.SelectById(con, Convert.ToInt64(Id));
Item.Anhs = AnhDal.SelectByPId(con, Item.RowId.ToString(), 20);
Item.Member = MemberDal.SelectByUser(con, Item.NguoiTao);
view.Pager = BinhLuanDal.PagerByPRowId(con, "", true, Item.RowId.ToString(), 20);
var pagerBlog = BlogDal.PagerByPRowId(string.Empty, false, null, Item.RowId.ToString(),
Security.Username);
view.PagerBlog = pagerBlog;
view.Item = Item;
if (Item.Id == 0)
{
return;
}
view.Visible = true;
Missing.Visible = false;
}
}
}
public bool updateXe(Xe xe)
{
using (var db = new QLHTGTEntities())
{
try
{
Xe xeUpdate = db.Xes.Find(xe.ID);
if (xe == null)
{
return(false);
}
xeUpdate.SoKhung = xe.SoKhung;
xeUpdate.SoMay = xe.SoMay;
xeUpdate.NguoiDung_id = xe.NguoiDung_id;
xeUpdate.LoaiXe_id = xe.LoaiXe_id;
xeUpdate.GiaTien = xe.GiaTien;
db.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
Add.IsAdmin = true;
var Id = Request["ID"];
var idNull = string.IsNullOrEmpty(Id);
var Item = new Xe()
{
RowId = Guid.NewGuid()
};
using (var con = DAL.con())
{
if (!idNull)
{
Item = XeDal.SelectById(con, Convert.ToInt32(Id));
Item.Anhs = AnhDal.SelectByPId(con, Item.RowId.ToString(), 20);
}
Add.Item = Item;
var hangXeList = DanhMucDal.SelectByLDMMa(con, "HANGXE");
if (Cache["HANGXE"] == null)
{
Cache.Insert("HANGXE", hangXeList);
}
var hangList = (from p in hangXeList
where p.PID == Guid.Empty
select p).OrderBy(m => m.ThuTu).ToList();
Add.HangList = hangList;
Add.ThanhPhoList = DanhMucDal.SelectByLDMMa(con, "KHUVUC");
}
}
public IHttpActionResult ChangeStatus(string _maxe)
{
try
{
using (var db = new DB())
{
using (var transaction = db.Database.BeginTransaction())
{
Xe xe = db.Xes.FirstOrDefault(x => x.maxe == _maxe);
if (xe == null)
{
return(BadRequest("Xe không tồn tại"));
}
if (xe.trangthai == (int)Constant.KHOA)
{
xe.trangthai = (int)Constant.HOATDONG;
}
else
{
xe.trangthai = (int)Constant.KHOA;
}
db.SaveChanges();
transaction.Commit();
return(Ok(_maxe));
}
}
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
public IHttpActionResult Post(Xe xe)
{
try
{
using (var db = new DB())
{
using (var transaction = db.Database.BeginTransaction())
{
if (string.IsNullOrEmpty(xe.maxe))
{
return(BadRequest("Mã xe không hợp lệ"));
}
Xe _xe = db.Xes.FirstOrDefault(x => x.maxe == xe.maxe);
if (_xe != null)
{
return(BadRequest("Mã xe đã tồn tại"));
}
db.Xes.Add(xe);
db.SaveChanges();
transaction.Commit();
return(Ok(xe));
}
}
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
public ActionResult Create(XeViewModel viewModel, HttpPostedFileBase chonHinh)
{
if (chonHinh != null)
{
string fileName = Path.GetFileNameWithoutExtension(chonHinh.FileName);
string extensions = Path.GetExtension(chonHinh.FileName);
fileName = fileName + DateTime.Now.ToString("yymmssfff") + extensions;
viewModel.Hinh = "~/Content/images/" + fileName;
chonHinh.SaveAs(Path.Combine(Server.MapPath("~/Content/images/"), fileName));
}
var xe = new Xe
{
Ten = viewModel.Ten,
MoTa = viewModel.MoTa,
Gia = viewModel.Gia,
Hinh = viewModel.Hinh,
DanhGia = viewModel.DanhGia,
ThoiGian = viewModel.ThoiGian,
LoaiXeId = viewModel.LoaiXe,
TrangThai = true,
NoiBat = viewModel.NoiBat
};
_dbContext.Xes.Add(xe);
_dbContext.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult ThemmoiXe(Xe xe, HttpPostedFileBase fileUpload)
{
ViewBag.MaNSX = new SelectList(db.NhaSanXuats.ToList().OrderBy(n => n.TenNSX), "MaNSX", "TenNSX");
if (fileUpload == null)
{
ViewBag.Thongbao = "Vui lòng chọn ảnh bìa!";
return(View());
}
else
{
if (ModelState.IsValid)
{
var fileName = Path.GetFileName(fileUpload.FileName);
var path = Path.Combine(Server.MapPath("~/Hinhsanpham"), fileName);
if (System.IO.File.Exists(path))
{
ViewBag.Thongbao = "Hình ảnh đã tồn tại";
}
else
{
fileUpload.SaveAs(path);
}
xe.Anh = fileName;
db.Xes.InsertOnSubmit(xe);
db.SubmitChanges();
}
}
return(RedirectToAction("Xe"));
}
private void btnLuu_Click(object sender, EventArgs e)
{
if (KiemTra())
{
Xe xe = new Xe();
try
{
xe.TenChuXe = txtTenChuXe.Text;
xe.BienSo = txtBienSo.Text;
xe.DiaChi = txtDiaChi.Text;
xe.Email = txtEmail.Text;
xe.DienThoai = txtDienThoai.Text;
xe.HieuXe = cbHieuXe.SelectedValue.ToString();
xe.NgayTiepNhan = dateNgayTiepNhan.Text;
//xe.TienNo = 0;
XeBUS.Xe_Insert(xe);
tableTiepNhanXe.DataSource = XeBUS.Xe_DanhSach();
//tableTiepNhanXe.DataSource = XeBUS.Xe_DSTheoNgay(dateNgayTiepNhan.Text);
// tableTiepNhanXe.DataSource = XeBUS.Xe_DSTheoNgay(xe.NgayTiepNhan.ToString());
MessageBox.Show("Nhập thành công !!");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
SQLDataProvider.connection.Close();
}
btnXoa.Enabled = false;
//btnThemMoi.Enabled = true;
}
}
protected void GridView3_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
//tham chieu den các đối tượng tai dong hieu chinh hien tai
TextBox txt_HopSo = GridView3.Rows[e.RowIndex].Cells[3].Controls[0] as TextBox;
TextBox txt_KTTongThe = GridView3.Rows[e.RowIndex].Cells[4].Controls[0] as TextBox;
TextBox txt_TrongLuong = GridView3.Rows[e.RowIndex].Cells[5].Controls[0] as TextBox;
TextBox txt_ChieuDai = GridView3.Rows[e.RowIndex].Cells[6].Controls[0] as TextBox;
TextBox txt_ChieuRong = GridView3.Rows[e.RowIndex].Cells[7].Controls[0] as TextBox;
//chuan bi
int Ma_Xe_dangsua = (int)GridView3.DataKeys[e.RowIndex].Value;
LinQtoSQLDataContext tam_context = new LinQtoSQLDataContext();
Xe obj = tam_context.Xes.SingleOrDefault(chungloaisp => chungloaisp.Ma_Xe == Ma_Xe_dangsua);
obj.Ma_Xe = Ma_Xe_dangsua;
obj.Hop_So = txt_HopSo.Text;
obj.KT_Tong_The = txt_KTTongThe.Text;
obj.Trong_Luong = int.Parse(txt_TrongLuong.Text);
obj.Chieu_Dai = int.Parse(txt_ChieuDai.Text);
obj.Chieu_Rong = int.Parse(txt_ChieuRong.Text);
//thuc hien
tam_context.SubmitChanges();
GridView3.EditIndex = -1;
show_chungloai3();
}
//THêm giỏ hàng
public ActionResult ThemGioHang(string iMaXe, string strURL)
{
Xe xe = db.Xes.SingleOrDefault(n => n.MaXe == iMaXe);
if (xe == null)
{
Response.StatusCode = 404;
return(null);
}
//Lấy ra session giỏ hàng
List <GioHang> listGioHang = LayGioHang();
//Kiem tra Xe này đã tồn tại trong session[giohang] chưa
GioHang sanpham = listGioHang.Find(n => n.iMaXe == iMaXe);
if (sanpham == null)
{
sanpham = new GioHang(iMaXe);
//Add san pham moi them vao list
listGioHang.Add(sanpham);
return(Redirect(strURL));
}
else
{
sanpham.iSoLuong++;
return(Redirect(strURL));
}
}
private void btThem_Click(object sender, EventArgs e)
{
Xe xe = new Xe();
xe.Biensoxe = txtBSX.Text;
xe.idLoaiXe = (int)cbbLoaiXe.SelectedValue;
xe.TenXe = txtTenXe.Text;
xe.PhiXang = txtPhiXang.Text;
xe.PhiQuaKm = txtPhiQuaKm.Text;
xe.DonGia = txtDonGia.Text;
xe.MoTaTT = txtMoTaTT.Text;
xe.TrangThai = int.Parse(txtTrangThai.Text);
if (XeController.AddXe(xe))
{
XtraMessageBox.Show("Thêm thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
XtraMessageBox.Show("Thêm thất bại", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
CNPMEntities context = new CNPMEntities();
List <Xe> listXe = context.Xes.ToList();
BindGrid(listXe);
}
public fXeInf(Xe x)
{
this.XeDangChon = x;
InitializeComponent();
LoadHieuXe();
ShowXeInf();
}
public List <Xe> LayMaXe(string manv)
{
List <Xe> listXe = new List <Xe>();
var lstXe = db.spXe_SelectName(manv).ToList();
foreach (var n in lstXe)
{
Xe xe = new Xe()
{
MaXe = n.MaXe,
KieuXe = n.KieuXe,
TenXe = n.TenXe,
HinhAnh = n.HinhAnh,
SoLuong = n.SoLuong,
Mau = n.Mau,
LoaiDongCo = n.LoaiDongCo,
MaLuc = n.MaLuc,
MomenXoan = n.MomenXoan,
TocDoToiDa = n.TocDoToiDa,
SuTangToc = n.SuTangToc,
NgayNhap = n.NgayNhap,
GiaXe = n.GiaXe,
MaGiamGia = n.MaGiamGia
};
listXe.Add(xe);
}
return(listXe);
}
private void backgroundWorker2_RunWorkerCompleted(object sender, RunWorkerCompletedEventArgs e)
{
cbxLoaiXe.SelectedValue = 0;
drlBienSo.Focus();
Debug.WriteLine(XeVaoBenInsertRs == 0 ? string.Format("Lỗi: {0}", XeVaoBenInsertRs) : string.Format("ID: {0}", XeVaoBenInsertRs));
backgroundWorker2.Dispose();
backgroundWorker4.RunWorkerAsync();
// binding new item
if (XeId == 0 && !backgroundWorker1.IsBusy)
{
#region Plain solution: Just add new item to exists list without update to server
var xe = new Xe()
{
BienSo = BienSoStr
,
LOAIXE_ID = LoaiXeInt
};
XeList.Insert(1, xe);
XeListStrArray = XeList.Select(x => x.BienSo.ToLower()).ToArray();
#endregion
#region Chance to get new list
//backgroundWorker1.RunWorkerAsync();
#endregion
}
}
public async Task <Response> Add(Xe xe)
{
var rp = new Response {
ResultCode = ResultCode.Error, Message = "Thêm xe không thành công"
};
try
{
xe.Ref = Guid.NewGuid().ToString();
await _db.Xe.AddAsync(xe);
var rs = await _db.SaveChangesAsync();
if (rs <= 0)
{
return(rp);
}
rp.ResultCode = ResultCode.Success;
rp.Message = "Thêm xe thành công";
return(rp);
}
catch (Exception e)
{
if (e.InnerException is SqlException sqlEx)
{
if (sqlEx.Number == 2601 || sqlEx.Number == 2627)
{
rp.Message = $"Xe có biển số {xe.BienSoXe} đã tồn tại";
}
}
// Console.WriteLine(e.ToString());
return(rp);
}
}
private void btnXoa_Click(object sender, EventArgs e)
{
try
{
Xe xe = new Xe()
{
BienSo = txtBienSo.Text
};
XeBUS.Xe_Delete(xe);
MessageBox.Show("Xóa thành công!!");
tableTiepNhanXe.DataSource = XeBUS.Xe_DanhSach();
txtBienSo.Text = "";
txtDiaChi.Text = "";
txtDienThoai.Text = "";
txtEmail.Text = "";
txtTenChuXe.Text = "";
cbHieuXe.SelectedIndex = 0;
txtBienSo.Focus();
}
catch (Exception)
{
MessageBox.Show("Không thể xóa xe đang sửa chữa!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
btnXoa.Enabled = false;
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
//tham chieu den các đối tượng tai dong hieu chinh hien tai
TextBox txt_LoaiDongCo = GridView1.Rows[e.RowIndex].Cells[3].Controls[0] as TextBox;
TextBox txt_DungTich_Xilanh = GridView1.Rows[e.RowIndex].Cells[4].Controls[0] as TextBox;
TextBox txt_DungTich_NL = GridView1.Rows[e.RowIndex].Cells[5].Controls[0] as TextBox;
TextBox txt_CongSuat = GridView1.Rows[e.RowIndex].Cells[6].Controls[0] as TextBox;
TextBox txt_Moment = GridView1.Rows[e.RowIndex].Cells[7].Controls[0] as TextBox;
TextBox txt_TocDoToiDa = GridView1.Rows[e.RowIndex].Cells[8].Controls[0] as TextBox;
//chuan bi
int Ma_Xe_dangsua = (int)GridView1.DataKeys[e.RowIndex].Value;
LinQtoSQLDataContext tam_context = new LinQtoSQLDataContext();
Xe obj = tam_context.Xes.SingleOrDefault(chungloaisp => chungloaisp.Ma_Xe == Ma_Xe_dangsua);
obj.Ma_Xe = Ma_Xe_dangsua;
obj.Loai_Dong_Co = txt_LoaiDongCo.Text;
obj.Dung_Tich = txt_DungTich_Xilanh.Text;
obj.Dung_Tich_Nhien_Lieu = int.Parse(txt_DungTich_NL.Text);
obj.Cong_Suat = txt_CongSuat.Text;
obj.Mo_men = txt_Moment.Text;
obj.Van_Toc_Toi_Da = int.Parse(txt_TocDoToiDa.Text);
//thuc hien
tam_context.SubmitChanges();
GridView1.EditIndex = -1;
show_chungloai1();
}
private void btThem_Click(object sender, EventArgs e)
{
if (nudSoLuong.Value > 0)
{
decimal gia = Convert.ToDecimal(lvDSXe.SelectedItems[0].SubItems[7].Text);
int sl = Convert.ToInt32(nudSoLuong.Value.ToString());
decimal tong = gia * sl;
lvi = new ListViewItem();
lvi.Text = lbXuatMaHoaDon.Text;
lvi.SubItems.Add(lvDSXe.SelectedItems[0].SubItems[0].Text);
lvi.SubItems.Add(lvDSXe.SelectedItems[0].SubItems[1].Text);
lvi.SubItems.Add(sl.ToString());
lvi.SubItems.Add(gia.ToString());
lvi.SubItems.Add(tong.ToString());
lvi.SubItems.Add(dtmNgayHD.Value.ToShortDateString());
lvi.SubItems.Add(lvDSXe.SelectedItems[0].SubItems[0].Text);
CTHDController.cthd_moi = CTHDC.themCTHD(lvi);
lvXeDaChon.Items.Add(CTHDController.cthd_moi);
Xe x = new Xe();
x = db.Xes.Where(s => s.maXe == lvDSXe.SelectedItems[0].SubItems[0].Text).Single();
x.soLuong -= sl;
db.SubmitChanges();
capNhap();
lvDSXe.SelectedItems.Clear();
nudSoLuong.Enabled = false;
nudSoLuong.Value = 0;
tinh_tong_tien_listview();
}
else
{
MessageBox.Show("Nhập Số Lượng Lớn Hơn 0", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public async Task <IActionResult> PutXe(string id, Xe xe)
{
if (id != xe.MaXe)
{
return(BadRequest());
}
_context.Entry(xe).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!XeExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public ActionResult Create(PhieuTiepNhan_Xe phieuTiepNhan_Xe)
{
if (ModelState.IsValid)
{
Xe xe = new Xe();
PhieuTiepNhan phieuTiepNhan = new PhieuTiepNhan();
//Add 1 xe
xe.IDBienSo = phieuTiepNhan_Xe.IDBienSo;
xe.TenChuXe = phieuTiepNhan_Xe.TenChuXe;
xe.IDHieuXe = phieuTiepNhan_Xe.IDHieuXe;
xe.DiaChi = phieuTiepNhan_Xe.DiaChi;
xe.DienThoai = phieuTiepNhan_Xe.DienThoai;
db.Xes.Add(xe);
db.SaveChanges();
//Add 1 Phieu tiep nhan
int latestIDXe = xe.IDBienSo;
phieuTiepNhan.IDBienSo = latestIDXe;
phieuTiepNhan.NgayTiepNhan = phieuTiepNhan_Xe.NgayTiepNhan;
db.PhieuTiepNhans.Add(phieuTiepNhan);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.IDHieuXe = new SelectList(db.HieuXes, "IDHieuXe", "TenHieuXe", db.HieuXes.First().TenHieuXe);
return(View(phieuTiepNhan_Xe));
}
public async Task <IActionResult> Create(XeViewModel model, string userEmail)
{
if (userEmail != null)
{
string uniqueFileName = ProcessUpLoadedFile(model);
string uniqueFileName1 = ProcessUpLoadedFile1(model);
string uniqueFileName2 = ProcessUpLoadedFile2(model);
string uniqueFileName3 = ProcessUpLoadedFile3(model);
var check = IsValid(uniqueFileName);
var check1 = IsValid(uniqueFileName1);
var check2 = IsValid(uniqueFileName2);
var check3 = IsValid(uniqueFileName3);
if (!check && !check1 && !check2 && !check3)
{
ViewData["DongXeId"] = new SelectList(_context.DongXe, "DongXeId", "TenDongXe", model.DongXeId);
ViewData["NhaSanXuatId"] = new SelectList(_context.NhaSanXuat, "NhaSanXuatId", "TenNSX", model.DongXeId);
ViewData["LoaiXeId"] = new SelectList(_context.LoaiXe, "LoaiXeId", "TenLoaiXe", model.LoaiXeId);
ViewData["MauXeId"] = new SelectList(_context.MauXe, "MauXeId", "TenMauXe", model.MauXeId);
ViewData["TinhId"] = new SelectList(_context.Tinh, "TinhId", "TenTinh", model.TinhId);
return(View(model));
}
//var xe = new Xe();
if (ModelState.IsValid)
{
Xe xe = new Xe
{
TinhId = model.TinhId,
Mau = _context.MauXe.FirstOrDefault(c => c.MauXeId == model.MauXeId).TenMauXe,
LoaiXeId = model.LoaiXeId,
GiaTheoGio = model.GiaTheoGio,
GiaTheoNgay = model.GiaTheoNgay,
DangKinhDoanh = model.DangKinhDoanh,
DongXeId = model.DongXeId,
Tittle = model.Tittle,
ImageDauXe = uniqueFileName,
ImageDuoiXe = uniqueFileName,
ImageNoiThatXe = uniqueFileName,
ImageThanXe = uniqueFileName,
NamSx = model.NamSx
};
_context.Add(xe);
await _context.SaveChangesAsync();
return(RedirectToAction("Index", "ViewXe"));
}
ViewData["DongXeId"] = new SelectList(_context.DongXe, "DongXeId", "TenDongXe", model.DongXeId);
ViewData["NhaSanXuatId"] = new SelectList(_context.NhaSanXuat, "NhaSanXuatId", "TenNSX", model.DongXeId);
ViewData["LoaiXeId"] = new SelectList(_context.LoaiXe, "LoaiXeId", "TenLoaiXe", model.LoaiXeId);
ViewData["MauXeId"] = new SelectList(_context.MauXe, "MauXeId", "TenMauXe", model.MauXeId);
ViewData["TinhId"] = new SelectList(_context.Tinh, "TinhId", "TenTinh", model.TinhId);
return(View(model));
}
else
{
return(RedirectToAction("Login", "Account"));
}
}
public ActionResult ThemXe(Xe xe)
{
try
{
var dsTinhTrangXe = database.TinhTrangXes.ToList();
var dsLoaiXe = database.LoaiXes.ToList();
var dsHieuXe = database.HieuXes.ToList();
ViewBag.DsTinhTrangXe = new SelectList(dsTinhTrangXe, "maTinhTrangXe", "tenTinhTrangXe");
ViewBag.DsLoaiXe = new SelectList(dsLoaiXe, "maLoaiXe", "tenLoaiXe");
ViewBag.DsHieuXe = new SelectList(dsHieuXe, "maHieuXe", "tenHieuXe");
if (xe.UploadImage != null)
{
string filename = Path.GetFileNameWithoutExtension(xe.UploadImage.FileName);
string extent = Path.GetExtension(xe.UploadImage.FileName);
filename = filename + extent;
xe.hinh = "/Content/images/" + filename;
xe.UploadImage.SaveAs(Path.Combine(Server.MapPath("~/Content/images/"), filename));
}
database.Xes.Add(xe);
database.SaveChanges();
SaveToMainFolder(xe.maXe);
return(RedirectToAction("QuanLyXe"));
}
catch
{
return(View("ThemXe", xe));
}
}
public IHttpActionResult Put(Xe xe)
{
try
{
using (var db = new DB())
{
using (var transaction = db.Database.BeginTransaction())
{
Xe oldxe = db.Xes.FirstOrDefault(x => x.maxe == xe.maxe);
if (oldxe == null)
{
return(BadRequest("Mã xe không tồn tại"));
}
oldxe.soghe = xe.soghe;
oldxe.ghichu = xe.ghichu;
oldxe.biensoxe = xe.biensoxe;
oldxe.trangthai = xe.trangthai;
db.SaveChanges();
transaction.Commit();
return(Ok(xe));
}
}
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
private void frmRaHoatDong_Load(object sender, EventArgs e)
{
if (ThongTinDangNhap.USER_ID.Length <= 0)
{
new MessageBox.MessageBox().Show(this, "Bạn cần đăng nhập hệ thống để sử dụng chức năng này.", "Thông báo", Taxi.MessageBox.MessageBoxButtons.OK, Taxi.MessageBox.MessageBoxIcon.Warning);
this.Close();
}
timeServer = DieuHanhTaxi.GetTimeServer();
if (timeServer != DateTime.MinValue)
{
editThoiDiemBao.Text = string.Format("{0: HH:mm:ss dd/MM/yyyy}", timeServer);
editThoiDiemBao.ReadOnly = true;
}
editSoHieuXe.Focus();
if (mKieuBao == 4)
{
Xe objXe = new Xe();
editViTriBao.Text = objXe.GetChiTietXe(editSoHieuXe.Text).GaraName;
if (StringTools.TrimSpace(editViTriBao.Text).Length <= 0)
{
editViTriBao.Text = "Gara";
}
}
}
public IHttpActionResult Detail(string _maxe)
{
try
{
using (var db = new DB())
{
Xe xe = db.Xes.FirstOrDefault(x => x.maxe == _maxe);
if (xe == null)
{
return(BadRequest("Xe không tồn tại"));
}
return(Ok(new
{
xe.ghichu,
xe.maxe,
xe.soghe,
xe.trangthai,
xe.biensoxe
}));
}
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
public IHttpActionResult PutXe(string id, Xe xe)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != xe.bien_so_xe)
{
return(BadRequest());
}
db.Entry(xe).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!XeExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
protected void Page_Load(object sender, EventArgs e)
{
var Id = Request["PID_ID"];
var idNull = string.IsNullOrEmpty(Id);
Item = new Xe();
using (var con = DAL.con())
{
if (!idNull)
{
Item = XeDal.SelectByIdUsername(con, Convert.ToInt32(Id), Security.Username);
Item.Anhs = AnhDal.SelectByPId(con, Item.RowId.ToString(), 20);
Item.Member = MemberDal.SelectByUser(con, Item.NguoiTao);
var pagerBlog = BlogDal.PagerByPRowIdFull(con, string.Empty, false, null, Item.RowId.ToString(),
Security.Username);
ListForCarFull.Pager = pagerBlog;
}
ListForCarFull.Item = Item;
}
}
protected void Page_Load(object sender, EventArgs e)
{
var Id = Request["ID"];
var idNull = string.IsNullOrEmpty(Id);
Item = new Xe();
using (var con = DAL.con())
{
if (!idNull)
{
var blog = BlogDal.SelectById(con, Convert.ToInt64(Id), Security.Username);
Item = XeDal.SelectByRowIdUsername(con, blog.PID_ID, Security.Username);
//blog.Xe = Item;
Blog = blog;
Item.Anhs = AnhDal.SelectByPId(con, Item.RowId.ToString(), 20);
Item.Member = MemberDal.SelectByUser(con, Item.NguoiTao);
viewForCar.Pager = BinhLuanDal.PagerByPRowId(con, "", true, blog.RowId.ToString(), 20);
viewForCar.Blog = blog;
}
viewForCar.Item = Item;
}
}
protected void Page_Load(object sender, EventArgs e)
{
var pooledClientManager = new PooledRedisClientManager("localhost");
var client = pooledClientManager.GetClient();
var Ten = Request["Ten"];
var PID_ID = Request["PID_ID"];
var Loai = Request["Loai"];
var Id = Request["Id"];
var cUrl = Request["cUrl"];
var rowId = Request["RowId"];
var noiDung = Request["NoiDung"];
var approved = Request["approved"];
var logged = Security.IsAuthenticated();
var idNull = string.IsNullOrEmpty(Id) || Id == "0";
var blogRedis = new BlogRedis(client);
var memberRedis = new MemberRedis(client);
var nhomRedis = new NhomRedis(client);
var xeRedis = new XeRedis(client);
switch (subAct)
{
case "save":
#region save blog
if (logged && !string.IsNullOrEmpty(PID_ID) && !string.IsNullOrEmpty(Loai))
{
var item = idNull ? new Blog() : BlogDal.SelectById(Convert.ToInt64(Id));
var member = new Member();
var xe = new Xe();
var nhom = new Nhom();
var nguoiTao = new Member();
item.NoiDung = noiDung;
item.Ten = Ten;
if (!string.IsNullOrEmpty(Loai))
{
item.Loai = Convert.ToInt32(Loai);
}
if (!string.IsNullOrEmpty(PID_ID))
{
item.PID_ID = new Guid(PID_ID);
}
if (!string.IsNullOrEmpty(rowId))
{
item.RowId = new Guid(rowId);
}
item.MoTa = Lib.Rutgon(Lib.NoHtml(item.NoiDung), 400);
var anhs = AnhDal.SelectByPId(DAL.con(), item.RowId.ToString(), 20).OrderByDescending(x => x.AnhBia).ToList();
if (anhs.Count > 0)
{
var sb = new StringBuilder();
foreach (var anhItem in anhs)
{
sb.AppendFormat(@"<a href=""{1}""><img alt=""{0}"" src=""/lib/up/car/{0}?w=75"" /></a>" , anhItem.FileAnh, item.Url);
item.AnhList.Add(anhItem.Id);
}
item.AnhStr = sb.ToString();
}
switch (item.Loai)
{
case 1:
member = memberRedis.GetByRowId(item.PID_ID);
break;
case 2:
xe = xeRedis.GetByRowId(item.PID_ID);
break;
case 3:
case 4:
case 5:
//item.Nhom = NhomDal.SelectByRowId(DAL.con(), item.PID_ID, Security.Username);
nhom = nhomRedis.GetByRowId(item.PID_ID);
break;
}
if (idNull)
{
item.NguoiTao = Security.Username;
item.NgayTao = DateTime.Now;
var insert = BlogDal.Insert(item);
item.Id = insert.Id;
item.NguoiThich.Insert(0, item.NguoiTao);
nguoiTao = memberRedis.GetByUsername(item.NguoiTao);
switch (item.Loai)
{
case 1:
if(member!= null)
{
member.TotalBlog += 1;
member.BlogIds.Insert(0, item.Id);
memberRedis.Save(member);
MemberDal.Update(member);
}
break;
case 2:
if (xe != null)
{
xe.BlogIds.Insert(0, item.Id);
xe.TotalBlog += 1;
xeRedis.Save(xe);
XeDal.Update(xe);
}
CacheHelper.Remove(string.Format(XeDal.CacheItemKey,item.Id));
systemMessageDal.Insert(new systemMessage()
{
NoiDung = string.Format("<strong>{0}</strong> viết bài mới", nguoiTao.Ten)
,
HeThong = false
,
Id = Guid.NewGuid()
,
PRowId = item.PID_ID
,
NgayTao = DateTime.Now
,
Active = true
,
Loai = 1
,
Url = string.Format("{0}", item.Url)
,
Ten = string.Empty
,
ThanhVienMoi = false
,
Username = Security.Username
,
ThuTu = 0
});
break;
case 3:
case 4:
case 5:
nhom.TotalBlog += 1;
if(item.Loai==3)
{
nhom.BlogIds.Insert(0, item.Id);
}
else
{
nhom.ForumBlogIds.Insert(0, item.Id);
}
nhomRedis.Save(nhom);
if (nhom.NhomMo)
{
item.Publish = true;
}
systemMessageDal.Insert(new systemMessage()
{
NoiDung = string.Format("<strong>{0}</strong> viết bài mới", nguoiTao.Ten)
,
HeThong = false
,
Id = Guid.NewGuid()
,
PRowId = item.PID_ID
,
NgayTao = DateTime.Now
,
Active = true
,
Loai = 1
,
Url = string.Format("{0}", item.Url)
,
Ten = string.Empty
,
ThanhVienMoi = false
,
Username = Security.Username
,
ThuTu = 0
});
NhomDal.Update(nhom);
BlogDal.Update(item);
break;
}
ObjMemberDal.Insert(new ObjMember()
{
PRowId = item.RowId
,
Username = Security.Username
,
Owner = true
,
NgayTao = DateTime.Now
,
RowId = Guid.NewGuid()
});
var obj = ObjDal.Insert(new Obj()
{
Id = Guid.NewGuid()
,
Kieu = typeof(Blog).FullName
,
NgayTao = DateTime.Now
,
RowId = item.RowId
,
Url = string.Format("{0}", item.Url)
,
Username = Security.Username
});
}
else
{
nguoiTao = memberRedis.GetByUsername(item.NguoiTao);
BlogDal.Update(item);
}
switch (item.Loai)
{
case 1:
if (member != null)
{
item.Url = string.Format("{0}/blogs/{1}/", member.Url, item.Id);
item.UrlEdit = string.Format("{0}/blogs/edit/{1}/", member.Url, item.Id);
}
break;
case 2:
if (xe != null)
{
item.Url = string.Format("{0}blogs/{1}/", xe.XeUrl, item.Id);
item.UrlEdit = string.Format("{0}blogs/edit/{1}/", xe.XeUrl, item.Id);
}
break;
case 3:
if (nhom != null)
{
item.Url = string.Format("{0}blogs/{1}/", nhom.Url, item.Id);
item.UrlEdit = string.Format("{0}blogs/edit/{1}/", nhom.Url, item.Id);
}
break;
case 4:
if (nhom != null)
{
item.Url = string.Format("{0}forum/{1}/", nhom.Url, item.Id);
item.UrlEdit = string.Format("{0}blogs/edit/{1}/", nhom.Url, item.Id);
}
break;
case 5:
if (nhom != null)
{
item.Url = string.Format("{0}qa/{1}/", nhom.Url, item.Id);
item.UrlEdit = string.Format("{0}blogs/edit/{1}/", nhom.Url, item.Id);
}
break;
}
blogRedis.Save(item);
SearchManager.Add(item.Ten, string.Format("{0} {1}", item.Ten, item.NoiDung), string.Empty, item.RowId.ToString(), item.Url, typeof(Blog).Name);
rendertext(item.Url);
}
rendertext("0");
break;
#endregion
case "remove":
#region remove blog
if(!string.IsNullOrEmpty(Id) && logged)
{
var item = BlogDal.SelectById(Convert.ToInt64(Id));
if(item.NguoiTao==Security.Username)
{
SearchManager.Remove(item.RowId);
ObjDal.DeleteByRowId(item.RowId);
ObjMemberDal.DeleteByPRowId(item.RowId.ToString());
ThichDal.DeleteByPId(item.RowId);
CacheHelper.Remove(string.Format(BlogDal.CacheItemKey, item.Id));
BlogDal.DeleteById(item.Id);
blogRedis.Remove(item.Id);
rendertext("1");
}
}
break;
#endregion
case "nhomDuyetBlog":
#region duyet blog of Nhom
if (!string.IsNullOrEmpty(Id) && logged && !string.IsNullOrEmpty(approved))
{
var Approved = approved == "1";
var item = blogRedis.GetById(Convert.ToInt64(Id));
if(Approved)
{
item.Publish = true;
BlogDal.Update(item);
blogRedis.Save(item);
}
else
{
blogRedis.Save(item);
BlogDal.DeleteById(item.Id);
}
}
break;
#endregion
}
}
protected void Page_Load(object sender, EventArgs e)
{
var Id = Request["Id"];
var newDic = Server.MapPath("~/lib/up/car/");
var DM_PID = Request["DM_PID"];
var logged = Security.IsAuthenticated();
var js = new JavaScriptSerializer();
var adminKey = Request["AdminKey"];
var DangLai = Request["DangLai"];
var Gia = Request["Gia"];
var GioiThieu = Request["GioiThieu"];
var HANG_ID = Request["HANG_ID"];
var MODEL_ID = Request["MODEL_ID"];
var HopSo = Request["HopSo"];
var Nam = Request["Nam"];
var RaoBan = Request["RaoBan"];
var RowId = Request["RowId"];
var SubModel = Request["SubModel"];
var Ten = Request["Ten"];
var TinhTrang = Request["TinhTrang"];
var XuatXu = Request["XuatXu"];
var DONGXE_ID = Request["DONGXE_ID"];
var MAUNGOAITHAT_ID = Request["MAUNGOAITHAT_ID"];
var MAUNOITHAT_ID = Request["MAUNOITHAT_ID"];
var KIEUDANDONG_ID = Request["KIEUDANDONG_ID"];
var NHIENLIEU_ID = Request["NHIENLIEU_ID"];
var THANHPHO_ID = Request["THANHPHO_ID"];
var Anh = Request["Anh"];
var Duyet = Request["Duyet"];
switch (subAct)
{
case "GetModelByHangXe":
#region get models by car manufacture
if(DM_PID!= null)
{
var allModel = DanhMucDal.SelectByLdmMaFromCache("HANGXE");
var filterModel = (from p in allModel
where p.PID == new Guid(DM_PID)
select p).OrderByDescending(m => m.ThuTu).ToList();
rendertext(js.Serialize(filterModel));
}
break;
#endregion
case "save":
#region Save
if (logged)
{
RaoBan = !string.IsNullOrEmpty(RaoBan) ? "true" : "false";
DangLai = !string.IsNullOrEmpty(DangLai) ? "true" : "false";
Gia = string.IsNullOrEmpty(Gia) ? "0" : Gia;
var isInserting = false;
if (Id == "0")
Id = "";
var idNull = string.IsNullOrEmpty(Id);
var car = new Xe();
if (idNull)
{
if (!string.IsNullOrEmpty(RowId))
{
car = XeDal.SelectByRowId(RowId);
if (car.Id == 0)
{
isInserting = true;
}
else
{
isInserting = true;
}
}
}
car = idNull ? (isInserting ? new Xe() : XeDal.SelectByRowId(RowId)) : XeDal.SelectById(Convert.ToInt64(Id));
car.Ten = Ten;
car.DangLai = Convert.ToBoolean(DangLai);
if (!string.IsNullOrEmpty(Duyet))
{
Duyet = !string.IsNullOrEmpty(Duyet) ? "true" : "false";
car.Duyet = Convert.ToBoolean(Duyet);
car.NguoiDuyet = Security.Username;
car.NgayDuyet = DateTime.Now;
}
car.GioiThieu = GioiThieu;
car.Gia = Convert.ToInt32(Gia);
if(!string.IsNullOrEmpty(HANG_ID))
{
car.HANG_ID = new Guid(HANG_ID);
}
if (!string.IsNullOrEmpty(MODEL_ID))
{
car.MODEL_ID = new Guid(MODEL_ID);
}
if(!string.IsNullOrEmpty(HopSo))
{
car.HopSo = Convert.ToBoolean(HopSo);
}
if (!string.IsNullOrEmpty(TinhTrang))
{
car.TinhTrang = Convert.ToBoolean(TinhTrang);
}
if (!string.IsNullOrEmpty(XuatXu))
{
car.XuatXu = Convert.ToBoolean(XuatXu);
}
if (!string.IsNullOrEmpty(DONGXE_ID))
{
car.DONGXE_ID = new Guid(DONGXE_ID);
}
//
if (!string.IsNullOrEmpty(MAUNGOAITHAT_ID))
{
car.MAUNGOAITHAT_ID = new Guid(MAUNGOAITHAT_ID);
}
if (!string.IsNullOrEmpty(MAUNOITHAT_ID))
{
car.MAUNOITHAT_ID = new Guid(MAUNOITHAT_ID);
}
if (!string.IsNullOrEmpty(KIEUDANDONG_ID))
{
car.KIEUDANDONG_ID = new Guid(KIEUDANDONG_ID);
}
if (!string.IsNullOrEmpty(NHIENLIEU_ID))
{
car.NHIENLIEU_ID = new Guid(NHIENLIEU_ID);
}
if (!string.IsNullOrEmpty(THANHPHO_ID))
{
car.THANHPHO_ID = new Guid(THANHPHO_ID);
}
if (!string.IsNullOrEmpty(RowId))
{
car.RowId = new Guid(RowId);
}
car.RaoBan = Convert.ToBoolean(RaoBan);
if (!string.IsNullOrEmpty(Nam))
{
car.Nam = Convert.ToInt32(Nam);
}
car.SubModel = SubModel;
car.NgayCapNhat = DateTime.Now;
car.NguoiCapNhat = Security.Username;
car.Anh = Anh;
if (idNull)
{
if (isInserting)
{
car.NgayTao = DateTime.Now;
car.NguoiTao = Security.Username;
car = XeDal.Insert(car);
ObjMemberDal.Insert(new ObjMember()
{
PRowId = car.RowId
,
Username = Security.Username
,
Owner = true
,
NgayTao = DateTime.Now
,
RowId = Guid.NewGuid()
});
var obj = ObjDal.Insert(new Obj()
{
Id = Guid.NewGuid()
,
Kieu = typeof(Xe).FullName
,
NgayTao = DateTime.Now
,
RowId = car.RowId
,
Url = car.XeUrl
,
Username = Security.Username
,
Ten = car.Ten
});
}
else
{
car = XeDal.Update(car);
}
}
else
{
car = XeDal.Update(car);
SearchManager.Add(car.Ten, string.Format("{0} {1}", car.Ten, car.GioiThieu), string.Empty, car.RowId.ToString(),
car.XeUrl, typeof(Xe).Name);
}
MemberDal.UpdateVcard(DAL.con(), Security.Username);
}
break;
#endregion
case "remove":
#region remove car
if (Id != null && logged)
{
var xe = XeDal.SelectById(Convert.ToInt64(Id));
if (xe.NguoiTao != Security.Username && string.IsNullOrEmpty(adminKey))
return;
XeDal.DeleteById(xe.Id);
ObjDal.DeleteByRowId(xe.RowId);
SearchManager.Remove(xe.RowId);
ObjMemberDal.DeleteByPRowId(xe.RowId.ToString());
foreach (var item in AnhDal.SelectByPId(DAL.con(), xe.RowId.ToString(),50))
{
var file = newDic + item.FileAnh;
if (File.Exists(file))
{
File.Delete(newDic + item.FileAnh);
}
AnhDal.DeleteById(item.Id);
}
}
break;
#endregion
}
}
protected void Page_Load(object sender, EventArgs e)
{
var id = Request["ID"];
Item = string.IsNullOrEmpty(id) ? new Xe() : XeDal.SelectById(Convert.ToInt32(id));
Add.Item = Item;
}
public void InitBlog(SqlConnection con, IRedisClient redis)
{
const string itemKey = "urn:blog:{0}";
const string itemList = "urn:blog:list:{0}";
var blogRedis = new BlogRedis(redis);
var memberRedis = new MemberRedis(redis);
var nhomRedis = new NhomRedis(redis);
var xeRedis = new XeRedis(redis);
var member = new Member();
var xe = new Xe();
var nhom = new Nhom();
var nguoiTao = new Member();
//STEP:1
//var blog = BlogDal.SelectAll().FirstOrDefault();
//redis.Set(string.Format(itemKey,blog.Id), blog);
//STEP:2
var list = BlogDal.SelectAll();
var all = redis.Lists[string.Format(itemList, "all")];
var approved = redis.Lists[string.Format(itemList, "approved")];
var unApproved = redis.Lists[string.Format(itemList, "unApproved")];
var topNhatKy = redis.Lists[string.Format(itemList, "blog")];
var topHanhTrinh = redis.Lists[string.Format(itemList, "hanhTrinh")];
var topNhomBlog = redis.Lists[string.Format(itemList, "nhomBlog")];
var topNhomForum = redis.Lists[string.Format(itemList, "nhomForum")];
foreach (var item in list)
{
var key = string.Format(itemKey, item.Id);
var thich = ThichDal.SelectByPidLoai(item.RowId, 3);
foreach (var thich1 in thich)
{
item.NguoiThich.Insert(0, thich1.Username);
}
var anhs = AnhDal.SelectByPId(DAL.con(), item.RowId.ToString(), 100);
foreach (var anh in anhs)
{
item.AnhList.Insert(0, anh.Id);
}
var binhLuanList = BinhLuanDal.PagerByPRowId(con, "a", false, item.RowId.ToString(), 1000).List;
foreach (var binhLuan in binhLuanList)
{
item.BinhLuanIds.Insert(0, binhLuan.Id);
}
switch (item.Loai)
{
case 1:
member = memberRedis.GetByRowId(item.PID_ID);
topHanhTrinh.Push(item.Id.ToString(CultureInfo.InvariantCulture));
if (member != null)
{
item.Url = string.Format("{0}/blogs/{1}/", member.Url, item.Id);
item.UrlEdit = string.Format("{0}/blogs/edit/{1}/", member.Url, item.Id);
}
break;
case 2:
xe = xeRedis.GetByRowId(item.PID_ID);
if (xe != null)
{
item.Url = string.Format("{0}blogs/{1}/", xe.XeUrl, item.Id);
item.UrlEdit = string.Format("{0}blogs/edit/{1}/", xe.XeUrl, item.Id);
}
topNhatKy.Push(item.Id.ToString());
break;
case 3:
nhom = nhomRedis.GetByRowId(item.PID_ID);
if (nhom != null)
{
item.Url = string.Format("{0}blogs/{1}/", nhom.Url, item.Id);
item.UrlEdit = string.Format("{0}blogs/edit/{1}/", nhom.Url, item.Id);
}
topNhomBlog.Push(item.Id.ToString());
break;
case 4:
nhom = nhomRedis.GetByRowId(item.PID_ID);
if (nhom != null)
{
item.Url = string.Format("{0}forum/{1}/", nhom.Url, item.Id);
item.UrlEdit = string.Format("{0}blogs/edit/{1}/", nhom.Url, item.Id);
}
topNhomForum.Push(item.Id.ToString());
break;
}
redis.Set(key, item);
redis.Set(string.Format(itemKey, item.RowId), item.Id);
all.Push(item.Id.ToString());
if (item.Publish)
{
approved.Push(item.Id.ToString());
}
else
{
unApproved.Push(item.Id.ToString());
}
}
}
