public ActionResult DeleteConfirmed(int id) { tblResource tblresource = db.tblResources.Find(id); db.tblResources.Remove(tblresource); db.SaveChanges(); DisplaySuccessMessage("Has delete a tblResource record"); return(RedirectToAction("Index")); }
// GET: Resource/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tblResource tblResource = db.tblResources.Find(id); if (tblResource == null) { return(HttpNotFound()); } return(View(tblResource)); }
// GET: Resource/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tblResource tblresource = db.tblResources.Find(id); if (tblresource == null) { return(HttpNotFound()); } ViewBag.TemplateID = new SelectList(db.tblTemplates, "TemplateID", "TemplateName", tblresource.TemplateID); return(View(tblresource)); }
public ActionResult Edit([Bind(Include = "ResourceID,MobileNumber,ResourceLocation,TemplateID,tblEnergies,tblTemplate,CooridatesGoogle")] tblResource tblresource) { int c_id = Convert.ToInt32(Session["CompanyID"]); if (ModelState.IsValid) { tblresource.CompanyID = c_id; db.Entry(tblresource).State = EntityState.Modified; db.SaveChanges(); DisplaySuccessMessage("Has update a tblResource record"); return(RedirectToAction("Index")); } ViewBag.TemplateID = new SelectList(db.tblTemplates, "TemplateID", "TemplateName", tblresource.TemplateID); DisplayErrorMessage(); return(View(tblresource)); }
public ContentResult FileUploadByInternTutor(int InternshipId) { string path = Server.MapPath("~/InternTutor/Resource/"); tblResource objResource = null; db = new CourseDataContext(); Int64 intInternTutorId = 0; Int64.TryParse(Session["InternTutorId"].ToString(), out intInternTutorId); foreach (string key in Request.Files) { HttpPostedFileBase postedFileBase = Request.Files[key]; postedFileBase.SaveAs(path + postedFileBase.FileName); objResource = new tblResource(); objResource.DateCreated = DateTime.Now; objResource.CreatedBy = Session["InternTutorUser"].ToString(); objResource.ResourceName = postedFileBase.FileName; objResource.ResourceType = postedFileBase.ContentType; objResource.TutorId = intInternTutorId; // objResource.CourseId = CourseId; objResource.InternshipId = InternshipId; objResource.CreatedBy = Session["InternTutorUser"].ToString(); objResource.UserType = "InternTutor"; db.tblResources.InsertOnSubmit(objResource); db.SubmitChanges(); } if (Request.Files.Count > 0) { if (objResource.ResourceId > 0) { return(Content("Successfully")); } return(Content("Failed")); } return(Content("Failed")); }
//[ValidateAntiForgeryToken] public ActionResult Create([Bind(Include = "ResourceID,MobileNumber,ResourceLocation,TemplateID,CooridatesGoogle")] tblResource tblresource) { int c_id = Convert.ToInt32(Session["CompanyID"]); var item = Request.Form["TemplateID"]; int ddlTemplateValue; if (item == null) { ddlTemplateValue = 0; } else { ddlTemplateValue = Convert.ToInt32(Request.Form["TemplateID"].ToString()); } string location = Request.Form["ResourceLocation"].ToString(); string number = Request.Form["MobileNumber"].ToString(); string coor = Request.Form["CooridatesGoogle"].ToString(); if (location.ToString() == "" || number.ToString() == "" || ddlTemplateValue == 0) { TempData["notice"] = "Please insert all information"; DisplaySuccessMessage("Please insert all information"); return(RedirectToAction("Create")); } else { string query = "insert into tblResource (MobileNumber ,ResourceLocation,TemplateID,CompanyID,CooridatesGoogle) values ("; query += " '" + number + "' ,"; query += " '" + location + "' ,"; query += " " + ddlTemplateValue + " ,"; query += " " + c_id + ", "; query += " '" + coor + "' )"; using (SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString)) { try { SqlCommand cmd = new SqlCommand(query, conn); conn.Open(); cmd.ExecuteNonQuery(); } catch (Exception ex) { } } return(RedirectToAction("Index")); } //if (ModelState.IsValid) //{ // db.tblResources.Add(tblresource); // db.SaveChanges(); // DisplaySuccessMessage("Has append a tblResource record"); // return RedirectToAction("Index"); //} //ViewBag.TemplateID = new SelectList(db.tblTemplates, "TemplateID", "TemplateName", tblresource.TemplateID); //DisplayErrorMessage(); //return View(tblresource); }