public ActionResult MasterDropTable(DSRCManagementSystem.Models.MasterList Name)
{
if (Name._drpMasterName == null)
{
DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1();
var selectedTable = Name._drpMasterName;
Session["selectmasterTableName"] = selectedTable;
Session["masterTableName"] = Name._drpMasterName;
var selectMaster = db.Sp_Master(selectedTable).ToList();
var ColumnName = db.Sp_GetColumn(selectedTable).ToList();
var columndatatype = db.Sp_MasterDataType(selectedTable).ToList();
Name.ColumnNames = new List <Addmasterjoin>();
Name.ColumnDataTypes = new List <Addmasterjoin>();
ViewBag.columndatatype = columndatatype;
ViewBag.ColumnName = ColumnName;
for (int i = 0; i <= columndatatype.Count - 1; i++)
{
cs.ColumnDataType.Add(columndatatype[i]);
Name.ColumnDataTypes.Add(new Addmasterjoin(columndatatype[i]));
}
for (int s = 0; s <= ColumnName.Count - 1; s++)
{
cs.ColumnName0.Add(ColumnName[s]);
Name.ColumnNames.Add(new Addmasterjoin(ColumnName[s]));
}
Name._masterjoin = new List <masterjoin>();
foreach (var s in selectMaster)
{
var rs = s.Split('^').ToArray();
cs.id.Add(rs[0]);
cs.value.Add(rs[1]);
Name._masterjoin.Add(new masterjoin(rs[0].ToString(), rs[1].ToString()));
}
DataTable dt = new DataTable();
AllMail.MasterList(dt);
List <DSRCManagementSystem.Models.MasterList.masterdroplist> objmodel = new List <Models.MasterList.masterdroplist>();
for (int i = 0; i < dt.Rows.Count; i++)
{
DSRCManagementSystem.Models.MasterList.masterdroplist obj = new DSRCManagementSystem.Models.MasterList.masterdroplist();
obj.Name = dt.Rows[i]["name"].ToString();
objmodel.Add(obj);
}
SelectList list = new SelectList(objmodel, "name", "name");
ViewBag.MasterTable = list;
TempData["message"] = "Added";
// return View("<script language='javascript' type='text/javascript'>alert('Select MasterTableName ');</script>");
// return Content("<script language='javascript' type='text/javascript'>alert('Select MasterTableName ');</script>");
return(View());
}
else
{
DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1();
var selectedTable = Name._drpMasterName;
Session["selectmasterTableName"] = selectedTable;
Session["masterTableName"] = Name._drpMasterName;
var selectMaster = db.Sp_Master(selectedTable).ToList();
var ColumnName = db.Sp_GetColumn(selectedTable).ToList();
var columndatatype = db.Sp_MasterDataType(selectedTable).ToList();
Name.ColumnNames = new List <Addmasterjoin>();
Name.ColumnDataTypes = new List <Addmasterjoin>();
ViewBag.columndatatype = columndatatype;
ViewBag.ColumnName = ColumnName;
for (int i = 0; i <= columndatatype.Count - 1; i++)
{
cs.ColumnDataType.Add(columndatatype[i]);
Name.ColumnDataTypes.Add(new Addmasterjoin(columndatatype[i]));
}
for (int s = 0; s <= ColumnName.Count - 1; s++)
{
cs.ColumnName0.Add(ColumnName[s]);
Name.ColumnNames.Add(new Addmasterjoin(ColumnName[s]));
}
Name._masterjoin = new List <masterjoin>();
foreach (var s in selectMaster)
{
var rs = s.Split('^').ToArray();
cs.id.Add(rs[0]);
cs.value.Add(rs[1]);
Name._masterjoin.Add(new masterjoin(rs[0].ToString(), rs[1].ToString()));
}
DataTable dt = new DataTable();
AllMail.MasterList(dt);
List <DSRCManagementSystem.Models.MasterList.masterdroplist> objmodel = new List <Models.MasterList.masterdroplist>();
for (int i = 0; i < dt.Rows.Count; i++)
{
DSRCManagementSystem.Models.MasterList.masterdroplist obj = new DSRCManagementSystem.Models.MasterList.masterdroplist();
obj.Name = dt.Rows[i]["name"].ToString();
objmodel.Add(obj);
}
SelectList list = new SelectList(objmodel, "name", "name");
ViewBag.MasterTable = list;
return(View(Name));
}
}