public ActionResult Edit([Bind(Include = "ID,ConUsername,HomeUsername,ConFirstName,HomeFirstname,ConLastName,HomeLastName,ConAddress,HomeAddress,ConCity,HomeCity,ConState,HomeState,ConZip,HomeZip,ConEmail,HomeEmail,PostedDate,Bid,CompletionDeadline,Description,Completed,Invoice,Service_Number")] HomeownerComfirmedBids homeownerComfirmedBids, IEnumerable <HttpPostedFileBase> files)
{
homeownerComfirmedBids.AfterPaths = new List <AfterPath>();
if (ModelState.IsValid)
{
if (files == null)
{
db.Entry(homeownerComfirmedBids).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
foreach (var file in files)
{
if (file != null && file.ContentLength > 0)
{
var photo = new AfterPath()
{
FileName = Guid.NewGuid().ToString() + System.IO.Path.GetExtension(file.FileName)
};
file.SaveAs(Path.Combine(Server.MapPath("~/images"), photo.FileName));
photo.HomeownerComfirmedBidsID = homeownerComfirmedBids.ID;
db.AfterPaths.Add(photo);
}
}
db.Entry(homeownerComfirmedBids).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Confirm", homeownerComfirmedBids));
}
return(View(homeownerComfirmedBids));
}
public ActionResult DeleteConfirmed(int id)
{
HomeownerComfirmedBids homeownerComfirmedBids = db.HomeownerComfirmedBids.Find(id);
db.HomeownerComfirmedBids.Remove(homeownerComfirmedBids);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Confirm(int?id)
{
string identity = System.Web.HttpContext.Current.User.Identity.GetUserId();
if (identity == null)
{
return(RedirectToAction("Unauthorized_Access", "Home"));
}
var confirmedList = db.HomeownerComfirmedBids.ToList();
string ConEmail1 = "";
string ConEmail2 = "";
var person = db.Homeowners.Where(x => x.UserId == identity).SingleOrDefault();
HomeownerComfirmedBids homeownerComfirmedBids = db.HomeownerComfirmedBids.Find(id);
if (homeownerComfirmedBids == null)
{
return(HttpNotFound());
}
foreach (var user in db.Users)
{
if (user.Id == identity)
{
ConEmail2 = user.Email;
}
}
foreach (var i in confirmedList)
{
if (id == i.ID)
{
ConEmail1 = i.ConEmail;
}
}
if (!this.User.IsInRole("Admin") && !(ConEmail1 == ConEmail2))
{
return(RedirectToAction("Unauthorized_Access", "Home"));
}
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
//HomeownerComfirmedBids homeownerComfirmedBids = db.HomeownerComfirmedBids.Find(id);
if (homeownerComfirmedBids == null)
{
return(HttpNotFound());
}
if (homeownerComfirmedBids.Completed == true)
{
return(RedirectToAction("Already_Confirmed_Completion", "CompletedBids"));
}
return(View(homeownerComfirmedBids));
}
public ActionResult Create([Bind(Include = "ID,ConUsername,HomeUsername,ConFirstName,HomeFirstname,ConLastName,HomeLastName,ConAddress,HomeAddress,ConCity,HomeCity,ConState,HomeState,ConZip,HomeZip,ConEmail,HomeEmail,PostedDate,Bid,CompletionDeadline,Description,Completed,Invoice")] HomeownerComfirmedBids homeownerComfirmedBids)
{
if (ModelState.IsValid)
{
db.HomeownerComfirmedBids.Add(homeownerComfirmedBids);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(homeownerComfirmedBids));
}
// GET: HomeownerComfirmedBids/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
HomeownerComfirmedBids homeownerComfirmedBids = db.HomeownerComfirmedBids.Find(id);
if (homeownerComfirmedBids == null)
{
return(HttpNotFound());
}
return(View(homeownerComfirmedBids));
}
// GET: HomeownerComfirmedBids/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
HomeownerComfirmedBids homeownerComfirmedBids = db.HomeownerComfirmedBids.Find(id);
HomeownerComfirmedBids homeownerPics = db.HomeownerComfirmedBids.Include(i => i.ServiceRequestPaths).SingleOrDefault(i => i.ID == id);
if (homeownerComfirmedBids == null)
{
return(HttpNotFound());
}
return(View(homeownerComfirmedBids));
}
public ActionResult Calculate(int?ID, int?id)
{
string identity = System.Web.HttpContext.Current.User.Identity.GetUserId();
if (identity == null)
{
return(RedirectToAction("Unauthorized_Access", "Home"));
}
var conList = db.HomeownerComfirmedBids.ToList();
string ConEmail1 = "";
string ConEmail2 = "";
var person = db.Homeowners.Where(x => x.UserId == identity).SingleOrDefault();
foreach (var user in db.Users)
{
if (user.Id == identity)
{
ConEmail2 = user.Email;
}
}
foreach (var i in conList)
{
if (id == i.ID)
{
ConEmail1 = i.ConEmail;
}
}
if (this.User.IsInRole("Admin") || ConEmail1 == ConEmail2)
{
HomeownerComfirmedBids bid = new HomeownerComfirmedBids();
bid = db.HomeownerComfirmedBids.Find(ID);
return(View(bid));
}
else
{
return(RedirectToAction("Unauthorized_Access", "Home"));
}
}
public ActionResult sendContractor(int id)
{
//if (this.User.IsInRole"conr"){
//}
//}
string HomeEmail = "";
string HomeUserName = "";
string HomeFirstName = "";
string HomeLastName = "";
string HomeAddress = "";
string HomeCity = "";
string HomeState = "";
string HomeZip = "";
int Invoice = 1;
//string JobLocation = "";
var myMessage = new SendGrid.SendGridMessage();
string name = System.IO.File.ReadAllText(@"C:\Users\erick\Desktop\Credentials\name.txt");
string pass = System.IO.File.ReadAllText(@"C:\Users\erick\Desktop\Credentials\password.txt");
var contractors = db.Contractors.ToList();
var homeowners = db.Homeowners.ToList();
var servicerequests = db.ServiceRequests.ToList();
var acceptList = db.ContractorAcceptedBids.ToList();
var confirmedList = db.HomeownerComfirmedBids.ToList();
string identity = System.Web.HttpContext.Current.User.Identity.GetUserId();
var person = db.Homeowners.Where(x => x.UserId == identity).SingleOrDefault();
foreach (var user in db.Users)
{
if (user.Id == identity)
{
HomeEmail = user.Email;
//username1 = user.UserName;
foreach (var home in homeowners)
{
if (home.email == HomeEmail)
{
HomeUserName = home.Username;
HomeFirstName = home.FirstName;
HomeLastName = home.LastName;
HomeAddress = home.Address;
HomeCity = home.City;
HomeState = home.State;
HomeZip = home.Zip;
}
}
}
}
foreach (var i in acceptList)
{
if (id == i.ID)
{
HomeownerComfirmedBids bid = new HomeownerComfirmedBids();
bid.ServiceRequestPaths = new List <ServiceRequestPath>();
bid.ConUsername = i.ConUsername;
bid.HomeUsername = i.HomeUsername;
bid.ConFirstName = i.ConFirstName;
bid.HomeFirstname = i.HomeFirstname;
bid.ConLastName = i.ConLastName;
bid.HomeLastName = i.HomeLastName;
bid.ConAddress = i.ConAddress;
bid.HomeAddress = i.HomeAddress;
bid.ConCity = i.ConCity;
bid.HomeCity = i.HomeCity;
bid.ConState = i.ConState;
bid.HomeState = i.HomeState;
bid.ConZip = i.ConZip;
bid.HomeZip = i.HomeZip;
bid.ConEmail = i.ConEmail;
bid.HomeEmail = i.HomeEmail;
bid.PostedDate = i.PostedDate;
bid.CompletionDeadline = i.CompletionDeadline;
bid.Description = i.Description;
bid.Bid = i.Bid;
bid.Files = i.Files;
bid.Service_Number = i.ServiceNumber;
foreach (var x in confirmedList)
{
if (x.Service_Number == bid.Service_Number)
{
return(RedirectToAction("Already_Confirmed", "HomeOwnerComfirmedBids"));
}
}
foreach (var z in servicerequests)
{
if (z.ServiceNumber == bid.Service_Number)
{
z.Confirmed = true;
}
}
foreach (var x in i.ServiceRequestPaths)
{
bid.ServiceRequestPaths.Add(new ServiceRequestPath()
{
FileName = x.FileName
});
}
bid.expired = i.expired;
bid.Completed = false;
//bid.Service_Number = i.ServiceNumber;
bid.JobLocation = bid.HomeAddress + ", " + bid.HomeCity + ", " + bid.HomeState + " " + bid.HomeZip + ", " + "USA";
//foreach (var x in confirmedList)
//{
// if (x.Service_Number == bid.Service_Number)
// {
// return RedirectToAction("Already_Confirmed", "HomeOwnerComfirmedBids");
// }
//}
//foreach(var z in servicerequests)
//{
// if(z.ServiceNumber == bid.Service_Number)
// {
// z.Confirmed = true;
// }
//}
i.Confirmed = true;
bid.Confirmed = true;
db.HomeownerComfirmedBids.Add(bid);
db.SaveChanges();
Invoice = bid.ID;
bid.Invoice = Invoice;
myMessage.AddTo(i.ConEmail);
myMessage.From = new MailAddress("*****@*****.**", "Admin");
myMessage.Subject = "Homeowner Confirmed Your Service!!";
string url = "http://localhost:14703/HomeownerComfirmedBids/Confirm/" + Invoice;
string url2 = "http://localhost:14703/Maps/Calculate/" + Invoice;
//string message = "Job Location: <br>" + i.Address + "<br>" + i.City + "<br>" + i.State + "<br>" + i.Zip + "<br>" + "<br>" + "Job Description: <br>" + i.Description + "<br>" + "<br>" + "Bid price: <br>$" + i.Bid + "<br>" + "<br>" + "Must be completed by: <br>" + i.CompletionDeadline + "<br>" + "<br>" + "Date Posted: <br>" + i.PostedDate + "<br>" + "<br>" + "To accept job, click on link below: <br><a href =" + url + "> Click Here </a>";
String message = "Hello " + i.ConFirstName + "," + "<br>" + "<br>" + "Homeowner " + HomeUserName + " has confirmed your service for the following request:" + "<br>" + "<br>" + i.Description + "<br>" + "<br>" + "When the job is complete, please confirm completion by clicking on the link below: <br><a href =" + url + "> Click Here </a>" + "<br>" + "<br>" + "Get directions by clicking on the link below: <br><a href =" + url2 + "> Click Here </a>";
myMessage.Html = message;
var credentials = new NetworkCredential(name, pass);
var transportWeb = new SendGrid.Web(credentials);
transportWeb.DeliverAsync(myMessage);
}
//i.posted = true;
db.SaveChanges();
}
return(RedirectToAction("About", "Home"));
}