public async Task <IActionResult> ViewProject([Bind("Tasks,Phase,FromDate,EndDate,Usage")] Project_Phase Project_Phase) { if (ModelState.IsValid) { _context.Add(Project_Phase); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(Project_Phase)); }
///// <Database>///// public static List <Project_Phase> TablesColumnsDisplay() { List <Project_Phase> PP = new List <Project_Phase>(); string connection = "Data Source=(localdb)\\mssqllocaldb;Initial Catalog=ICONEXTContext-1;Integrated Security=True"; using (SqlConnection sqlconn = new SqlConnection(connection)) { using (SqlCommand sqlcomm = new SqlCommand("select project.Name, project.Partner, project.Customer,project.StartDate, TaskProject.Tasks, PhaseProject.Phase, PhaseProject.FromDate, PhaseProject.EndDate, PhaseProject.Usage from project full join TaskProject on project.ProjID=TaskProject.ProjID full join PhaseProject on TaskProject.TID=PhaseProject.TID ")) { using (SqlDataAdapter SDA = new SqlDataAdapter()) { sqlcomm.Connection = sqlconn; sqlconn.Open(); SDA.SelectCommand = sqlcomm; SqlDataReader SDR = sqlcomm.ExecuteReader(); while (SDR.Read()) { Project_Phase PPOBJ = new Project_Phase(); PPOBJ.Name = SDR["Name"].ToString(); PPOBJ.Tasks = SDR["Tasks"].ToString(); PPOBJ.Partner = SDR["Partner"].ToString(); PPOBJ.Customer = SDR["Customer"].ToString(); PPOBJ.StartDate = SDR["StartDate"].ToString(); PPOBJ.Phase = SDR["Phase"].ToString(); PPOBJ.FromDate = SDR["FromDate"].ToString(); PPOBJ.EndDate = SDR["EndDate"].ToString(); PPOBJ.Usage = SDR["Usage"].ToString(); PP.Add(PPOBJ); } } return(PP); } } }