public ActionResult ProfileSetting(User u)
{
PRSContext db = PRSContext.GetInstance();
if (ModelState.IsValid)
{
using (db)
{
if (!string.IsNullOrEmpty(u.Password))
{
u.Password = HelperMethods.Sha256(u.Password);
}
if (!string.IsNullOrEmpty(u.ConfirmPassword))
{
u.ConfirmPassword = HelperMethods.Sha256(u.ConfirmPassword);
}
if (u.ImageUrl.Contains("user-circle.png"))
{
u.ImageUrl = new UserHandler().GetUserById(u.Id).ImageUrl;
}
db.Entry(u).State = EntityState.Modified;
db.SaveChanges();
Session.Add(WebUtils.CurrentUser, new UserHandler().GetUserById(u.Id));
}
}
return(RedirectToAction("ProfileSetting", "Users"));
}
public ActionResult Register(User user)
{
try
{
long uno = DateTime.Now.Ticks;
int counter = 0;
foreach (string fileName in Request.Files)
{
HttpPostedFileBase file = Request.Files[fileName];
if (!string.IsNullOrEmpty(file.FileName))
{
string abc = uno + "_" + ++counter +
file.FileName.Substring(file.FileName.LastIndexOf("."));
//dont save the url of the Images Save the
string url = "~/Content/UserImages/" + abc;
string path = Request.MapPath(url);
user.ImageUrl = abc;
file.SaveAs(path);
}
}
var uh = new UserHandler();
if (uh.AdminExists())
{
user.Role = uh.GetRoleById(2);
}
else
{
user.Role = uh.GetRoleById(1);
}
user.Password = HelperMethods.Sha256(user.Password);
user.ConfirmPassword = HelperMethods.Sha256(user.ConfirmPassword);
PRSContext db = PRSContext.GetInstance();
using (db)
{
db.Users.Attach(user);
db.Users.Add(user);
db.Entry(user.Role).State = EntityState.Unchanged;
db.SaveChanges();
}
return(RedirectToAction("Login"));
}
catch (DbEntityValidationException e)
{
string text = "";
foreach (var eve in e.EntityValidationErrors)
{
text = String.Format("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:{2}", eve.Entry.Entity.GetType().Name, eve.Entry.State, Environment.NewLine);
foreach (var ve in eve.ValidationErrors)
{
text = String.Format("{0}{0}- Property: \"{1}\", Error: \"{2}\"", Environment.NewLine, ve.PropertyName, ve.ErrorMessage);
}
}
return(Content(text));
}
catch (Exception e)
{
System.Diagnostics.Debug.WriteLine(e);
throw;
}
}
public CollectorController(PRSContext context, CollectorService hostedService)
{
this.context = context;
this.communicationSetting = new CommunicationSetting();
this.systemAPIPort = communicationSetting.communicationPort.systemAPIPort;
this.userRepository = new Repository <Models.Models.User>(this.context);
this.collectorService = hostedService;
}
public int GetMessageCount()
{
PRSContext db = PRSContext.GetInstance();
using (db)
{
return((from c in db.Contacts select c).Count());
}
}
public int TotalServices()
{
PRSContext db = PRSContext.GetInstance();
using (db)
{
return((from c in db.Services select c).Count());
}
}
public UserController(PRSContext context)
{
this.context = context;
this.userRepository = new Repository <Models.Models.User>(this.context);
this.contactRepository = new Repository <Contact>(this.context);
this.communicationSetting = new CommunicationSetting();
this.mainApiPort = communicationSetting.communicationPort.mainAPIPort;
this.utilities = new Utilities();
}
public int GetUserByCount()
{
PRSContext db = PRSContext.GetInstance();
using (db)
{
return((from a in db.Users select a).Count());
}
}
static void Main(string[] args)
{
var _context = new PRSContext();
var users = _context.User.ToList();
var user1 = _context.User.Find(1);
user1.PhoneNumber = "513-555-1212";
_context.SaveChanges();
var control = new UsersController(_context);
var user = control.Login("Steve", "SteveSteve");
var user2 = control.Login("Stevebob", "SteveSteve");
var ReqCtrl = new RequestsController(_context);
var changeApprove = ReqCtrl.SetToApprove(_context.Request.Find(1));
var VendorCtrl = new VendorController(_context);
var vendorList = VendorCtrl.GetVendors();
}
public ActionResult ChangePassword(FormCollection formdata, int id)
{
PRSContext db = PRSContext.GetInstance();
using (db)
{
User user = db.Users.Find(id);
if (user != null)
{
user.Password = HelperMethods.Sha256(formdata["Password"]);
user.ConfirmPassword = user.Password;
db.Entry(user).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("login", "Users"));
}
}
return(View());
}
static void Main(string[] args)
{
var _context = new PRSContext();
var ReqCtrl = new RequestsController(_context);
//.context. is stating to search in table 'Requests' and search the DB columns (i.e - Lineitems, Vendors, Products, Status and so on...
// (cont...) and telling it what you need (i.e) .Find
var req1 = _context.Requests.Find(1);
var ok = ReqCtrl.ReviewRequest.(req1);
var req3 = _context.Requests.Find(3);
ok = ReqCtrl.ReviewRequest(req3);
var req2 = _context.Requests.Find(2);
var isWorked = ReqCtrl.SetToApproved(req2);
var UserCtrl = new UsersController(_context);
//Tests the login function
var user = UserCtrl.Login("xx, xx");
var xxuser = UserCtrl.Login("xx", "xx");
var sauser = UserCtrl.Login("sa", "sa");
}
public ActionResult AddServices(Service service)
{
if (!ModelState.IsValid)
{
return(View());
}
try
{
PRSContext db = PRSContext.GetInstance();
if (ModelState.IsValid)
{
db.Services.Add(service);
db.SaveChanges();
return(RedirectToAction("Thanks", "Admin"));
}
}
catch (Exception e)
{
Console.WriteLine(e);
throw;
}
return(View());
}
public ActionResult PasswordRecovery(Email data)
{
try
{
PRSContext db = PRSContext.GetInstance();
if (ModelState.IsValid)
{
User user = new UserHandler().GetUserByEmail(data.email);
string c = Path.GetRandomFileName().Replace(".", "");
user.Password = HelperMethods.Sha256(Convert.ToString(c));
user.ConfirmPassword = user.Password;
var message = new MailMessage();
message.To.Add(new MailAddress(data.email));
message.Subject = "Your new password for PRS";
message.Body = $"Dear {user.UserName}\n" +
$"You password have been changed. Your new password is: {c}\n" +
$"Please change your password after logging in.\n" +
$"Thanks";
message.IsBodyHtml = false;
using (var smtp = new SmtpClient())
{
smtp.Send(message);
db.Entry(user).State = EntityState.Modified;
db.SaveChanges();
ViewBag.Success = "Email has been Sent To You Successfully!";
}
return(View());
}
}
catch (Exception)
{
ViewBag.Error = "Error Sending Email. Try Again Later.";
}
return(View());
}
static void Main(string[] args)
{
using (var context = new PRSContext()) { //create instance of new context. add using library
//var request = new Request() {
// Id = 0,
// Description = "Another New Request",
// Justification = "I dont need one",
// ReasonRejection = null,
// DeliveryMode = "Pickup",
// Status = "NEW",
// Total = 0,
// UserId = context.Users.SingleOrDefault(u => u.Username.Equals("Jeff")).Id //brings back a whole user insance. only want Id
//};
//context.Request.Add(request); //adds to collection but not to db
//var reqs = (from r in context.Request
// select r).ToList();
//reqs.ForEach(r => {
// r.Total = r.RequestLine.Sum(1 => 1.Product.Price * 1.Quantity);
// ToConsole(r);
//});
//context.SaveChanges();
//var total = context.Request.Sum(r => r.Total);
//Console.WriteLine($"Total of all requests is {total}");
var req3 = context.Request.Find(3);
//req3.Total = req3.RequestLine.Sum(1 => 1.Product.Price * 1.Quantity); //keeps request total up to date
context.SaveChanges();
Console.WriteLine($"{req3.Description} {req3.Status} {req3.Total.ToString("C")}");
req3.RequestLine.ToList().ForEach(r1 => {
Console.WriteLine($"{r1.Product.Name,-10} {r1.Quantity,5} " +
$"{r1.Product.Price.ToString("C"),10}" +
$"{(r1.Product.Price * r1.Quantity).ToString("C"),11}");
});
//var request = new Request() { Id = 4, Description = "Another Changed Description" }; //read record to change
//var dbRequest = context.Request.Find(request.Id);
//dbRequest.Description = request.Description;
//dbRequest = context.Request.Find(4);
//context.Request.Remove(dbRequest);
//context.SaveChanges(); //adds changes to the db
var Nike = context.Vendors.Find(1); //.Find is same as get by pk
Console.WriteLine($"{Nike.Code} {Nike.Name}");
////var users = context.Users.ToList(); //create collection instance of user data
//var users = from u in context.Users.ToList()
// where u.Username.Contains("1") || u.Username.Contains("J")
// select u;
//foreach (var user in users) {
// Console.WriteLine($"{user.Username} {user.Firstname} {user.Lastname}");
//}
}
}
public RequestLinesController(PRSContext context)
{
_context = context;
}
public UsersController(PRSContext context)
{
_context = context;
}
static void Main(string[] args)
{
using (var context = new PRSContext()) {
//var request = new Request() {
// Id = 0,
// Description = "Another New Request",
// Justification = "I Don't Need One...",
// RejectReason = null,
// DeliveryMode = "Pickup",
// Status = "NEW",
// Total = 0,
// UserId = context.Users.SingleOrDefault(u => u.Username.Equals("testuser1")).Id
//};
//context.Request.Add(request);
//read for request(with lines) print off desc and total, then print lines associated with it (price product quantity)
//var product = new Products() {
// Id = 0,
// Name = "NewProd",
// PartNbr = "45hg",
// Price = 10,
// Unit = "each",
// PhotoPath = null,
// VendorId = 2
//};
//context.Products.Add(product);
//var requestlinenew = new RequestLine() {
// Id = 0,
// RequestId = 6,
// ProductId = 10,
// Quantity = 2
//};
//context.RequestLine.Add(requestlinenew);
var dbRequest = context.Request.Find(6);
dbRequest.Total = dbRequest.RequestLine.Sum(l => l.Product.Price * l.Quantity);
Console.WriteLine($"{dbRequest.Description} {dbRequest.Status} {dbRequest.Total.ToString("C")}");
dbRequest.RequestLine.ToList().ForEach(r1 => {
Console.WriteLine($"{r1.Product.Name,-10} {r1.Quantity,5} {r1.Product.Price.ToString("C"),10}, {(r1.Product.Price * r1.Quantity).ToString("C"),11}");
});
var GrandTotal = context.Request.Sum(r => r.Total);
Console.WriteLine(GrandTotal);
// context.Request.Remove(dbRequest);
context.SaveChanges();
var vendor = context.Vendors.Find(1);
Console.WriteLine($"{vendor.Code} {vendor.Name}");
//var users = context.Users.ToList();
var users = from u in context.Users.ToList()
where u.Username.Contains("A") || u.Username.Contains("0")
select u;
foreach (var user in users)
{
Console.WriteLine($"{user.Username} {user.Firstname} {user.Lastname}");
}
}
}
public ProductsController(PRSContext context)
{
_context = context;
}
public VendorsController(PRSContext context)
{
_context = context;
}
public PurchaseRequestsController(PRSContext context)
{
_context = context;
}
