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"));
}
