public ActionResult DeleteConfirmed(int id)
{
tblConnection_Data tblConnection_Data = db.tblConnection_Data.Find(id);
db.tblConnection_Data.Remove(tblConnection_Data);
db.SaveChanges();
return(RedirectToAction("Index"));
}
// GET: Connections/Details/6
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tblConnection_Data tblConnection_Data = db.tblConnection_Data.Find(id);
if (tblConnection_Data == null)
{
return(HttpNotFound());
}
return(View(tblConnection_Data));
}
public ActionResult Edit([Bind(Include = "Connection_ID,Customer,Generated_by,Generated_Date,Pass_Code,Database_Server,Database_User,Database_Password,Database_Name")] tblConnection_Data tblConnection_Data)
{
tblConnection_Data.Generated_by = (int)Session["UserID"];
tblConnection_Data.Generated_Date = DateTime.UtcNow.AddHours(3);
if (ModelState.IsValid)
{
db.Entry(tblConnection_Data).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Generated_by = new SelectList(db.tblUsers, "UserID", "FullName", tblConnection_Data.Generated_by);
return(View(tblConnection_Data));
}
// GET: Connections/Edit/6
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tblConnection_Data tblConnection_Data = db.tblConnection_Data.Find(id);
if (tblConnection_Data == null)
{
return(HttpNotFound());
}
ViewBag.Generated_by = new SelectList(db.tblUsers, "UserID", "FullName", tblConnection_Data.Generated_by);
return(View(tblConnection_Data));
}
public ActionResult Create([Bind(Include = "Connection_ID,Customer,Generated_by,Generated_Date,Pass_Code,Database_Server,Database_User,Database_Password,Database_Name")] tblConnection_Data tblConnection_Data, int expire)
{
DateTime d = DateTime.UtcNow.AddHours(3);
tblConnection_Data.Expire_Date = d.AddDays(expire);
tblConnection_Data.Generated_by = (int)Session["UserID"];
tblConnection_Data.Generated_Date = DateTime.UtcNow.AddHours(3);
if (ModelState.IsValid)
{
db.tblConnection_Data.Add(tblConnection_Data);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Generated_by = new SelectList(db.tblUsers, "UserID", "FullName", tblConnection_Data.Generated_by);
return(View(tblConnection_Data));
}
