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