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