public bool Update(Semister semister)
{
DbContextSMS db = new DbContextSMS();
db.Semisters.Attach(semister);
db.Entry(semister).State = EntityState.Modified;
return(db.SaveChanges() > 0);
}
public ActionResult DeleteConfirmed(int id)
{
Semister semister = db.SemisterDbSet.Find(id);
db.SemisterDbSet.Remove(semister);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "SemisterId,SemisterName")] Semister semister)
{
if (ModelState.IsValid)
{
db.Entry(semister).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(semister));
}
public ActionResult Create([Bind(Include = "SemisterId,SemisterName")] Semister semister)
{
if (ModelState.IsValid)
{
db.SemisterDbSet.Add(semister);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(semister));
}
public ActionResult Add(SemisterVM semisterVM)
{
Semister semister = Mapper.Map <Semister>(semisterVM);
if (_semisterManager.Add(semister))
{
TempData["saved"] = "Saved Successfully!";
return(RedirectToAction("Add"));
}
return(View());
}
public ActionResult Update(SemisterVM semisterVM)
{
Semister semister = Mapper.Map <Semister>(semisterVM);
if (_semisterManager.Update(semister))
{
TempData["updated"] = "Updated successfully!";
return(RedirectToAction("Add"));
}
TempData["failed"] = "Failed to update";
return(View());
}
// GET: /Semister/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Semister semister = db.SemisterDbSet.Find(id);
if (semister == null)
{
return(HttpNotFound());
}
return(View(semister));
}
public List <Semister> GetAllSemister()
{
Query = "select * from Semister_tb";
Command = new SqlCommand(Query, Connection);
Connection.Open();
SqlDataReader reader = Command.ExecuteReader();
List <Semister> semisters = new List <Semister>();
while (reader.Read())
{
Semister semister = new Semister();
semister.Name = reader["Semister"].ToString();
semisters.Add(semister);
}
Connection.Close();
return(semisters);
}
public List <Semister> GetSemister()
{
SqlConnection con = new SqlConnection(ConnectinString);
con.Open();
string query = "select * from Semister";
SqlCommand cmd = new SqlCommand(query, con);
SqlDataReader reader = cmd.ExecuteReader();
List <Semister> semisters = new List <Semister>();
while (reader.Read())
{
Semister semister = new Semister();
semister.Name = reader["Name"].ToString();
semister.Id = Convert.ToInt32(reader["Id"].ToString());
semisters.Add(semister);
}
reader.Close();
con.Close();
return(semisters);
}
public bool Update(Semister semister)
{
return(_semisterGetway.Update(semister));
}
public bool Add(Semister semister)
{
return(_semisterGetway.Add(semister));
}
public bool Add(Semister semister)
{
_dbContext.Semisters.Add(semister);
return(_dbContext.SaveChanges() > 0);
}
