public async Task <ActionResult> Edit(RegistrationDataModel dataModel)
{
if (ModelState.IsValid)
{
int id = Convert.ToInt32(Session["UserId"]);
TblAddress address = (from x in db.TblAddresses
where x.UserId == id
select x).FirstOrDefault();
address.Line1 = dataModel.Address.Line1;
address.Area = dataModel.Address.Area;
address.Province = dataModel.Address.Province;
address.PostalCode = dataModel.Address.PostalCode;
await db.SaveChangesAsync();
TblContact contact = (from x in db.TblContacts
where x.UserId == id
select x).FirstOrDefault();
contact.Number = dataModel.Contact.Number;
await db.SaveChangesAsync();
TblUser user = (from x in db.TblUsers
where x.UserId == id
select x).FirstOrDefault();
user.Name = dataModel.User.Name;
await db.SaveChangesAsync();
return(RedirectToAction("Details"));
}
return(View(dataModel));
}
public override TblSystemUser Map()
{
var address = new TblAddress
{
StreetNumber = AddressNoNavigation.StreetNumber,
StreetOrRoadName = AddressNoNavigation.StreetOrRoadName,
CityOrTownName = AddressNoNavigation.CityOrTownName,
PostCode = AddressNoNavigation.PostCode
};
var staffMember = new Collection <TblStaff>
{
new TblStaff
{
BranchNo = Convert.ToByte(this.BranchNo),
GenderNo = Convert.ToByte(this.GenderNo),
Salary = this.Salary
}
};
return(new TblSystemUser
{
FirstName = FirstName,
LastName = LastName,
UserName = UserName,
UserPassword = UserPassword,
PhoneNumber = PhoneNumber,
AddressNoNavigation = address,
AddressNo = address.AddressNo,
SystemUserTypeNo = Convert.ToByte(SystemUserTypeNo),
TblStaff = staffMember
});
}
public override TblSystemUser Map()
{
var address = new TblAddress
{
StreetNumber = AddressNoNavigation.StreetNumber,
StreetOrRoadName = AddressNoNavigation.StreetOrRoadName,
CityOrTownName = AddressNoNavigation.CityOrTownName,
PostCode = AddressNoNavigation.PostCode
};
var owner = new Collection <TblOwner>
{
new TblOwner
{
OwnerTypeNo = Convert.ToByte(this.OwnerTypeNo),
IsOwnerActive = this.IsOwnerActive
}
};
return(new TblSystemUser
{
FirstName = FirstName,
LastName = LastName,
UserName = UserName,
UserPassword = UserPassword,
PhoneNumber = PhoneNumber,
AddressNoNavigation = address,
AddressNo = address.AddressNo,
SystemUserTypeNo = Convert.ToByte(SystemUserTypeNo),
TblOwner = owner
});
}
public static TblSystemUser Map(RegisterBaseUserDTO dto)
{
var address = new TblAddress
{
StreetNumber = dto.AddressNoNavigation.StreetNumber,
StreetOrRoadName = dto.AddressNoNavigation.StreetOrRoadName,
CityOrTownName = dto.AddressNoNavigation.CityOrTownName,
PostCode = dto.AddressNoNavigation.PostCode
};
return new TblSystemUser
{
FirstName = dto.FirstName,
LastName = dto.LastName,
UserName = dto.UserName,
UserPassword = dto.UserPassword,
PhoneNumber = dto.PhoneNumber,
AddressNoNavigation = address,
AddressNo = address.AddressNo,
SystemUserTypeNo = Convert.ToByte(4)//Convert.ToByte(dto.SystemUserTypeNo)
};
}
public override TblSystemUser Map()
{
var address = new TblAddress
{
StreetNumber = AddressNoNavigation.StreetNumber,
StreetOrRoadName = AddressNoNavigation.StreetOrRoadName,
CityOrTownName = AddressNoNavigation.CityOrTownName,
PostCode = AddressNoNavigation.PostCode
};
var client = new Collection <TblClient>
{
new TblClient
{
PreferredAccomodationType = this.PreferredAccomodationType,
MaximumRent = this.MaximumRent,
IsActive = this.IsActive
}
};
return(new TblSystemUser
{
FirstName = FirstName,
LastName = LastName,
UserName = UserName,
UserPassword = UserPassword,
PhoneNumber = PhoneNumber,
AddressNoNavigation = address,
AddressNo = address.AddressNo,
SystemUserTypeNo = Convert.ToByte(SystemUserTypeNo),
TblClient = client
});
}
public bool AddCinema(CinemaViewModel cinema)
{
TblAddress myAddress = new TblAddress()
{
CityId = cinema.CityId,
CountryId = cinema.CountryId,
StreetName = cinema.StreetName,
CreatedByUserId = cinema.CreatedByUserId,
LastModifiedByUserId = cinema.LastModifiedByUserId,
CreatedOnDate = DateTime.Now.ToString("dd/MM/yyyy"),
LastModifiedOnDate = DateTime.Now.ToString("dd/MM/yyyy"),
IsDeleted = false
};
var addressAdded = _addressRepository.AddAddress(myAddress);
if (addressAdded)
{
Images image = new Images()
{
ImagePath = cinema.ImagePath
};
_context.Images.Add(image);
TblCinema tblCinema = new TblCinema()
{
CinemaId = cinema.CinemaId,
AdminUserId = cinema.AdminUserId,
CinemaName = cinema.CinemaName,
CinemaDescription = cinema.CinemaDescription,
AdressId = myAddress.AdressId,
CinemaProfilePicture = image.ImagePath,
CreatedByUserId = cinema.CreatedByUserId,
LastModifiedByUserId = cinema.LastModifiedByUserId,
CreatedOnDate = DateTime.Now.ToString("dd/MM/yyyy"),
LastModifiedOnDate = DateTime.Now.ToString("dd/MM/yyyy"),
AdminUser = cinema.AdminUser,
Adress = cinema.Adress,
SeatColumns = cinema.SeatColumns,
SeatsRows = cinema.SeatsRows,
CreatedByUser = cinema.CreatedByUser,
LastModifiedByUser = cinema.LastModifiedByUser,
IsDeleted = false
};
var cinemaAdded = _cinemaRepository.AddCinema(tblCinema);
if (cinemaAdded)
{
return(true);
}
return(false);
}
return(false);
}
public async Task <ActionResult> Create(RegistrationDataModel registrationDataModel)
{
if (ModelState.IsValid)
{
var emails = from data in db.TblUsers select data.Email;
foreach (string email in emails)
{
if (email.Equals(registrationDataModel.Email))
{
return(Content("<script language='javascript' type='text/javascript'>alert('Email is already in use! User other Email');$.ajax({url: '/Home/Index',success: function(data) {alert(data);}});</script >"));
}
}
TblUser tblUser = new TblUser();
tblUser.Name = registrationDataModel.Name;
tblUser.Email = registrationDataModel.Email;
tblUser.UserType = registrationDataModel.UserType.ToString();
tblUser.Password = registrationDataModel.Password;
tblUser.ValidateEmail = false;
List <string> encryptedPasswordAndSalt = Password.Ecrypt(tblUser.Password);
tblUser.Salt = encryptedPasswordAndSalt[0];
tblUser.Hash = encryptedPasswordAndSalt[1];
db.TblUsers.Add(tblUser);
await db.SaveChangesAsync();
int lastGeneratedId = tblUser.UserId;
TblAddress tblAddress = new TblAddress();
tblAddress.Line1 = registrationDataModel.Line1;
tblAddress.Area = registrationDataModel.Area;
tblAddress.Province = registrationDataModel.Province;
tblAddress.PostalCode = registrationDataModel.PostalCode;
tblAddress.UserId = lastGeneratedId;
tblAddress.Country = "Canada";
db.TblAddresses.Add(tblAddress);
await db.SaveChangesAsync();
TblContact tblContact = new TblContact();
tblContact.Number = registrationDataModel.Number;
tblContact.UserId = lastGeneratedId;
db.TblContacts.Add(tblContact);
await db.SaveChangesAsync();
var sysData = from data in db.TblSysCredentials select data;
//Send Confirmation EMail
Email.Email.BuildEmailTemplate(tblUser.UserId, tblUser.Email, sysData.FirstOrDefault().Email, sysData.FirstOrDefault().Password);
//BuildEmailTemplate(tblUser.UserId);
return(RedirectToAction("Index", "Home"));
}
return(View());
}
public ActionResult Edit(TblAddress TblAddress, int id, FormCollection collection, int[] mutilManu)
{
if (ModelState.IsValid)
{
string drAddress = collection["drAddress"];
if (drAddress == "" && drAddress != null)
{
TblAddress.idCate = 0;
}
else
{
TblAddress.idCate = int.Parse(drAddress);
}
db.Entry(TblAddress).State = EntityState.Modified;
db.SaveChanges();
var listIdManu = db.tblConnectManuToAddresses.Where(p => p.idAdress == id).ToList();
for (int i = 0; i < listIdManu.Count; i++)
{
db.tblConnectManuToAddresses.Remove(listIdManu[i]);
db.SaveChanges();
}
if (mutilManu != null)
{
foreach (var idMenu in mutilManu)
{
tblConnectManuToAddress connectimage = new tblConnectManuToAddress();
connectimage.idManu = idMenu;
connectimage.idAdress = id;
db.tblConnectManuToAddresses.Add(connectimage);
db.SaveChanges();
}
}
#region [Updatehistory]
Updatehistoty.UpdateHistory("Edit Hotline", Request.Cookies["Username"].Values["FullName"].ToString(), Request.Cookies["Username"].Values["UserID"].ToString());
#endregion
if (collection["btnSave"] != null)
{
Session["Thongbao"] = "<div class=\"alert alert-info alert1\">Bạn đã sửa thành công !<button class=\"close\" data-dismiss=\"alert\">×</button></div>";
return(Redirect("/address/Index"));
}
if (collection["btnSaveCreate"] != null)
{
Session["Thongbao"] = "<div class=\"alert alert-info\">Bạn đã thêm thành công, mời bạn thêm mới !<button class=\"close\" data-dismiss=\"alert\">×</button></div>";
return(Redirect("/address/Create"));
}
}
return(View(TblAddress));
}
public ActionResult Edit(int id = 0)
{
if ((Request.Cookies["Username"] == null))
{
return(RedirectToAction("LoginIndex", "Login"));
}
if (ClsCheckRole.CheckQuyen(10, 2, int.Parse(Request.Cookies["Username"].Values["UserID"])) == true)
{
TblAddress Hotline = db.TblAddress.Find(id);
if (Hotline == null)
{
return(HttpNotFound());
}
var Manufacture = db.SelectListItem.Where(m => m.Active == true).OrderBy(m => m.Ord).ToList();
var listIdManu = db.tblConnectManuToAddresses.Where(p => p.idAdress == id).Select(p => p.idManu).ToList();
var lstmanu = new List <SelectListItem>();
foreach (var item in Manufacture)
{
lstmanu.Add(new SelectListItem {
Text = item.Name, Value = item.id.ToString()
});
}
ViewBag.mutilManu = new MultiSelectList(lstmanu, "Value", "Text", listIdManu);
var groupAddress = db.tblGroupAddresses.Where(m => m.Active == true).OrderBy(m => m.Ord).ToList();
var listGroup = new List <SelectListItem>();
foreach (var item in groupAddress)
{
listGroup.Add(new SelectListItem {
Text = item.Name, Value = item.id.ToString()
});
}
string idCate = Hotline.idCate.ToString();
if (idCate != null && idCate != "")
{
ViewBag.drAddress = new SelectList(listGroup, "Value", "Text", int.Parse(idCate));
}
else
{
ViewBag.drAddress = new SelectList(listGroup, "Value", "Text");
}
return(View(Hotline));
}
else
{
return(Redirect("/Users/Erro"));
}
}
public TblBranch Map()
{
var address = new TblAddress
{
StreetNumber = AddressNoNavigation.StreetNumber,
StreetOrRoadName = AddressNoNavigation.StreetOrRoadName,
CityOrTownName = AddressNoNavigation.CityOrTownName,
PostCode = AddressNoNavigation.PostCode
};
return(new TblBranch
{
AddressNoNavigation = address,
AddressNo = address.AddressNo,
Phone = Phone
});
}
public ActionResult DeleteAddress(int id)
{
if (ClsCheckRole.CheckQuyen(10, 3, int.Parse(Request.Cookies["Username"].Values["UserID"])) == true)
{
TblAddress TblAddress = db.TblAddress.Find(id);
var result = string.Empty;
db.TblAddress.Remove(TblAddress);
db.SaveChanges();
result = "Bạn đã xóa thành công.";
return(Json(new { result = result }));
}
else
{
var result = string.Empty;
result = "Bạn không có quyền thay đổi tính năng này";
return(Json(new { result = result }));
}
}
public ActionResult Create(TblAddress TblAddress, FormCollection collection, int[] mutilManu)
{
string drAddress = collection["drAddress"];
if (drAddress == "" && drAddress != null)
{
TblAddress.idCate = 0;
}
else
{
TblAddress.idCate = int.Parse(drAddress);
}
db.TblAddress.Add(TblAddress);
db.SaveChanges();
var ListManu = db.TblAddress.OrderByDescending(p => p.id).Take(1).ToList();
int id = int.Parse(ListManu[0].id.ToString());
if (mutilManu != null)
{
foreach (var idMenu in mutilManu)
{
tblConnectManuToAddress connect = new tblConnectManuToAddress();
connect.idManu = idMenu;
connect.idAdress = id;
db.tblConnectManuToAddresses.Add(connect);
db.SaveChanges();
}
}
#region [Updatehistory]
Updatehistoty.UpdateHistory("Add TblAddress", Request.Cookies["Username"].Values["FullName"].ToString(), Request.Cookies["Username"].Values["UserID"].ToString());
#endregion
if (collection["btnSave"] != null)
{
Session["Thongbao"] = "<div class=\"alert alert-info alert1\">Bạn đã thêm thành công !<button class=\"close\" data-dismiss=\"alert\">×</button></div>";
return(Redirect("/address/Index"));
}
if (collection["btnSaveCreate"] != null)
{
Session["Thongbao"] = "<div class=\"alert alert-info\">Bạn đã thêm thành công, mời bạn thêm mới !<button class=\"close\" data-dismiss=\"alert\">×</button></div>";
return(Redirect("/address/Create"));
}
return(Redirect("Index"));
}
public virtual TblSystemUser Map()
{
var address = new TblAddress
{
StreetNumber = AddressNoNavigation.StreetNumber,
StreetOrRoadName = AddressNoNavigation.StreetOrRoadName,
CityOrTownName = AddressNoNavigation.CityOrTownName,
PostCode = AddressNoNavigation.PostCode
};
return(new TblSystemUser
{
FirstName = FirstName,
LastName = LastName,
UserName = UserName,
UserPassword = UserPassword,
PhoneNumber = PhoneNumber,
AddressNoNavigation = address,
AddressNo = address.AddressNo,
SystemUserTypeNo = Convert.ToByte(SystemUserTypeNo)
});
}
public TblProperty Map()
{
var address = new TblAddress
{
StreetNumber = AddressNoNavigation.StreetNumber,
StreetOrRoadName = AddressNoNavigation.StreetOrRoadName,
CityOrTownName = AddressNoNavigation.CityOrTownName,
PostCode = AddressNoNavigation.PostCode
};
return(new TblProperty
{
OwnerNo = this.OwnerNo,
BranchNo = this.BranchNo,
AddressNoNavigation = address,
AddressNo = address.AddressNo,
PropertyTypeNo = Convert.ToByte(this.PropertyTypeNo),
StaffNo = this.StaffNo,
NumberOfRooms = this.NumberOfRooms,
MonthlyRent = this.MonthlyRent,
IsPropertyActive = this.IsPropertyActive
});
}
public bool AddAddress(TblAddress address)
{
_context.TblAddress.Add(address);
return(_context.SaveChanges() > 0);
}
public ActionResult Index(int?page, string id, FormCollection collection)
{
if ((Request.Cookies["Username"] == null))
{
return(RedirectToAction("LoginIndex", "Login"));
}
if (ClsCheckRole.CheckQuyen(10, 0, int.Parse(Request.Cookies["Username"].Values["UserID"])) == true)
{
var listAddress = db.TblAddress.ToList();
const int pageSize = 20;
var pageNumber = (page ?? 1);
// Thiết lập phân trang
var ship = new PagedListRenderOptions
{
DisplayLinkToFirstPage = PagedListDisplayMode.Always,
DisplayLinkToLastPage = PagedListDisplayMode.Always,
DisplayLinkToPreviousPage = PagedListDisplayMode.Always,
DisplayLinkToNextPage = PagedListDisplayMode.Always,
DisplayLinkToIndividualPages = true,
DisplayPageCountAndCurrentLocation = false,
MaximumPageNumbersToDisplay = 5,
DisplayEllipsesWhenNotShowingAllPageNumbers = true,
EllipsesFormat = "…",
LinkToFirstPageFormat = "Trang đầu",
LinkToPreviousPageFormat = "«",
LinkToIndividualPageFormat = "{0}",
LinkToNextPageFormat = "»",
LinkToLastPageFormat = "Trang cuối",
PageCountAndCurrentLocationFormat = "Page {0} of {1}.",
ItemSliceAndTotalFormat = "Showing items {0} through {1} of {2}.",
FunctionToDisplayEachPageNumber = null,
ClassToApplyToFirstListItemInPager = null,
ClassToApplyToLastListItemInPager = null,
ContainerDivClasses = new[] { "pagination-container" },
UlElementClasses = new[] { "pagination" },
LiElementClasses = Enumerable.Empty <string>()
};
ViewBag.ship = ship;
if (Session["Thongbao"] != null && Session["Thongbao"] != "")
{
ViewBag.thongbao = Session["Thongbao"].ToString();
Session["Thongbao"] = "";
}
if (collection["btnDelete"] != null)
{
foreach (string key in Request.Form.Keys)
{
var checkbox = "";
if (key.StartsWith("chk_"))
{
checkbox = Request.Form["" + key];
if (checkbox != "false")
{
if (ClsCheckRole.CheckQuyen(10, 3, int.Parse(Request.Cookies["Username"].Values["UserID"])) == true)
{
int ids = Convert.ToInt32(key.Remove(0, 4));
TblAddress TblAddress = db.TblAddress.Find(ids);
db.TblAddress.Remove(TblAddress);
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
return(Redirect("/Users/Erro"));
}
}
}
}
}
return(View(listAddress.ToPagedList(pageNumber, pageSize)));
}
else
{
return(Redirect("/Users/Erro"));
}
}
public bool CreateAddress(TblAddress address)
{
db.TblAddress.Add(address);
return(Save());
}
public bool EditAddress(TblAddress address)
{
_context.TblAddress.Update(address);
_context.Entry(address).State = EntityState.Modified;
return(_context.SaveChanges() > 0);
}
public bool DeleteAddress(TblAddress address)
{
db.TblAddress.Remove(address);
return(Save());
}
public bool UpdateAddress(TblAddress address)
{
db.TblAddress.Update(address);
return(Save());
}
