public ActionResult FacultyRegistration(Models.Faculty faculty) { if (ModelState.IsValid) { using (var db = new ACCTOnlineLibraryEntities1()) { var facUser = db.Faculties.Create(); facUser.Name = faculty.Name; facUser.Designation = faculty.Designation; facUser.Department = faculty.Department; facUser.Email = faculty.Email; facUser.Password = faculty.Password; facUser.Phone = faculty.Phone; facUser.Address = faculty.Address; db.Faculties.Add(facUser); db.SaveChanges(); return(RedirectToAction("Success", "Account")); } } else { ModelState.AddModelError("", "Error Field "); } return(View()); }
public ActionResult Edit(Models.Faculty f1) { int i = objdalfacultyservices.UpdateFaculty(f1); if (i == 1) { Response.Write("Record Updated"); } return(RedirectToAction("List")); }
public async Task <ActionResult> Faculties([FromBody] Models.Faculty faculty) { if (faculty == null) { return(BadRequest()); } await this.db.insertFaculty(faculty); return(Ok()); }
public int UpdateFaculty(Models.Faculty objfacultyservicesmodel) { string connectionstring = ConfigurationManager.ConnectionStrings["dbconnection"].ConnectionString; using (var conn = new MySqlConnection(connectionstring)) { string sqlQuery = "UPDATE faculty SET Fname = '" + objfacultyservicesmodel.Fname + "',Subject='" + objfacultyservicesmodel.Subject + "',Subcode='" + objfacultyservicesmodel.Subcode + "',Email='" + objfacultyservicesmodel.Email + "',Address='" + objfacultyservicesmodel.Address + "',Phoneno='" + objfacultyservicesmodel.Phoneno + "' where Fid='" + objfacultyservicesmodel.Fid + "'"; int i = conn.Execute(sqlQuery); return(i); } }
public Models.Faculty GetDetails(int id) { Models.Faculty objfacultyservicemodel = new Models.Faculty(); Models.Faculty faculties = new Models.Faculty(); string connectionstring = ConfigurationManager.ConnectionStrings["dbconnection"].ConnectionString; using (var conn = new MySqlConnection(connectionstring)) { objfacultyservicemodel = conn.Query <Models.Faculty>("Select * from faculty where Fid='" + id + "'").SingleOrDefault(); } return(objfacultyservicemodel); }
public Models.Faculty Search(int id) { string connectionstring = ConfigurationManager.ConnectionStrings["dbconnection"].ConnectionString; Models.Faculty objfacultyservicemodel = new Models.Faculty(); using (var conn = new MySqlConnection(connectionstring)) { string sqlQuery = "select * from faculty where Fid='" + id + "'"; objfacultyservicemodel = conn.Query <Models.Faculty>(sqlQuery).SingleOrDefault(); } return(objfacultyservicemodel); }
public async Task <ActionResult> Faculties([FromBody] Models.Faculty faculty, [FromQuery] int id) { if (faculty == null || id == null) { return(BadRequest()); } await this.db.updateFaculty(id, faculty); return(Ok()); }
public int AddFaculty(Models.Faculty objfacultyservicemodel) { string connectionstring = ConfigurationManager.ConnectionStrings["dbconnection"].ConnectionString; using (var conn = new MySqlConnection(connectionstring)) { string sqlQuery = "Insert Into faculty(Fname,Subject,Subcode,Email,Address,Phoneno) Values('" + objfacultyservicemodel.Fname + "','" + objfacultyservicemodel.Subject + "','" + objfacultyservicemodel.Subcode + "','" + objfacultyservicemodel.Email + "','" + objfacultyservicemodel.Address + "','" + objfacultyservicemodel.Phoneno + "')"; int i = conn.Execute(sqlQuery); return(i); } }
public int AddFaculty(Models.Faculty objfacultymodel) { connectionString = @"SERVER=" + server + ";" + "DATABASE=" + database + ";" + "UID=" + uid + ";" + "PASSWORD="******";"; MySqlConnection con = new MySqlConnection(connectionString); con.Open(); string query = "insert into faculty values('" + objfacultymodel.Fid + "','" + objfacultymodel.Fname + "','" + objfacultymodel.Subject + "' )"; MySqlCommand cmd = new MySqlCommand(query, con); int i = cmd.ExecuteNonQuery(); return(i); }
public ActionResult Create(Models.Faculty s) { if (ModelState.IsValid) { int i = objdalfacultyservices.AddFaculty(s); if (i == 1) { return(RedirectToAction("List")); } } else { return(Json(ModelState.Values, JsonRequestBehavior.AllowGet)); } return(RedirectToAction("List")); }
public int Edit(Models.Faculty objfacultymodel) { string server = "localhost"; string database = "database5"; string uid = "root"; string password = "******"; string connectionString; connectionString = "SERVER=" + server + ";" + "DATABASE=" + database + ";" + "UID=" + uid + ";" + "PASSWORD="******";"; MySqlConnection con = new MySqlConnection(connectionString); con.Open(); string query = "UPDATE faculty SET Fname = '" + objfacultymodel.Fname + "',Subject='" + objfacultymodel.Subject + "' where Fid='" + objfacultymodel.Fid + "'"; MySqlCommand cmd = new MySqlCommand(query, con); int i = cmd.ExecuteNonQuery(); con.Close(); return(i); }
public List <Models.Faculty> Display() { connectionString = @"SERVER=" + server + ";" + "DATABASE=" + database + ";" + "UID=" + uid + ";" + "PASSWORD="******";"; MySqlConnection con = new MySqlConnection(connectionString); con.Open(); string query = "select * from faculty"; MySqlCommand cmd = new MySqlCommand(query, con); List <Models.Faculty> result = new List <Models.Faculty>(); MySqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { Models.Faculty objfacultymodel = new Models.Faculty(); objfacultymodel.Fid = Convert.ToInt32(dr["Fid"]); objfacultymodel.Fname = dr["Fname"].ToString(); objfacultymodel.Subject = dr["Subject"].ToString(); result.Add(objfacultymodel); } con.Close(); return(result); }
public Models.Faculty Search(int id) { connectionString = @"SERVER=" + server + ";" + "DATABASE=" + database + ";" + "UID=" + uid + ";" + "PASSWORD="******";"; MySqlConnection con = new MySqlConnection(connectionString); con.Open(); string query = "select * from faculty where Fid='" + id + "'"; MySqlCommand cmd = new MySqlCommand(query, con); MySqlDataReader dr = cmd.ExecuteReader(); Models.Faculty objfacultymodel = new Models.Faculty(); if (dr.HasRows) { if (dr.Read()) { objfacultymodel.Fid = Convert.ToInt32(dr[0]); objfacultymodel.Fname = dr[1].ToString(); objfacultymodel.Subject = dr[2].ToString(); } } return(objfacultymodel); }
public ActionResult Details(int id) { Models.Faculty l = objdalfacultyservices.GetDetails(id); return(View(l)); }
public async Task updateFaculty(int id, Models.Faculty update) { this.Database.ExecuteSqlCommand( "update faculty set name={0}, brief_name={1} where id={2}", update.name, update.briefName, id); }
public async Task insertFaculty(Models.Faculty faculty) { this.Database.ExecuteSqlCommand( "insert into faculty (name, brief_name) values ({0}, {1})", faculty.name, faculty.briefName); }
public ActionResult Edit(int id) { Models.Faculty s = objdalfacultyservices.Search(id); return(View(s)); }