public ActionResult Index(int ID)
{
ArticleModel model = new ArticleModel();
try
{
PostDataModel article = dbConnect.GetArticleByID(ID);
if (article != null)
{
model.Post = article;
model.Scrums = Uti.CreateScrums(Url, article);
model.RelatePosts = dbConnect.GetRelatePost(article);
}
else
{
// Error
return(RedirectToAction("Index", "Error", new { action = "Index", controller = "Article", errorMessage = "Post isn't existed" }));
}
return(View(model));
}
catch (Exception ex)
{
return(RedirectToAction("Index", "Error", new { action = "Index", controller = "Article", errorMessage = ex.Message }));
}
}
private void LoadStudentData(int id)
{
DataTable dt = Uti.GetIndividualStudent(id);
for (int i = 0; i < dt.Rows.Count; i++)
{
txtFirstName.Text = dt.Rows[i]["firstname"].ToString();
txtLastName.Text = dt.Rows[i]["lastname"].ToString();
txtStudentID.Text = dt.Rows[i]["studentid"].ToString();
txtEmail.Text = dt.Rows[i]["email"].ToString();
txtGPA.Text = Convert.ToDouble(dt.Rows[i]["gpa"]).ToString();
}
}
private void Export()
{
string path = "d";
//string path = GetSavePath();
if (path != "")
{
if (chkAllRecords.Checked)
{
LoadReport(ConvertToExcel.GetReportData(Uti.GetAllStudents(), path));
}
else
{
LoadReport(ConvertToExcel.GetReportData(Uti.GetIndividualStudent(PassData.studentvalue), path));
}
}
}
public void LoadStudentsDDL()
{
DataTable finalDt = new DataTable();
DataColumn dc = finalDt.Columns.Add("id", typeof(int));
dc.Unique = true;
finalDt.Columns.Add("FullName", typeof(string));
DataTable dt = Uti.GetAllStudents();
for (int i = 0; i < dt.Rows.Count; i++)
{
DataRow dr = finalDt.NewRow();
dr["FullName"] = dt.Rows[i]["firstname"].ToString() + " " + dt.Rows[i]["lastname"].ToString() + " - " + dt.Rows[i]["studentid"].ToString();
dr["id"] = dt.Rows[i]["id"];
finalDt.Rows.Add(dr);
}
ddlStudents.InvokeEx(x => x.DisplayMember = "FullName");
ddlStudents.InvokeEx(x => x.ValueMember = "id");
ddlStudents.InvokeEx(x => x.DataSource = finalDt);
}
