public ActionResult DeleteConfirmed(short id) { var constring = System.Configuration.ConfigurationManager.ConnectionStrings["pubsEntities"].ConnectionString; if (constring.ToLower().StartsWith("metadata=")) { System.Data.Entity.Core.EntityClient.EntityConnectionStringBuilder efBuilder = new System.Data.Entity.Core.EntityClient.EntityConnectionStringBuilder(constring); constring = efBuilder.ProviderConnectionString; } var con = new SqlConnection(constring); con.Open(); string query = "SELECT COUNT(*) FROM employee"; var cmd = new SqlCommand(query, con); int rowsAmount = (int)cmd.ExecuteScalar(); employee employee; for (int i = 0; i < rowsAmount; i++) { employee = db.employee.FirstOrDefault(m => m.job_id == id); if (employee == null) { } else { db.employee.Remove(employee); db.SaveChanges(); } } jobs jobs = db.jobs.Find(id); db.jobs.Remove(jobs); db.SaveChanges(); return(RedirectToAction("Index")); }
// PUT api/jobs/5 public HttpResponseMessage Put(int id, [FromBody] jobs job) { try { using (RidersDetailsEntities entities = new RidersDetailsEntities()) { var entity = entities.jobs.FirstOrDefault(e => e.Id == id); if (entity == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Jobs with id = " + id.ToString() + "not found")); } else { entity.Date_Time = job.Date_Time; entity.Rider_Id = job.Rider_Id; entity.Review_Score = job.Review_Score; entity.Review_Comment = job.Review_Comment; entity.Completed_At = job.Completed_At; entities.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, entity)); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public async Task <IActionResult> Edit(int id, [Bind("ID,CompanyName,EndDate,StartDate,jobTitle")] jobs jobs) { if (id != jobs.ID) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(jobs); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!jobsExists(jobs.ID)) { return(NotFound()); } else { throw; } } return(RedirectToAction("Index")); } return(View(jobs)); }
public ActionResult DeleteConfirmed(short id) { jobs jobs = db.jobs.Find(id); db.jobs.Remove(jobs); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "JID,JobName,Description,DateEnd")] jobs jobs) { if (ModelState.IsValid) { db.Entry(jobs).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("List")); } return(View(jobs)); }
public ActionResult Edit([Bind(Include = "job_id,job_desc,min_lvl,max_lvl")] jobs jobs) { if (ModelState.IsValid) { db.Entry(jobs).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(jobs)); }
public ActionResult Create([Bind(Include = "JID,JobName,Description,DateEnd")] jobs jobs) { if (ModelState.IsValid) { db.jobs.Add(jobs); db.SaveChanges(); return(RedirectToAction("List")); } return(View(jobs)); }
public ActionResult Create([Bind(Include = "job_id,job_desc,min_lvl,max_lvl")] jobs jobs) { if (ModelState.IsValid) { db.jobs.Add(jobs); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(jobs)); }
public async Task <IActionResult> Create([Bind("ID,CompanyName,EndDate,StartDate,jobTitle")] jobs jobs) { if (ModelState.IsValid) { _context.Add(jobs); await _context.SaveChangesAsync(); return(RedirectToAction("Index")); } return(View(jobs)); }
// GET: jobs/Edit/5 public ActionResult Edit(int id) { jobs jobs = db.jobs.Find(id); if (jobs == null) { return(HttpNotFound()); } ViewBag.categoryid = new SelectList(db.categories, "id", "categoryname", jobs.categoryid); ViewBag.myimage = jobs.jobimage; return(View(jobs)); }
// GET: Job public ActionResult Add(jobs item) { if (ModelState.IsValid) { EFService.Add(item); } else { return(View(item)); } return(RedirectToAction("index")); }
// GET: jobs/Delete/5 public ActionResult Delete(short?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } jobs jobs = db.jobs.Find(id); if (jobs == null) { return(HttpNotFound()); } return(View(jobs)); }
public ActionResult DeleteConfirmed(int id) { jobs jobs = db.jobs.Find(id); db.jobs.Remove(jobs); db.SaveChanges(); string patheimage = Path.Combine(Server.MapPath("~/uploaded"), jobs.image); if (System.IO.File.Exists(patheimage)) { System.IO.File.Delete(patheimage); } return(RedirectToAction("Index")); }
public ActionResult job(jobs ob) { if (ModelState.IsValid) { registrationEntities std = new registrationEntities(); std.sp_job(ob.id, ob.jobtitle, ob.experiance, ob.vaccancies, ob.contactnumber, ob.email); ob.msg = ("successfully added"); ModelState.Clear(); return(View("compjob", ob)); } return(View("compjob", ob)); }
public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } jobs jobs = dp.jobs.Find(id); if (jobs == null) { return(HttpNotFound()); } Session["jobsid"] = id; return(View(jobs)); }
public ActionResult Details(int?id) { ViewBag.JID = new SelectList(db.jobs, "JobName", "JobName"); if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } jobs jobs = db.jobs.Find(id); if (jobs == null) { return(HttpNotFound()); } return(View(jobs)); }
// GET: /jobs/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(RedirectToAction("Index")); } jobs jobs = db.jobs.Find(id); if (jobs == null) { return(HttpNotFound()); } ViewBag.catigid = new SelectList(db.Catigs, "id", "Name"); return(View(jobs)); }
public ActionResult Create(jobs jobs, HttpPostedFileBase upload) { if (ModelState.IsValid) { ViewBag.catigid = new SelectList(db.Catigs, "id", "Name", jobs.catigid); string path = Path.Combine(Server.MapPath("~/uploaded"), upload.FileName); upload.SaveAs(path); jobs.image = upload.FileName; jobs.userid = User.Identity.GetUserId(); db.jobs.Add(jobs); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(jobs)); }
// POST api/jobs public HttpResponseMessage Post([FromBody] jobs jobs) { try { using (RidersDetailsEntities entities = new RidersDetailsEntities()) { entities.jobs.Add(jobs); entities.SaveChanges(); var message = Request.CreateResponse(HttpStatusCode.Created, jobs); message.Headers.Location = new Uri(Request.RequestUri + jobs.Id.ToString()); return(message); } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public ActionResult Edit(jobs job, HttpPostedFileBase upload) { jobs n = db.jobs.Find(job.id); if (ModelState.IsValid) { if (upload != null) { string oldpath = Path.Combine(Server.MapPath("~/uploads"), n.jobimage.ToString()); string path = Path.Combine(Server.MapPath("~/uploads"), upload.FileName); upload.SaveAs(path); n.jobimage = upload.FileName; System.IO.File.Delete(oldpath); } n.jobtitle = job.jobtitle; n.jobcontent = job.jobcontent; n.categoryid = job.categoryid; db.Entry(n).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.categoryid = new SelectList(db.categories, "id", "categoryname", job.categoryid); return(View(n)); }
public ActionResult Edit(jobs jobs, HttpPostedFileBase upload) { var curUser = User.Identity.GetUserId(); if (ModelState.IsValid) { if (upload != null) { string oldpath = Path.Combine(Server.MapPath("~/uploaded"), jobs.image); System.IO.File.Delete(oldpath); string NewPath = Path.Combine(Server.MapPath("~/uploaded"), upload.FileName); upload.SaveAs(NewPath); jobs.image = upload.FileName; } jobs.userid = curUser; db.Entry(jobs).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.catigid = new SelectList(db.Catigs, "id", "Name", jobs.catigid); return(View(jobs)); }
static void Main(string[] args) { #region Parse Parameters for (int i = 0; i < args.Length; i++) { switch (args[i]) { case "-add": if (job != jobs.unknown) { Console.WriteLine("Can't do more than one job. Run programm twice..."); return; } job = jobs.add; break; case "-clean": if (job != jobs.unknown) { Console.WriteLine("Can't do more than one job. Run programm twice..."); return; } job = jobs.removeUnexisting; break; case "-truncate": if (job != jobs.unknown) { Usage(); Console.WriteLine("Can't do more than one job. Run programm twice..."); return; } job = jobs.truncate; break; case "-s": connectinString = args[++i]; break; case "-db": dbType = args[++i].ToLower(); break; case "-provider": provider = args[++i].ToLower(); break; case "-fn": if (rootPath != String.Empty) { Usage(); Console.WriteLine("Filename OR Rootdirectory..."); return; } fileName = args[++i]; break; case "-rd": if (fileName != String.Empty) { Usage(); Console.WriteLine("Filename OR Rootdirectory..."); return; } rootPath = args[++i]; break; case "-f": Filters = args[++i]; break; } } #endregion #region Check Parameters if (connectinString == String.Empty) { Usage(); Console.WriteLine("No connection string..."); return; } switch (job) { case jobs.removeUnexisting: case jobs.truncate: break; case jobs.add: if (fileName == String.Empty && (rootPath == String.Empty || Filters == String.Empty)) { Usage(); Console.WriteLine("No file or rootdirectory and filter defined..."); return; } break; case jobs.unknown: Usage(); Console.WriteLine("No job defined..."); return; } #endregion DateTime dt = DateTime.Now; string mdb = ConfigTextStream.ExtractValue(connectinString, "mdb"); string dsname = ConfigTextStream.ExtractValue(connectinString, "dsname"); string connStr = ConfigTextStream.RemoveValue(connectinString, "dsname"); IFeatureDataset ds = null; if (mdb != String.Empty) { AccessFDB fdb = new AccessFDB(); fdb.Open(connStr); IFeatureDataset dataset = fdb[dsname]; if (dataset == null) { Console.WriteLine("Error opening dataset: " + fdb.lastErrorMsg); return; } //dataset.ConnectionString = connectinString; if (!dataset.Open()) { Console.WriteLine("Error opening dataset: " + dataset.lastErrorMsg); return; } ds = dataset; } else if (dbType == "sql") { SqlFDB fdb = new SqlFDB(); fdb.Open(connStr); IFeatureDataset dataset = fdb[dsname]; if (dataset == null) { Console.WriteLine("Error opening dataset: " + fdb.lastErrorMsg); return; } //dataset.ConnectionString = connectinString; if (!dataset.Open()) { Console.WriteLine("Error opening dataset: " + dataset.lastErrorMsg); return; } ds = dataset; } else if (dbType == "postgres") { pgFDB fdb = new pgFDB(); fdb.Open(connStr); IFeatureDataset dataset = fdb[dsname]; if (dataset == null) { Console.WriteLine("Error opening dataset: " + fdb.lastErrorMsg); return; } //dataset.ConnectionString = connectinString; if (!dataset.Open()) { Console.WriteLine("Error opening dataset: " + dataset.lastErrorMsg); return; } ds = dataset; } else if (dbType == "sqlite") { SQLiteFDB fdb = new SQLiteFDB(); fdb.Open(connStr); IFeatureDataset dataset = fdb[dsname]; if (dataset == null) { Console.WriteLine("Error opening dataset: " + fdb.lastErrorMsg); return; } //dataset.ConnectionString = connectinString; if (!dataset.Open()) { Console.WriteLine("Error opening dataset: " + dataset.lastErrorMsg); return; } ds = dataset; } IRasterFileDataset rds = null; if (provider == "gdal") { rds = PlugInManager.Create(new Guid("43DFABF1-3D19-438c-84DA-F8BA0B266592")) as IRasterFileDataset; } else if (provider == "raster") { rds = PlugInManager.Create(new Guid("D4812641-3F53-48eb-A66C-FC0203980C79")) as IRasterFileDataset; } Dictionary <string, Guid> providers = new Dictionary <string, Guid>(); if (rds != null) { foreach (string format in rds.SupportedFileFilter.Split('|')) { string extension = format; int pos = format.LastIndexOf("."); if (pos > 0) { extension = format.Substring(pos, format.Length - pos); } providers.Add(extension, PlugInManager.PlugInID(rds)); Console.WriteLine("Provider " + extension + ": " + rds.ToString() + " {" + PlugInManager.PlugInID(rds).ToString() + "}"); } } if (providers.Count == 0) { providers = null; } switch (job) { case jobs.truncate: Truncate(ds, dsname + "_IMAGE_POLYGONS"); break; case jobs.removeUnexisting: RemoveUnexisting(ds); CalculateExtent(ds); break; case jobs.add: if (fileName != String.Empty) { if (!ImportFiles(ds, fileName.Split(';'), providers)) { if (!continueOnError) { return; } } } else if (rootPath != String.Empty && Filters != String.Empty) { if (!ImportDirectory(ds, new DirectoryInfo(rootPath), Filters.Split(';'), providers)) { if (!continueOnError) { return; } } } CalculateExtent(ds); break; } Console.WriteLine("\n" + ((TimeSpan)(DateTime.Now - dt)).TotalSeconds + "s"); Console.WriteLine("done..."); }
// GET: Job public ActionResult Update(jobs item) { EFService.Edit(item); return(View("Index")); }