public StudentViewModel() { Name = ""; Study = ""; Attributes = ""; StudyAttributes = ""; SeeksGroup = true; Neighbors = ""; AllNodes = StudentGraph.GetAll(); }
public ActionResult Create(StudentViewModel studentViewModel) { if (StudentGraph.Students.Contains(studentViewModel.ToStudent().Name)) { ModelState.AddModelError("Name", "Det angivne navn findes allerede."); return(View()); } StudentGraph.Add(studentViewModel.ToStudentNode()); return(RedirectToAction("Index")); }
public ActionResult Details(string name) { return(View(StudentGraph.Get(name))); }
// GET: Student public ActionResult Index() { return(View(StudentGraph.GetAll())); }
public StudentGraph GetStudentGraph(int cId) { try { using (SqlConnection con = new SqlConnection(strcon)) { string strcmd = "select c_first_name,c_last_name,c_middle_Name,c_age_years,c_username,c_email_id from tbl_candidate_master where c_id = " + cId; SqlDataAdapter sda = new SqlDataAdapter(strcmd, con); con.Open(); DataSet ds = new DataSet(); sda.Fill(ds); StudentGraph SG = new StudentGraph(); SG.name = ds.Tables[0].Rows[0][0].ToString() + " " + ds.Tables[0].Rows[0][2].ToString() + " " + ds.Tables[0].Rows[0][1].ToString(); SG.UserName = ds.Tables[0].Rows[0][4].ToString(); SG.CandEmailID = ds.Tables[0].Rows[0][5].ToString(); SG.CandAge = Convert.ToInt32(ds.Tables[0].Rows[0][3]); int id = GD.get_values_maintest(cId); BlueM = GD.BLUEM; BlueL = GD.BLUEL; RedM = GD.REDM; BlackM = GD.BLACKM; RedL = GD.REDL; BlackL = GD.BLACKL; GreenM = GD.GREENM; GreenL = GD.GREENL; Hole = GD.HOLE; DiffB = BlueM - BlueL; DiffR = RedM - RedL; DiffBl = BlackM - BlackL; DiffG = GreenM - GreenL; SG.lblBM = Convert.ToString(BlueM); SG.lblBL = Convert.ToString(BlueL); SG.lblRM = Convert.ToString(RedM); SG.lblRL = Convert.ToString(RedL); SG.lblBlM = Convert.ToString(BlackM); SG.lblBlL = Convert.ToString(BlackL); SG.lblGM = Convert.ToString(GreenM); SG.lblGL = Convert.ToString(GreenL); SG.lblDiffB = Convert.ToString(DiffB); SG.lblDiffR = Convert.ToString(DiffR); SG.lblDiffBl = Convert.ToString(DiffBl); SG.lblDiffG = Convert.ToString(DiffG); SG.lblTotal = Convert.ToString(Hole); // CreateChart1(); /////////////////// het function in side/// GD.set_values_maintest(); BlueM = GD.DM; RedM = GD.IM; BlackM = GD.SM; GreenM = GD.CM; //RAPD GRAPH 1 information SG.R1 = BlueM; SG.A1 = RedM; SG.P1 = BlackM; SG.D1 = GreenM; GD.set_values_maintest(); BlueL = GD.DL; RedL = GD.IL; BlackL = GD.SL; GreenL = GD.CL; //RAPD GRAPH 2 information SG.R2 = BlueL; SG.A2 = RedL; SG.P2 = BlackL; SG.D2 = GreenL; GD.set_values_maintest(); DiffB = GD.DD; DiffR = GD.ID; DiffBl = GD.SD; DiffG = GD.CD; //RAPD GRAPH 3 information SG.R3 = DiffB; SG.A3 = DiffR; SG.P3 = DiffBl; SG.D3 = DiffG; String StrSql = ""; StrSql = "SELECT * FROM tbl_candidate_RAPD_Score WHERE c_id='" + cId + "'"; SqlCommand cmd1 = new SqlCommand(StrSql, con); SqlDataReader sdr = cmd1.ExecuteReader(); if (sdr.HasRows) { sdr.Close(); StrSql = "INSERT INTO tbl_candidate_RAPD_Score VALUES ( " + cId + "," + DiffB + ", " + DiffR + "," + DiffBl + "," + DiffG + ")"; SqlCommand cmd2 = new SqlCommand(StrSql, con); int i = cmd2.ExecuteNonQuery(); //cccc++; } else { sdr.Close(); StrSql = "update tbl_candidate_RAPD_Score set Rscore=" + DiffB + ", Ascore=" + DiffR + ",Pscore=" + DiffBl + ",Dscore=" + DiffG + " where c_id=" + cId; SqlCommand cmd3 = new SqlCommand(StrSql, con); int i = cmd3.ExecuteNonQuery(); } return(SG); } } catch (Exception ex) { Log.Error(ex); return(null); } }
protected void Application_Start() { AreaRegistration.RegisterAllAreas(); RouteConfig.RegisterRoutes(RouteTable.Routes); StudentGraph.Load(); }