public ActionResult Edit(SubjectAssign subjectAssign)
{
try
{
if (ModelState.IsValid)
{
try
{
db.Entry(subjectAssign).State = EntityState.Modified;
db.SaveChanges();
this.ShowMessage(MessageType.Success, "Record is updated.", false, true);
return(Json(true, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
this.ShowMessage(MessageType.Error, AddModelErrors(ex.Message), false, true);
return(Json(false));
}
}
ViewBag.Subject_ID = new SelectList(db.Subjects, "Subject_ID", "SubjectName", subjectAssign.Subject_ID);
return(Json(subjectAssign, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
this.ShowMessage(MessageType.Error, "Error while updating record.");
return(Json(false));
}
}
public ActionResult Create(SubjectAssign model)
{
try
{
if (ModelState.IsValid)
{
try
{
db.SubjectAssigns.Add(model);
db.SaveChanges();
return(Json(true, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
this.ShowMessage(MessageType.Error, AddModelErrors(ex.Message), false, true);
return(Json(false));
}
}
ViewBag.Subject_ID = new SelectList(db.Subjects, "Subject_ID", "SubjectName", model.Subject_ID);
return(PartialView("_AssignSubject", model));
}
catch (Exception ex)
{
this.ShowMessage(MessageType.Error, "Error while inserting record.");
return(Json(false));
}
}
public bool InsertSubjectAssign(SubjectAssign obj = null)
{
try
{
if (con.State != ConnectionState.Open)
{
con.Open();
}
SqlCommand _command = new SqlCommand();
string query = "INSERT INTO SubjectAssign (DepartmentId,LevelId,TermId,SubjectId) VALUES('" +
obj.DepartmentId + "','" + obj.LevelId + "','" + obj.TermId + "','" + obj.SubjectId + "' ) ";
_command.CommandText = query;
_command.Connection = con;
_command.ExecuteNonQuery();
}
catch
{
return(false);
}
finally
{
if (con.State != ConnectionState.Closed)
{
con.Close();
}
}
return(true);
}
public bool UpdateSubjectAssign(SubjectAssign obj)
{
try
{
if (con.State != ConnectionState.Open)
{
con.Open();
}
SqlCommand _command = new SqlCommand();
string query = "UPDATE SubjectAssign SET DepartmentId = ' " + obj.DepartmentId + "',LevelId='" + obj.LevelId +
"',TermId='" + obj.TermId + "',SubjectId='" + obj.SubjectId + "'";
_command.CommandText = query;
_command.Connection = con;
_command.ExecuteNonQuery();
}
catch
{
return(false);
}
finally
{
if (con.State != ConnectionState.Closed)
{
con.Close();
}
}
return(true);
}
// GET: SubjectAssign/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
SubjectAssign subjectAssign = db.SubjectAssigns.Find(id);
if (subjectAssign == null)
{
return(HttpNotFound());
}
return(PartialView("_Details", subjectAssign));
}
public List <SubjectAssign> SelectSubjectAssign(SubjectAssign obj = null)
{
if (con.State != ConnectionState.Open)
{
con.Open();
}
SqlCommand _command = new SqlCommand();
string query = "SELECT * FROM SubjectAssign WHERE 1=1 ";
if (obj != null)
{
if (obj.SubjectAssignId > 0)
{
query = query + "AND SubjectAssignId=" + obj.SubjectAssignId;
}
}
_command.CommandText = query;
_command.Connection = con;
SqlDataAdapter _adapter = new SqlDataAdapter();
_adapter.SelectCommand = _command;
DataTable dt = new DataTable();
_adapter.Fill(dt);
List <SubjectAssign> sub_list = new List <SubjectAssign>();
foreach (DataRow dr in dt.Rows)
{
SubjectAssign subas = new SubjectAssign();
subas.DepartmentId = Convert.ToInt64(dr["DepartmentId"].ToString());
subas.LevelId = Convert.ToInt64(dr["LevelId"].ToString());
subas.TermId = Convert.ToInt64(dr["TermId"].ToString());
subas.SubjectId = Convert.ToInt64(dr["SubjectId"].ToString());
subas.SubjectAssignId = Convert.ToInt64(dr["SubjectAssignId"].ToString());
sub_list.Add(subas);
}
return(sub_list);
}
// GET: SubjectAssign/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
SubjectAssign subjectAssign = db.SubjectAssigns.Find(id);
if (subjectAssign == null)
{
return(HttpNotFound());
}
ViewBag.Subject_ID = new SelectList(db.Subjects, "Subject_ID", "SubjectName", subjectAssign.Subject_ID);
return(PartialView("_EditAssignSubject", subjectAssign));
}
public ActionResult AddEditStudent(StudentDto model)
{
var item = ab.StdRegistrations.FirstOrDefault(x => x.Sid == model.Sid);
if (item == null)
{
item = new StdRegistration();
ab.StdRegistrations.Add(item);
}
item.FirstName = model.FirstName;
item.LastName = model.LastName;
item.FatherName = model.FatherName;
item.StudentCnic = model.StudentCnic;
item.Address = model.Address;
item.Email = model.Email;
if (model.Password != null)
{
item.Password = model.Password;
}
ab.SaveChanges();
var temp = item.Sid;
if (model.SubjectIds.Count > 0)
{
var assignList = ab.SubjectAssigns.Where(x => x.SR_FK == model.Sid).ToList();
if (assignList.Count > 0)
{
ab.SubjectAssigns.RemoveRange(assignList);
ab.SaveChanges();
}
foreach (var item1 in model.SubjectIds)
{
SubjectAssign subjectAssign = new SubjectAssign();
subjectAssign.SR_FK = temp;
subjectAssign.SS_FK = item1;
ab.SubjectAssigns.Add(subjectAssign);
ab.SaveChanges();
}
ab.SaveChanges();
}
return(RedirectToAction("StudentRecord"));
}
public ActionResult Edit(SubjectAssign subAss)
{
return(View());
}
public ActionResult Create(SubjectAssign subAss)
{
bool IsSaved = sub_dbaccess.InsertSubjectAssign(subAss);
return(View("Index"));
}
