public ActionResult GetVTListForDoc(FormCollection fc)
{
VTDetails model = new VTDetails();
VTListDS source = new VTListDS();
DataSet ds = new DataSet();
List <VTDetails> dataList = new List <VTDetails>();
ds = source.GetEnrolledVTList();
//dataList = (from dr in ds.Tables[0].AsEnumerable()
// where dr.Field<string>("VTCode") == fc["VTCode"]
// select dr);
model.ListEnrolled = dataList;
return(View(model));
}
//public List<VTDetails> GetEnrolledVTList(int unitcode)
//{
// List<VTDetails> datalist = new List<VTDetails>();
// DataTable dt = new DataTable();
// string str = "select VTCode from xys"; // Enter the command string
// dt = dc.getQueryViaDataTable(str);
// datalist = (from DataRow row in dt.Rows
// select new VTDetails
// {
// VTCode = row["VTCode"].ToString(),
// VTName = row["VTName"].ToString(),
// InstituteId = row["InstituteId"].ToString(),
// BranchId = row["BranchId"].ToString(),
// CourseId = row["CourseId"].ToString(),
// VTStartDate = row["VTStartDate"].ToString(),
// VTEndDate = row["VTEndDate"].ToString()
// }).ToList();
// return datalist;
//}
public DataSet GetEnrolledVTList()
{
VTDetails model = new VTDetails();
DataSet ds = new DataSet();
DataTable dt = new DataTable();
string str = "";
try
{
str = " "; //Select command for quering the list of institutes
//Production
//dt = dc.getQueryViaDataTable(str);
//Testing
dt.Clear();
dt.Columns.Add("VTCode");
dt.Columns.Add("VTName");
dt.Columns.Add("InstituteName");
dt.Columns.Add("BranchName");
dt.Columns.Add("CourseName");
dt.Columns.Add("VTStartDate");
dt.Columns.Add("VTEndDate");
object[] e = { "01235", "Anil", "Delhi College", "Computer Science", "Bachlors in Technology", "25-Feb-2019", "02-March-2019" };
dt.Rows.Add(e);
object[] e1 = { "01232", "Ankush", "Birla Institute", "Electrical", "Bachlors in Technology", "25-Feb-2019", "02-March-2019" };
dt.Rows.Add(e1);
ds.Tables.Add(dt);
}
catch (Exception Ex)
{
}
return(ds);
}
public ActionResult Index()
{
if (Session["PERSONAL_NO"] != null)
{
VTDetails model = new VTDetails();
VTListDS source = new VTListDS();
DataSet ds = new DataSet();
List <VTDetails> dataListActive = new List <VTDetails>();
List <VTDetails> dataListEnrolled = new List <VTDetails>();
ds = source.GetActiveEnrolledVTList();
if (ds.Tables.Count > 0)
{
int max = 0;
if (ds.Tables[0].Rows.Count > ds.Tables[1].Rows.Count)
{
max = ds.Tables[0].Rows.Count;
}
else if (ds.Tables[1].Rows.Count > ds.Tables[0].Rows.Count)
{
max = ds.Tables[1].Rows.Count;
}
else if (ds.Tables[1].Rows.Count == ds.Tables[0].Rows.Count)
{
max = ds.Tables[1].Rows.Count;
}
}
foreach (DataRow dr in ds.Tables[0].Rows)
{
VTDetails vt1 = new VTDetails();
vt1.VTCode = dr["VTCode"].ToString();
vt1.VTName = dr["VTName"].ToString();
vt1.InstituteName = dr["InstituteName"].ToString();
vt1.CourseName = dr["CourseName"].ToString();
vt1.BranchName = dr["BranchName"].ToString();
vt1.VTStartDate = dr["VTStartDate"].ToString();
vt1.VTEndDate = dr["VTEndDate"].ToString();
dataListActive.Add(vt1);
}
foreach (DataRow dr in ds.Tables[1].Rows)
{
VTDetails vt1 = new VTDetails();
vt1.VTCode = dr["VTCode"].ToString();
vt1.VTName = dr["VTName"].ToString();
vt1.InstituteName = dr["InstituteName"].ToString();
vt1.CourseName = dr["CourseName"].ToString();
vt1.BranchName = dr["BranchName"].ToString();
vt1.VTStartDate = dr["VTStartDate"].ToString();
vt1.VTEndDate = dr["VTEndDate"].ToString();
dataListEnrolled.Add(vt1);
}
model.ListActive = dataListActive;
model.ListEnrolled = dataListEnrolled;
return(View(model));
}
else
{
return(RedirectToAction("Index", "Login", new { area = "" }));
}
}
public DataSet GetActiveEnrolledVTList()
{
VTDetails model = new VTDetails();
DataSet ds = new DataSet();
DataTable ActiveDT = new DataTable();
DataTable EnrolledDT = new DataTable();
string str = "";
try
{
str = "select only the active VT"; // update the query
// Production
//ActiveDT = dc.getQueryViaDataTable(str);
// Testing
ActiveDT.Clear();
ActiveDT.Columns.Add("VTCode");
ActiveDT.Columns.Add("VTName");
ActiveDT.Columns.Add("InstituteName");
ActiveDT.Columns.Add("BranchName");
ActiveDT.Columns.Add("CourseName");
ActiveDT.Columns.Add("VTStartDate");
ActiveDT.Columns.Add("VTEndDate");
object[] a = { "01235", "Ramesh", "Vivekananda College", "Computer Science", "Bachlors in Technology", "25-Feb-2019", "25-March-2019" };
ActiveDT.Rows.Add(a);
object[] a1 = { "01232", "Rajveer", "Vivekananda Institute", "Electrical", "Bachlors in Technology", "25-Feb-2019", "25-March-2019" };
ActiveDT.Rows.Add(a1);
ds.Tables.Add(ActiveDT);
str = "";
str = "Selecting the list of just the enolled VT"; //Update the query
//Production
//EnrolledDT = dc.getQueryViaDataTable(str);
// Testing
EnrolledDT.Clear();
EnrolledDT.Columns.Add("VTCode");
EnrolledDT.Columns.Add("VTName");
EnrolledDT.Columns.Add("InstituteName");
EnrolledDT.Columns.Add("BranchName");
EnrolledDT.Columns.Add("CourseName");
EnrolledDT.Columns.Add("VTStartDate");
EnrolledDT.Columns.Add("VTEndDate");
object[] e = { "01235", "Anil", "Delhi College", "Computer Science", "Bachlors in Technology", "25-Feb-2019", "02-March-2019" };
EnrolledDT.Rows.Add(e);
object[] e1 = { "01232", "Ankush", "Birla Institute", "Electrical", "Bachlors in Technology", "25-Feb-2019", "02-March-2019" };
EnrolledDT.Rows.Add(e1);
ds.Tables.Add(EnrolledDT);
}
catch (Exception ex)
{
}
return(ds);
}
