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