public JsonResult Register(User u)
{
string message = "";
//Here we will save data to the database
if (ModelState.IsValid)
{
using (MyDatabaseEntities dc = new MyDatabaseEntities())
{
//check username available
var user = dc.Users.Where(a => a.Username.Equals(u.Username)).FirstOrDefault();
if (user == null)
{
//Save here
dc.Users.Add(u);
dc.SaveChanges();
message = "Success";
}
else
{
message = "Username not available!";
}
}
}
else
{
message = "Failed!";
}
return new JsonResult { Data = message, JsonRequestBehavior = JsonRequestBehavior.AllowGet };
}
public JsonResult UserLogin(LoginData d)
{
using (MyDatabaseEntities dc = new MyDatabaseEntities())
{
var user = dc.Users.Where(a => a.Username.Equals(d.Username) && a.Password.Equals(d.Password)).FirstOrDefault();
return new JsonResult { Data = user, JsonRequestBehavior = JsonRequestBehavior.AllowGet };
}
}
public bool IsEmailExist(string emailID)
{
using (MyDatabaseEntities dc = new MyDatabaseEntities())
{
var v = dc.Users.Where(a => a.EmailID == emailID).FirstOrDefault();
return(v != null);
}
}
public ActionResult GetEmployees()
{
using (MyDatabaseEntities dc = new MyDatabaseEntities())
{
var employee = dc.Employees.OrderBy(a => a.FirstName).ToList();
return(Json(new { data = employee }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Save(int id)
{
using (MyDatabaseEntities dc = new MyDatabaseEntities())
{
var v = dc.Employees.Where(a => a.EmployeeID == id).FirstOrDefault();
return(View(v));
}
}
public bool IsEmailExist(string emailID)
{
using (MyDatabaseEntities db = new MyDatabaseEntities())
{
var user = db.Users.Where(m => m.EmailID == emailID).FirstOrDefault();
//return v == null ? false : true;
return(user != null);
}
}
public ActionResult Registraion([Bind(Exclude = "IsEmailVerified,ActivationCode")] User user)
{
bool status = false;
string message = "";
//Model Validation
if (ModelState.IsValid)
{
//Email is already exist
#region
var isExist = IsEmailExist(user.EmailID);
if (isExist)
{
ModelState.AddModelError("EmailExist", "This email already exist!");
return(View(user));
}
#endregion
//Generate activation code
#region
user.ActivationCode = Guid.NewGuid();
#endregion
//Password Hassing
#region
user.Password = Crypto.Hash(user.Password);
user.ConfirmPassword = Crypto.Hash(user.ConfirmPassword);
#endregion
//for the first time
user.IsEmailVerified = false;
//Save Data to Database
#region
using (MyDatabaseEntities db = new MyDatabaseEntities())
{
db.Users.Add(user);
db.SaveChanges();
//Send Email to user
SendVerificationLinkEmail(user.EmailID, user.ActivationCode.ToString());
message = "Registration successfully done. " +
"Account activation link has been sent to your email id:" + user.EmailID;
status = true;
}
#endregion
}
else
{
message = "Invalid request";
}
ViewBag.Message = message;
ViewBag.Status = status;
return(View(user));
}
public ActionResult _AddPost(Post post, HttpPostedFileBase files)
{
post.UserID = Convert.ToInt32(Session["id"]);
post.DatePosted = DateTime.Now;
if (Request.Files.Count > 0)
{
var file = Request.Files[0];
if (file != null && file.ContentLength > 0)
{
string imgFileName = Path.GetFileNameWithoutExtension(post.ImageFile.FileName);
string imgExtension = Path.GetExtension(post.ImageFile.FileName).ToLower();
if (imgExtension == ".png" || imgExtension == ".jpeg" || imgExtension == ".jpg")
{
imgFileName = imgFileName + DateTime.Now.ToString("yymmssfff") + imgExtension;
post.ImagePath = "~/Image/" + imgFileName;
imgFileName = Path.Combine(Server.MapPath("~/Image/"), imgFileName);
post.ImageFile.SaveAs(imgFileName);
}
else
{
imgFileName = imgFileName + DateTime.Now.ToString("yymmssfff") + imgExtension;
post.OtherFilePath = "~/Image/" + imgFileName;
imgFileName = Path.Combine(Server.MapPath("~/Image/"), imgFileName);
post.ImageFile.SaveAs(imgFileName);
//string otherFileName = Path.GetFileNameWithoutExtension(post.OtherFile.FileName);
//string otherExtension = Path.GetExtension(post.OtherFile.FileName).ToLower();
//otherFileName = otherFileName + DateTime.Now.ToString("yymmssfff") + otherExtension;
//post.OtherFilePath = "~/OtherFiles/" + otherFileName;
//otherFileName = Path.Combine(Server.MapPath("~/OtherFiles/"), otherFileName);
//post.OtherFile.SaveAs(otherFileName);
}
//fileName = fileName + DateTime.Now.ToString("yymmssfff") + extension;
//post.ImagePath = "~/Image/" + fileName;
//fileName = Path.Combine(Server.MapPath("~/Image/"), fileName);
//post.ImageFile.SaveAs(fileName);
}
}
using (MyDatabaseEntities db = new MyDatabaseEntities())
{
string FirstName = db.Users.Where(f => f.UserID == post.UserID).FirstOrDefault().FirstName;
string LastName = db.Users.Where(f => f.UserID == post.UserID).FirstOrDefault().LastName;
post.UserIdName = FirstName + " " + LastName;
post.UserPicture = db.UserDatas.Where(f => f.Id == post.UserID).FirstOrDefault().ProfileImage;
db.Posts.Add(post);
db.SaveChanges();
}
ModelState.Clear();
return(RedirectToAction("Index", "Home"));
}
//
// GET: /User/
//public ActionResult Index()
//{
// return View();
//}
public ActionResult List(string search)
{
//here MyDatabaseEntities is the dbcontext
using (var dc = new MyDatabaseEntities())
{
_students = dc.Students.Where(x => x.StdFirstName.Contains(search) || search == null).ToList();
}
return(View(_students));
}
public ActionResult AccountHome()
{
using (MyDatabaseEntities dc = new MyDatabaseEntities())
{
var user = dc.Users.Where(a => a.EmailID == HttpContext.User.Identity.Name).FirstOrDefault();
return(View(user));
}
}
public ActionResult EditEvent(Event model)
{
using (MyDatabaseEntities db = new MyDatabaseEntities())
{
List <string> ListaTypow = new List <string>();
ListaTypow.Add("platne");
ListaTypow.Add("bezplatne");
ViewBag.TypyWydarzen = new SelectList(ListaTypow);
List <string> ListaMiast = new List <string>();
ListaMiast.Add("Augustów");
ListaMiast.Add("Bialystok");
ListaMiast.Add("Choroszcz");
ListaMiast.Add("Chrzanowo");
ListaMiast.Add("Dotnetowo");
ListaMiast.Add("Katowice");
ListaMiast.Add("Kieliszkowo");
ListaMiast.Add("Kraków");
ListaMiast.Add("Lublin");
ListaMiast.Add("Łódz");
ListaMiast.Add("Opole");
ListaMiast.Add("Siedlce");
ListaMiast.Add("Suwalki");
ListaMiast.Add("Warszawa");
ListaMiast.Add("Wroclaw");
ListaMiast.Add("Zakopane");
ViewBag.Miasta = new SelectList(ListaMiast);
bool Status = false;
string message = "";
var isExist = IsEventExists(model.Name);
var eve = db.Events.Where(a => a.EventId == model.EventId).FirstOrDefault();
if (isExist && eve.Name != model.Name)
{
ModelState.AddModelError("NameExist", "Taka nazwa już istnieje!");
return(View(model));
}
else
{
eve.Date = model.Date;
eve.ExpectedTicketAmount = model.ExpectedTicketAmount;
eve.Localization = model.Localization;
eve.MaxTicketAmountForOnePerson = model.MaxTicketAmountForOnePerson;
eve.Name = model.Name;
eve.Time = model.Time;
eve.Type = model.Type;
db.SaveChanges();
}
ViewBag.Status = Status;
ViewBag.Message = message;
return(RedirectToAction("AccountEvent", "Users"));
}
}
public ActionResult loaddata()
{
using (MyDatabaseEntities dc = new MyDatabaseEntities())
{
// dc.Configuration.LazyLoadingEnabled = false; // if your table is relational, contain foreign key
var data = dc.QuestionAnswerLists.OrderBy(a => a.Questions).ToList();
return(Json(new { data = data }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult saveuser(int id, string propertyName, string value)
{
var status = false;
var message = "";
//Update data to database
using (MyDatabaseEntities dc = new MyDatabaseEntities())
{
var user = dc.SiteUsers.Find(id);
object updateValue = value;
bool isValid = true;
if (propertyName == "RoleID")
{
int newRoleID = 0;
if (int.TryParse(value, out newRoleID))
{
updateValue = newRoleID;
//Update value field
value = dc.UserRoles.Where(a => a.ID == newRoleID).First().RoleName;
}
else
{
isValid = false;
}
}
else if (propertyName == "DOB")
{
DateTime dob;
if (DateTime.TryParseExact(value, "dd-MM-yyyy", new CultureInfo("en-US"), DateTimeStyles.None, out dob))
{
updateValue = dob;
}
else
{
isValid = false;
}
}
if (user != null && isValid)
{
dc.Entry(user).Property(propertyName).CurrentValue = updateValue;
dc.SaveChanges();
status = true;
}
else
{
message = "Error!";
}
}
var response = new { value = value, status = status, message = message };
JObject o = JObject.FromObject(response);
return(Content(o.ToString()));
}
// GET: Emp
public ActionResult Edit(int id)
{
using (MyDatabaseEntities db1 = new MyDatabaseEntities())
{
//Fetch the Id for editing
var std = db1.EMPs.Where(s => s.Id == id).FirstOrDefault();
return(View(std));
}
}
public ActionResult Index()
{
MyDatabaseEntities entities = new MyDatabaseEntities();
List <Customer> customers = entities.Customers.ToList();
//Add a Dummy Row.
customers.Insert(0, new Customer());
return(View(customers));
}
public ActionResult Registration([Bind(Exclude = "ActivationCode, IsEmailVerified")] User user)
{
bool status = false;
string message = "";
//
//Model Validation
if (ModelState.IsValid)
{
#region//Email already exist
var isExist = IsEmailExist(user.EmailID);
if (isExist)
{
ModelState.AddModelError("EmailExist", "Email already exist");
return(View(user));
}
#endregion
#region //activation Code
user.ActivationCode = Guid.NewGuid();
#endregion
#region //Password Hashing
user.Password = Crypto.Hash(user.Password);
user.ConfirmPassword = Crypto.Hash(user.ConfirmPassword);
//user.Password = Convert.ToBase64String(
//System.Security.Cryptography.SHA256.Create()
//.ComputeHash(Encoding.UTF8.GetBytes(user.Password)));
#endregion
user.IsEmailVerified = false;
#region//Save Data to Database
using (MyDatabaseEntities mde = new MyDatabaseEntities())
{
mde.Users.Add(user);
mde.SaveChanges();
}
#endregion
#region//Send Email to User
SendVerificationLinkEmail(user.EmailID, user.ActivationCode.ToString());
message = "Registration successfully done. Account Activation link" +
"has been sent to your email ID: " + user.EmailID;
status = true;
#endregion
}
else
{
message = "Invalid request";
}
ViewBag.Message = message;
ViewBag.Status = status;
return(View(user));
}
// Fetch State by Country ID
public JsonResult GetStates(int countryID)
{
List<State> allState = new List<State>();
using (MyDatabaseEntities dc = new MyDatabaseEntities())
{
allState = dc.States.Where(a => a.CountryID.Equals(countryID)).OrderBy(a => a.StateName).ToList();
}
return new JsonResult { Data = allState, JsonRequestBehavior = JsonRequestBehavior.AllowGet };
}
// Fetch Country
public JsonResult GetCountries()
{
List<Country> allCountry = new List<Country>();
using (MyDatabaseEntities dc = new MyDatabaseEntities())
{
allCountry = dc.Countries.OrderBy(a => a.CountryName).ToList();
}
return new JsonResult { Data = allCountry, JsonRequestBehavior = JsonRequestBehavior.AllowGet };
}
public ActionResult Registration([Bind(Exclude = "IsEmailVerified,ActivationCode")] User user)
{
bool Status = false;
String message = "";
//
// Model Validetion
if (ModelState.IsValid)
{
#region //Email is already Exist
var isExist = IsEmailExist(user.EmailID);
if (isExist)
{
ModelState.AddModelError("EmailExist", "Email already exist");
return(View(user));
}
#endregion
#region Generate Activation code
user.ActivationCode = Guid.NewGuid();
#endregion
#region Password Hashing
user.Password = Crypto.Hash(user.Password);
user.ConfirmPassword = Crypto.Hash(user.ConfirmPassword); //
#endregion
user.IsEmailVerified = false;
#region Save to Database
using (MyDatabaseEntities dc = new MyDatabaseEntities())
{
dc.Users.Add(user);
dc.SaveChanges();
//Send Email to User
SendVerificationLinkEmail(user.EmailID, user.ActivationCode.ToString());
message = "Registration successfully done. Account activation link " +
" has been sent to your email id:" + user.EmailID;
Status = true;
}
#endregion
}
else
{
message = "Invalid Request";
}
ViewBag.Message = message;
ViewBag.Status = Status;
return(View(user));
return(View(user));
}
[ValidateAntiForgeryToken]//it is used to prevent foregery of a request
public ActionResult Registration([Bind(Exclude = "hEmailVerified,ActivationCode")] User user)
{
bool Status = false;
string Message = "";
//
//Model Validation
if (ModelState.IsValid)
{
#region Email already exists
var IsExist = IsEmailExist(user.EmailID);
if (IsExist)
{
ModelState.AddModelError("EmailExists", "Email Already Exist");
return(View(user));//we should show this message in view
}
#endregion
#region Generate Activation Code
user.ActivationCode = Guid.NewGuid();
#endregion
#region Password Hashing
user.Password = Crypto.Hash(user.Password);
user.ConfirmPassword = Crypto.Hash(user.ConfirmPassword); //as it will validate again after step changes ,so we also hased the confirm password
#endregion
user.hEmailVerified = false; // initially we need tomake this false
#region Save data to Database and send verification link to email
using (MyDatabaseEntities dc = new MyDatabaseEntities()) //creating connection with database
{
dc.Users.Add(user);
dc.SaveChanges();
//Send email to user
SendVerificationEmailLink(user.EmailID, user.ActivationCode.ToString());
Message = "Registration sucessful. Account activation link has been sent to your Email Id: " + user.EmailID;
Status = true;
}
#endregion
}
else
{
Message = "Invalid Request";
}
ViewBag.Message = Message;
ViewBag.Status = Status;
//Send email to user
return(View(user));
}
//GetAllLocation - for fetch all the location from database and show in the view
//Shows all the locations in default map here.
public JsonResult GetAllLocation()
{
using (MyDatabaseEntities dc = new MyDatabaseEntities())
{
var v = dc.Locations.OrderBy(a => a.Title).ToList();
return(new JsonResult {
Data = v, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
}
public JsonResult InsertCustomer(Customer customer)
{
using (MyDatabaseEntities entities = new MyDatabaseEntities())
{
entities.Customers.Add(customer);
entities.SaveChanges();
}
return(Json(customer));
}
//
// GET: /Data/
//For fetch Last Contact
public JsonResult GetLastContact()
{
Contact c = null;
//here MyDatabaseEntities our DBContext
using (MyDatabaseEntities dc = new MyDatabaseEntities())
{
c = dc.Contacts.OrderByDescending(a => a.ContactID).Take(1).FirstOrDefault();
}
return new JsonResult { Data = c, JsonRequestBehavior = JsonRequestBehavior.AllowGet };
}
// GET: MVCLab/ReportDemo/StateArea
public async Task <ActionResult> StateArea()
{
using (MyDatabaseEntities ctx = new MyDatabaseEntities())
{
var qry = ctx.Account.SqlQuery("SELECT * FROM Account");
List <Account> dataList = await qry.ToListAsync();
return(View(dataList));
}
}
public ActionResult Create(Pacote pacote)
{
using (MyDatabaseEntities dc = new MyDatabaseEntities())
{
dc.Pacotes.Add(pacote);
dc.SaveChanges();
}
return(RedirectToAction(nameof(Index)));
}
public JsonResult UserLogin(LoginData d)
{
using (MyDatabaseEntities dc = new MyDatabaseEntities())
{
var user = dc.Users.Where(a => a.Username.Equals(d.Username) && a.Password.Equals(d.Password)).FirstOrDefault();
return(new JsonResult {
Data = user, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
}
public ActionResult Delete(int id)
{
using (MyDatabaseEntities db = new MyDatabaseEntities())
{
Collaborators coll = db.Collaborators.Where(x => x.Id == id).FirstOrDefault <Collaborators>();
db.Collaborators.Remove(coll);
db.SaveChanges();
return(Json(new { success = true, message = "Deleted Successfully" }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult DeleteConfirmed(int id)
{
using (MyDatabaseEntities dc = new MyDatabaseEntities())
{
var pacote = dc.Pacotes.Find(id);
dc.Pacotes.Remove(pacote);
dc.SaveChanges();
return(RedirectToAction(nameof(Index)));
}
}
public ActionResult PaymentHistory(Payment tb)
{
using (MyDatabaseEntities db = new MyDatabaseEntities())
{
return(View(db.Payments.ToList()));
}
return(View());
}
public ActionResult Member(User tb)
{
using (MyDatabaseEntities db = new MyDatabaseEntities())
{
return(View(db.Users.ToList()));
}
return(View());
}
public ActionResult Create(Voo voo)
{
using (MyDatabaseEntities dc = new MyDatabaseEntities())
{
dc.Voos.Add(voo);
dc.SaveChanges();
}
return(RedirectToAction(nameof(Index)));
}
public ActionResult Adult(Victim vt)
{
List <Victim> Lst = new List <Victim>();
using (MyDatabaseEntities db = new MyDatabaseEntities())
{
Lst = db.Victims.SqlQuery("select * from Victim where VictimType='Adult'").ToList();
return(View(Lst));
}
}
public ActionResult DeletePlace(int id)
{
using (MyDatabaseEntities db = new MyDatabaseEntities())
{
ParkingPlace pp = db.ParkingPlace.Where(x => x.Id == id).FirstOrDefault <ParkingPlace>();
db.ParkingPlace.Remove(pp);
db.SaveChanges();
return(Json(new { success = true, message = "Place Deleted Successfully" }, JsonRequestBehavior.AllowGet));
}
}
public JsonResult GetEmployeeList()
{
List<Employee> Employee = new List<Employee>();
using (MyDatabaseEntities dc = new MyDatabaseEntities())
{
Employee = dc.Employees.OrderBy(a => a.FirstName).ToList();
}
return new JsonResult { Data = Employee, JsonRequestBehavior = JsonRequestBehavior.AllowGet };
}
public JsonResult GetEvents()
{
using (MyDatabaseEntities dc = new MyDatabaseEntities())
{
var events = dc.Events.ToList();
return(new JsonResult {
Data = events, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
}
public ActionResult DataAdmin()
{
using (MyDatabaseEntities d = new MyDatabaseEntities())
{
var data = from da in d.DataInfoes
where da.UserEmail != null && (da.Accepted == false || da.Accepted == null)
select da;
return(View(data.ToList()));
}
}
//
// GET: /Order/
public ActionResult List()
{
List<OrderVM> allOrder = new List<OrderVM>();
// here MyDatabaseEntities is our data context
using (MyDatabaseEntities dc = new MyDatabaseEntities())
{
var o = dc.OrderMasters.OrderByDescending(a => a.OrderID);
foreach (var i in o)
{
var od = dc.OrderDetails.Where(a => a.OrderID.Equals(i.OrderID)).ToList();
allOrder.Add(new OrderVM { order= i, orderDetails = od });
}
}
return View(allOrder);
}
public JsonResult CustomerOrders()
{
List<CustomerOrders> CO = new List<CustomerOrders>();
using (MyDatabaseEntities dc = new MyDatabaseEntities())
{
var cust = dc.Customers.OrderBy(a => a.ContactName).ToList();
foreach (var i in cust)
{
var orders = dc.Orders.Where(a => a.CustomerID.Equals(i.CustomerID)).OrderBy(a => a.OrderDate).ToList();
CO.Add(new CustomerOrders
{
Customer = i,
Orders = orders
});
}
}
return new JsonResult { Data = CO, JsonRequestBehavior = JsonRequestBehavior.AllowGet };
}
public ActionResult Login(Login l, string ReturnUrl = "")
{
using (MyDatabaseEntities dc = new MyDatabaseEntities())
{
var user = dc.Users.Where(a => a.Username.Equals(l.Username) && a.Password.Equals(l.Password)).FirstOrDefault();
if (user != null)
{
FormsAuthentication.SetAuthCookie(user.Username, l.RememberMe);
if (Url.IsLocalUrl(ReturnUrl))
{
return Redirect(ReturnUrl);
}
else
{
return RedirectToAction("MyProfile","Home");
}
}
}
ModelState.Remove("Password");
return View();
}
public ActionResult Login(Users u)
{
//this action is for handling post(login)
if (ModelState.IsValid)// this cheks validity
{
using (MyDatabaseEntities dc = new MyDatabaseEntities())
{
var v = dc.Users.Where(a => a.Username.Equals(u.Username) && a.Password.Equals(u.Password)).FirstOrDefault();
if (v != null)
{
Session["LogedUserID"] = v.UserId.ToString();
Session["LogedUserName"] = v.Username.ToString();
return RedirectToAction("AfterLoginTables");
}
}
}
return View(u);
}
public JsonResult GetSalesData()
{
List<GoogleChartData> sd = new List<GoogleChartData>();
using (MyDatabaseEntities dc = new MyDatabaseEntities())
{
sd = dc.GoogleChartDatas.OrderBy(a => a.Year).ToList();
}
var chartData = new object[sd.Count + 1];
chartData[0] = new object[]{
"Year",
"Electronics",
"Book And Media",
"Home And Kitchen"
};
int j = 0;
foreach (var i in sd)
{
j++;
chartData[j] = new object[] { i.Year, i.Electronics, i.BookAndMedia, i.HomeAndKitchen };
}
return new JsonResult { Data = chartData, JsonRequestBehavior = JsonRequestBehavior.AllowGet };
}
public JsonResult SaveFiles(string description)
{
string Message, fileName, actualFileName;
Message = fileName = actualFileName = string.Empty;
bool flag = false;
if (Request.Files != null)
{
var file = Request.Files[0];
actualFileName = file.FileName;
fileName = Guid.NewGuid() + Path.GetExtension(file.FileName);
int size = file.ContentLength;
try
{
file.SaveAs(Path.Combine(Server.MapPath("~/UploadedFiles"), fileName));
UploadedFile f = new UploadedFile
{
FileName = actualFileName,
FilePath = fileName,
Description = description,
FileSize = size
};
using (MyDatabaseEntities dc = new MyDatabaseEntities())
{
dc.UploadedFiles.Add(f);
dc.SaveChanges();
Message = "File uploaded successfully";
flag = true;
}
}
catch (Exception)
{
Message = "File upload failed! Please try again";
}
}
return new JsonResult { Data = new { Message = Message, Status = flag } };
}
