public ActionResult ResetPassword(ResetPasswordModel model)
{
var message = "";
if (ModelState.IsValid)
{
using (The_Book_MarketEntities dc = new The_Book_MarketEntities())
{
var user = dc.Users.Where(a => a.ResetCode == model.ResetPassCode).FirstOrDefault();
if (user != null)
{
user.UserPassword = EncryptPassword.Hash(model.NewPassword);
user.ResetCode = "";
dc.Configuration.ValidateOnSaveEnabled = false;
dc.SaveChanges();
message = "New password updated successfully";
}
}
}
else
{
message = "Something invalid";
}
ViewBag.Message = message;
return(View(model));
}
public ActionResult Create([Bind(Include = "Employee_ID,User_ID,Employee_Name,Employee_Surname,Employee_Address,Emp_Phone,Emp_Email,ID_Number,EmpTitle_ID,EmpGender_ID,ImageData")] Employee employee)
{
if (ModelState.IsValid)
{
/*string fileName = Path.GetFileNameWithoutExtension(employee.ImageFile.FileName);
* string extension = Path.GetExtension(employee.ImageFile.FileName);
* fileName = fileName + DateTime.Now.ToString("yymmssfff") + extension;
* employee.ImageData = "~/Image/" + fileName;
* fileName = Path.Combine(Server.MapPath("~/Image/"), fileName);
* employee.ImageFile.SaveAs(fileName);*/
using (The_Book_MarketEntities db = new The_Book_MarketEntities())
{
db.Employees.Add(employee);
db.SaveChanges();
}
ViewBag.FileStatus = "Employee Added successfully.";
return(RedirectToAction("Index"));
}
ViewBag.EmpGender_ID = new SelectList(db.Employee_Gender, "EmpGender_ID", "Gender_Description", employee.EmpGender_ID);
ViewBag.EmpTitle_ID = new SelectList(db.Employee_Title, "EmpTitle_ID", "Title_Description", employee.EmpTitle_ID);
ViewBag.User_ID = new SelectList(db.Users, "User_ID", "UserName", employee.User_ID);
return(View(employee));
}
public ActionResult ResetPassword(string id)
{
//Verify the reset password link
//Find account associated with this link
//redirect to reset password page
if (string.IsNullOrWhiteSpace(id))
{
return(HttpNotFound("Invalid user"));
}
using (The_Book_MarketEntities dc = new The_Book_MarketEntities())
{
var user = dc.Users.Where(a => a.ResetCode == id).FirstOrDefault();
if (user != null)
{
ResetPasswordModel model = new ResetPasswordModel();
model.ResetPassCode = id;
return(View(model));
}
else
{
return(HttpNotFound("Invalid user"));
}
}
}
public ActionResult Login(UserLogin login, string ReturnUrl = "")
{
string message = "";
using (The_Book_MarketEntities dc = new The_Book_MarketEntities())
{
try
{
var v = dc.Users.Where(a => a.UserName == login.UserName).FirstOrDefault();
if (v != null)
{
if (v.IsUserVerified == false)
{
ViewBag.Message = "Please verify your email first";
return(View());
}
if (string.Compare(EncryptPassword.Hash(login.UserPassword), v.UserPassword) == 0)
{
int timeout = login.RememberMe ? 525600 : 20; // 525600 min = 1 year
var ticket = new FormsAuthenticationTicket(login.UserName, login.RememberMe, timeout);
string encrypted = FormsAuthentication.Encrypt(ticket);
var cookie = new HttpCookie(FormsAuthentication.FormsCookieName, encrypted);
cookie.Expires = DateTime.Now.AddMinutes(timeout);
cookie.HttpOnly = true;
Response.Cookies.Add(cookie);
if (Url.IsLocalUrl(ReturnUrl))
{
return(Redirect(ReturnUrl));
}
else
{
return(RedirectToAction("Index", "Home"));
}
}
else
{
message = "Invalid credential provided";
}
}
else
{
message = "Invalid credential provided";
}
}
catch (Exception e)
{
ViewBag.Message = e.Message;
}
}
if (message != "")
{
ViewBag.Message = message;
}
return(View());
}
public bool IsUserExist(string username)
{
using (The_Book_MarketEntities dc = new The_Book_MarketEntities())
{
var v = dc.Users.Where(a => a.UserName == username).FirstOrDefault();
return(v != null);
}
}
public ActionResult GetData()
{
using (The_Book_MarketEntities db = new The_Book_MarketEntities())
{
List <Customer> customerList = db.Customers.ToList <Customer>();
return(Json(new { data = customerList }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Register([Bind(Exclude = "IsUserVerified, GUID")] User user)
{
bool Status = false;
string message = "";
//
// Model Validation
if (ModelState.IsValid)
{
user.IsUserVerified = false;
#region //User already Exist
var isExist = IsUserExist(user.UserName);
if (isExist)
{
ModelState.AddModelError("UserExist", "User already exist");
return(View(user));
}
#endregion
#region Generate user Activation Code
user.GUID = Guid.NewGuid();
#endregion
#region Password Hashing
user.UserPassword = EncryptPassword.Hash(user.UserPassword);
//user.PassConfirm = EncryptPassword.Hash(user.PassConfirm);
#endregion
#region Save user to Database
using (The_Book_MarketEntities dc = new The_Book_MarketEntities())
{
dc.Users.Add(user);
dc.SaveChanges();
//Send Email to User
SendVerificationLinkEmail(user.UserName, user.GUID.ToString());
message = "Registration successfully done. Account activation link " +
" has been sent to user email id:" + user.UserName;
Status = true;
}
#endregion
}
else
{
message = "Invalid Request";
}
ViewBag.Message = message;
ViewBag.Status = Status;
ViewBag.UserRole_ID = new SelectList(db.User_Role, "UserRole_ID", "UserRole_Description", user.UserRole_ID);
return(View(user));
}
public ActionResult Index(HttpPostedFileBase xmlFile)
{
if (xmlFile.ContentType.Equals("application/xml") || xmlFile.ContentType.Equals("text/xml"))
{
try
{
var xmlPath = Server.MapPath("~/FileUpload" + xmlFile.FileName);
xmlFile.SaveAs(xmlPath);
XDocument xDoc = XDocument.Load(xmlPath);
List <Customer> custList = xDoc.Descendants("customer").Select
(customer => new Customer
{
Customer_ID = Convert.ToInt32(customer.Element("id").Value),
Customer_Name = customer.Element("name").Value,
Customer_Surname = customer.Element("surname").Value,
Customer_Email = customer.Element("email").Value,
Customer_Contact = customer.Element("contact").Value
}).ToList();
using (The_Book_MarketEntities db = new The_Book_MarketEntities())
{
foreach (var i in custList)
{
var v = db.Customers.Where(a => a.Customer_ID.Equals(i.Customer_ID)).FirstOrDefault();
if (v != null)
{
v.Customer_ID = i.Customer_ID;
v.Customer_Name = i.Customer_Name;
v.Customer_Surname = i.Customer_Surname;
v.Customer_Email = i.Customer_Email;
v.Customer_Contact = i.Customer_Contact;
}
else
{
db.Customers.Add(i);
}
}
db.SaveChanges();
ViewBag.Result = db.Customers.ToList();
}
return(View("Success"));
}
catch
{
ViewBag.Error = "Cant Import XML File";
return(View("Index"));
}
}
else
{
ViewBag.Error = "Cant Import XML File";
return(View("Index"));
}
}
public ActionResult ForgotPassword(string userName)
{
//Verify Email ID
//Generate Reset password link
//Send Email
string message = "";
bool status = false;
using (The_Book_MarketEntities dc = new The_Book_MarketEntities())
{
var account = dc.Users.Where(a => a.UserName == userName).FirstOrDefault();
try
{
if (account != null)
{
//Send email for reset password
string resetCode = Guid.NewGuid().ToString();
SendResetPasswordLinkEmail(account.UserName, resetCode);
//SendVerificationLinkEmail(account.UserName, resetCode);
account.ResetCode = resetCode;
// added to avoid confirm password area in model
dc.Configuration.ValidateOnSaveEnabled = false;
dc.SaveChanges();
message = "Reset password link has been sent to your email id.";
}
else
{
message = "Account not found";
}
}
catch (System.Data.Entity.Validation.DbEntityValidationException dbEx)
{
Exception raise = dbEx;
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
string Message = string.Format("{0}:{1}",
validationErrors.Entry.Entity.ToString(),
validationError.ErrorMessage);
// raise a new exception nesting
// the current instance as InnerException
raise = new InvalidOperationException(message, raise);
}
}
throw raise;
}
}
ViewBag.Message = message;
return(View());
}
public JsonResult GetInventory(string word, int page, int rows, string searchString, string sord)
{
using (The_Book_MarketEntities db = new The_Book_MarketEntities())
{
//#2 Setting Paging
int pageIndex = Convert.ToInt32(page) - 1;
int pageSize = rows;
//#3 Linq Query to Get Customer
var Results = db.Inventories.Select(
a => new
{
a.Inventory_ID,
a.InventoryType_ID,
a.Inventory_Name,
a.Inventory_Description,
a.Inventory_Quantity,
a.Minimum_Quantity,
a.StockTurn_ID,
});
//#4 Get Total Row Count
int totalRecords = Results.Count();
var totalPages = (int)Math.Ceiling((float)totalRecords / (float)rows);
//#5 Setting Sorting
if (sord.ToUpper() == "DESC")
{
Results = Results.OrderByDescending(s => s.Inventory_ID);
Results = Results.Skip(pageIndex * pageSize).Take(pageSize);
}
else
{
Results = Results.OrderBy(s => s.Inventory_ID);
Results = Results.Skip(pageIndex * pageSize).Take(pageSize);
}
//#6 Setting Search
if (!string.IsNullOrEmpty(searchString))
{
Results = Results.Where(m => m.Inventory_Description == searchString);
}
//#7 Sending Json Object to View.
var jsonData = new
{
total = totalPages,
page,
records = totalRecords,
rows = Results
};
return(Json(jsonData, JsonRequestBehavior.AllowGet));
}
}
public ActionResult VerifyAccount(string id)
{
bool Status = false;
using (The_Book_MarketEntities dc = new The_Book_MarketEntities())
{
/*dc.Configuration.ValidateOnSaveEnabled = false;
* // to avoid
* // Confirm password does not match issue on save changes*/
var v = dc.Users.Where(a => a.GUID == new Guid(id)).FirstOrDefault();
if (v != null)
{
v.IsUserVerified = true;
dc.SaveChanges();
Status = true;
}
else
{
ViewBag.Message = "Invalid Request";
}
}
ViewBag.Status = Status;
return(View());
}
