public string LoadLogStudentsWithIdFromDb(string fName, string lName, int Id)
{
studentCollect = new List <StudentItem>();
studentCollect.Clear();
using (var db = Connection.CreateConnection())
{
db.Open();
var sql = "dbo.spGetStudentLoginWithId";
var cmd = new SqlCommand(sql, db);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@FName", fName));
cmd.Parameters.Add(new SqlParameter("@LName", lName));
cmd.Parameters.Add(new SqlParameter("@Id", Id));
var reader = cmd.ExecuteReader();
if (!reader.HasRows)
{
return("Name Not Found");
}
while (reader.Read())
{
var item = new StudentItem();
item.Std_Id = Int32.Parse(reader["Std_Id"].ToString());
item.Std_FName = reader["Std_FName"].ToString();
item.Std_MName = reader["Std_MName"].ToString();
item.Std_LName = reader["Std_LName"].ToString();
item.Std_CourseCode = reader["Std_CourseCode"].ToString();
item.Std_CourseTitle = reader["Std_CourseTitle"].ToString();
item.Std_Section = reader["Std_Section"].ToString();
item.Std_Year = reader["Std_Year"].ToString();
studentCollect.Add(item);
}
db.Close();
return("Name Found");
}
}
public void UpdateStudent(StudentItem stdItem)
{
using (var db = Connection.CreateConnection())
{
db.Open();
var sql = "dbo.spUpdateStudent";
var cmd = new SqlCommand(sql, db);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@FName", stdItem.Std_FName));
cmd.Parameters.Add(new SqlParameter("@LName", stdItem.Std_LName));
cmd.Parameters.Add(new SqlParameter("@MName", stdItem.Std_MName));
cmd.Parameters.Add(new SqlParameter("@CCode", stdItem.Std_CourseCode));
cmd.Parameters.Add(new SqlParameter("@CTitle", stdItem.Std_CourseTitle));
cmd.Parameters.Add(new SqlParameter("@Year", stdItem.Std_Year));
cmd.Parameters.Add(new SqlParameter("@Section", stdItem.Std_Section));
cmd.Parameters.Add(new SqlParameter("@StdId", stdItem.Std_Id));
cmd.ExecuteNonQuery();
db.Close();
}
}
public void SaveStudent(StudentItem stdItem)
{
using (var db = Connection.CreateConnection())
{
db.Open();
var sql = "dbo.spInsertStudent";
var cmd = new SqlCommand(sql, db);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@FName", stdItem.Std_FName));
cmd.Parameters.Add(new SqlParameter("@LName", stdItem.Std_LName));
cmd.Parameters.Add(new SqlParameter("@MName", stdItem.Std_MName));
cmd.Parameters.Add(new SqlParameter("@CCode", stdItem.Std_CourseCode));
cmd.Parameters.Add(new SqlParameter("@CTitle", stdItem.Std_CourseTitle));
cmd.Parameters.Add(new SqlParameter("@Year", stdItem.Std_Year));
cmd.Parameters.Add(new SqlParameter("@Section", stdItem.Std_Section));
cmd.Parameters.Add(new SqlParameter("@Deleted", stdItem.Std_Deleted));
myReturnedID = int.Parse(cmd.ExecuteScalar().ToString());
db.Close();
}
}
public void LoadStudentsFromDb()
{
studentCollect = new List <StudentItem>();
studentCollect.Clear();
using (var db = Connection.CreateConnection())
{
db.Open();
var sql = "dbo.spLoadStudents";
var cmd = new SqlCommand(sql, db);
var reader = cmd.ExecuteReader();
if (!reader.HasRows)
{
return;
}
while (reader.Read())
{
var item = new StudentItem();
item.Std_Id = Int32.Parse(reader["Std_Id"].ToString());
item.Std_FName = reader["Std_FName"].ToString();
item.Std_MName = reader["Std_MName"].ToString();
item.Std_LName = reader["Std_LName"].ToString();
item.Std_CourseCode = reader["Std_CourseCode"].ToString();
item.Std_CourseTitle = reader["Std_CourseTitle"].ToString();
item.Std_Section = reader["Std_Section"].ToString();
item.Std_Year = reader["Std_Year"].ToString();
studentCollect.Add(item);
}
db.Close();
}
}
public void SearchStudent(string search)
{
using (var db = Connection.CreateConnection())
{
db.Open();
var sql = "dbo.spLoadSearchedStudents";
var cmd = new SqlCommand(sql, db);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@Search", string.Format("%{0}%", search)));
var reader = cmd.ExecuteReader();
if (!reader.HasRows)
{
return;
}
while (reader.Read())
{
var item = new StudentItem();
item.Std_Id = Int32.Parse(reader["Std_Id"].ToString());
item.Std_FName = reader["Std_FName"].ToString();
item.Std_LName = reader["Std_LName"].ToString();
item.Std_MName = reader["Std_MName"].ToString();
item.Std_CourseCode = reader["Std_CourseCode"].ToString();
item.Std_CourseTitle = reader["Std_CourseTitle"].ToString();
item.Std_Year = reader["Std_Year"].ToString();
item.Std_Section = reader["Std_Section"].ToString();
studentCollect.Add(item);
}
db.Close();
}
}
