public ActionResult UpdateUserDetailsToDB(User model)
{
User updatedModel = DALayer.UpdateUserInfo(model);
SetProperty(SessionVariableNames.Current_User, updatedModel);
return(RedirectToAction("Index"));
}
public bool AddUserPositionToDB(string latitude, string longitude)
{
string emailId = GetEmailIdAndRefreshUserSession(false);
DALayer.UpsertUserPosition(emailId, latitude, longitude);
return(true);
}
public JsonResult AddOrRemoveLike(int targetId, bool liked)
{
User model = GetProperty(SessionVariableNames.Current_User) as User;
if (model == null && Request.Cookies["UserMail"] != null)
{
string emailId = Request.Cookies["UserMail"].Value;
model = DALayer.GetUserInfo(emailId);
}
bool matched = DALayer.AddOrRemoveLike(model.UserId, targetId, liked);
if (liked)
{
model.Likes.Add(targetId.ToString());
}
else
{
model.Likes.Remove(targetId.ToString());
}
if (matched)
{
model.Matches.Add(targetId.ToString());
}
return(Json(matched, JsonRequestBehavior.AllowGet));
}
public JsonResult GetOtherUsers()
{
string emailId = GetEmailIdAndRefreshUserSession(false);
List <User> users = DALayer.GetAllUsers(emailId);
users.ForEach(x => x.LastSeenDiff = (DateTime.UtcNow - x.LastSeen).TotalSeconds.ToString());
return(Json(users, JsonRequestBehavior.AllowGet));
}
public JsonResult GetMatchedUsers()
{
string emailId = GetEmailIdAndRefreshUserSession(false);
User currentUser = GetProperty(SessionVariableNames.Current_User) as User;
List <User> users = DALayer.GetMatchedUsers(string.Join(",", currentUser.Matches));
users.ForEach(x => x.LastSeenDiff = (DateTime.UtcNow - x.LastSeen).TotalSeconds.ToString());
return(Json(users, JsonRequestBehavior.AllowGet));
}
public ActionResult AddUserToDB(LoginModel model)
{
SetCookies(model);
User userDetails = DALayer.AddNewUser(model);
DALayer.UpsertTokenValue(model.Token, model.Email);
SetProperty(SessionVariableNames.Current_User, userDetails);
return(RedirectToAction("Index", "Home"));
}
public JsonResult GetMessages(int otherUserId)
{
User currentUser = GetProperty(SessionVariableNames.Current_User) as User;
if (currentUser == null)
{
GetEmailIdAndRefreshUserSession(true);
currentUser = GetProperty(SessionVariableNames.Current_User) as User;
}
List <Message> messages = DALayer.GetMessages(currentUser.UserId, otherUserId);
return(Json(messages, JsonRequestBehavior.AllowGet));
}
public void DropDownChange(VehicleDetails svDetails)
{
_dbLayerObj = new DALayer();
ParkingBookingHistory pbhObj = new ParkingBookingHistory();
pbhObj = _dbLayerObj.VehicleCheckOut(svDetails);
DriverName = pbhObj.VehicleDetails.DriverName;
ParkingTime = (DateTime.Now - pbhObj.TimeIn).Duration();
TimeOut = DateTime.Now;
Timein = pbhObj.TimeIn;
ParkingSlot = pbhObj.ParkingSpace.SlotName;
VehicleType = pbhObj.VehicleDetails.VehicleType.VehicleTypeName;
}
private void btnLogin_Click(object sender, EventArgs e)
{
userName = txtTaiKhoan.Text.ToString();
password = txtMatKhau.Text.ToString();
try
{
conn = @"Data Source=" + "(local)" + ";Database=" + "QuanLyLinhKienPC" + ";Integrated Security = true";
//StreamWriter writer = new StreamWriter("ConnectString.con");
//writer.WriteLine(conn);
//writer.Close();
s = new DALayer();
if (s.Connection() == "y")
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
con.Open();
SqlCommand cmd = new SqlCommand("SELECT * FROM TaiKhoan WHERE TenTK ='" + userName + "' and Pass='******'", con);
SqlDataReader reader = cmd.ExecuteReader();
if (reader.Read() == true)
{
if (userName == "admin")
{
quyen = true;
}
else
{
quyen = false;
}
this.Hide();
Form main = new frmMain();
main.ShowDialog();
this.Close();
}
else
{
MessageBox.Show("Đăng nhập không thành công");
}
}
else
{
MessageBox.Show("Connect Failed !", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (SqlException ex)
{
MessageBox.Show("Không truy cập Database !!!/n" + ex, "Thông báo ",
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void CheckOutVehicle()
{
if (svDetails != null)
{
_dbLayerObj = new DALayer();
ParkingBookingHistory pbhObj = new ParkingBookingHistory();
pbhObj = _dbLayerObj.VehicleCheckOut(svDetails);
if (ParkingTime.Hours == 0 && svDetails.VehicleTypeID == 1)
{
Message = "Total Parking Fee is 20 \n" + "Parking Slot : " + ParkingSlot + " is Available";
pbhObj.TotalParkingFee = 20;
}
else if (ParkingTime.Hours == 0 && svDetails.VehicleTypeID == 2)
{
Message = "Total Parking Fee is 40 \n" + "Parking Slot : " + ParkingSlot + " is Available";
pbhObj.TotalParkingFee = 40;
}
else if (ParkingTime.Hours == 1 && svDetails.VehicleTypeID == 1)
{
Message = "Total Parking Fee is 40 \n" + "Parking Slot : " + ParkingSlot + " is Available";
pbhObj.TotalParkingFee = 40;
}
else if (ParkingTime.Hours == 1 && svDetails.VehicleTypeID == 2)
{
Message = "Total Parking Fee is 50 \n" + "Parking Slot : " + ParkingSlot + " is Available";
pbhObj.TotalParkingFee = 50;
}
else if (ParkingTime.Hours > 1 && svDetails.VehicleTypeID == 1)
{
Message = "Total Parking Fee is 60 \n" + "Parking Slot : " + ParkingSlot + " is Available";
pbhObj.TotalParkingFee = 60;
}
else if (ParkingTime.Hours > 1 && svDetails.VehicleTypeID == 2)
{
Message = "Total Parking Fee is 70 \n" + "Parking Slot : " + ParkingSlot + " is Available";
pbhObj.TotalParkingFee = 70;
}
pbhObj.TimeOut = TimeOut;
pbhObj.OccupancyTime = ParkingTime.ToString();
_dbLayerObj.CheckOutVehicle(pbhObj);
}
else
{
Message = "Please Select the Vehicle Number From Dropdown";
}
}
public ActionResult Index()
{
string emailId = GetEmailIdAndRefreshUserSession(true);
if (emailId != null)
{
bool exists = DALayer.IsEmailPresentInDB(emailId);
if (!exists)
{
return(RedirectToAction("Login", "Login"));
}
}
return(View());
}
public JsonResult AddMessage(int otherUserId, string message)
{
Int64 newMsgId;
User currentUser = GetProperty(SessionVariableNames.Current_User) as User;
try
{
newMsgId = DALayer.AddMessage(currentUser.UserId, otherUserId, message);
}
catch (Exception ex)
{
return(Json(new { success = false, error = ex.Message }, JsonRequestBehavior.AllowGet));
}
return(Json(new { success = true, message = new Message {
Date = DateTime.Now.ToShortDateString(), FromUserId = currentUser.UserId, ToUserId = otherUserId, MessageId = newMsgId, Time = DateTime.Now.ToShortTimeString(), Timestamp = DateTime.Now, Value = message
} }, JsonRequestBehavior.AllowGet));
}
public ActionResult Login(LoginModel loginModel)
{
if (loginModel != null)
{
SetProperty(SessionVariableNames.Login_Model, loginModel);
SetProperty(SessionVariableNames.Email_Id, loginModel.Email);
bool exists = DALayer.IsEmailPresentInDB(loginModel.Email);
if (exists)
{
DALayer.UpsertTokenValue(loginModel.Token, loginModel.Email);
DALayer.UpdateImageUrl(loginModel.Email, loginModel.ImageUrl);
SetCookies(loginModel);
return(Json(new { result = "Redirect", url = Url.Action("Index", "Home") }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { result = "Add", url = Url.Action("AddUserDetails", "Login", JsonRequestBehavior.AllowGet) }));
}
}
return(Json(new { result = "Error" }, JsonRequestBehavior.AllowGet));
}
private string GetEmailIdAndRefreshUserSession(bool refreshUserSession)
{
string emailId = GetProperty(SessionVariableNames.Email_Id) as string;
if (emailId == null && Request.Cookies["UserMail"] != null)
{
emailId = Request.Cookies["UserMail"].Value;
SetProperty(SessionVariableNames.Email_Id, emailId);
}
if (refreshUserSession)
{
SetProperty(SessionVariableNames.Current_User, DALayer.GetUserInfo(emailId));
}
else
{
User userModel = GetProperty(SessionVariableNames.Current_User) as User;
if (userModel == null && emailId != null)
{
SetProperty(SessionVariableNames.Current_User, DALayer.GetUserInfo(emailId));
}
}
return(emailId);
}
public BADangNhap()
{
db = new DALayer();
}
public BLL_NhanVien()
{
db = new DALayer();
}
public DBTheLoai()
{
dal = new DALayer();
}
public Sale fetchSale(string id)
{
DALayer newLayer = new DALayer();
return(newLayer.FetchSale(id));
}
public List <Sale> fetchAllSales()
{
DALayer newLayer = new DALayer();
return(newLayer.FetchAllSales());
}
public DBNXB()
{
dal = new DALayer();
}
public int RegisterNew(Member newMember)
{
DALayer newLayer = new DALayer();
return(newLayer.RegisterNew(newMember));
}
public List <Sale> fetchAllSales(DateTime lowerDate, DateTime upperDate)
{
DALayer newLayer = new DALayer();
return(newLayer.FetchAllSales(lowerDate, upperDate));
}
public int NewSale(Item newItem)
{
DALayer newLayer = new DALayer();
return(newLayer.NewSale(newItem));
}
public BAPhongChieu()
{
db = new DALayer();
}
public BAL_LoaiSP()
{
db = new DALayer();
}
public int UpdatePassword(String id, string pass)
{
DALayer newLayer = new DALayer();
return(newLayer.UpdatePassword(id, pass));
}
public BATaiKhoan()
{
db = new DALayer();
}
public BLL_TaiKhoan()
{
db = new DALayer();
}
public BAHoaDonDichVu()
{
db = new DALayer();
}
public JsonResult GetUserInfo()
{
string emailId = GetEmailIdAndRefreshUserSession(false);
return(Json(DALayer.GetUserInfo(emailId), JsonRequestBehavior.AllowGet));
}