public ActionResult EditMaster(DSRCManagementSystem.Models.MasterList Name, string uid, string z)
{
var col = "";
DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1();
int id = Convert.ToInt16(uid);
Session["id"] = Convert.ToInt16(uid);
var TableName = Session["selectmasterTableName"];
var ColumnName = db.Sp_GetColumn(Session["selectmasterTableName"].ToString()).ToList();
var columnDatatype = db.Sp_MasterDataType(Session["selectmasterTableName"].ToString()).ToList();
Name.ColumnNames = new List <Addmasterjoin>();
Name.ColumnDataTypes = new List <Addmasterjoin>();
for (int s = 0; s <= ColumnName.Count - 1; s++)
{
cs.ColumnName0.Add(ColumnName[s]);
col = ColumnName[0];
Name.ColumnNames.Add(new Addmasterjoin(ColumnName[s]));
}
for (int i = 1; i <= columnDatatype.Count - 1; i++)
{
cs.ColumnDataType.Add(columnDatatype[i]);
Name.ColumnDataTypes.Add(new Addmasterjoin(columnDatatype[i]));
}
string EditQuery = "select * from " + TableName + " where " + col + " = " + id;
string constr = ConfigurationManager.AppSettings["connstr"];
SqlConnection objcon = new SqlConnection(constr);
objcon.Open();
SqlCommand cmd = new SqlCommand(EditQuery, objcon);
cmd.ExecuteNonQuery();
objcon.Close();
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
sda.Fill(dt);
Name.ColumnValues = new List <object>();
DataSet ds = new DataSet();
sda.Fill(ds, "dinesh");
for (int i = 0; i < columnDatatype.Count; i++)
{
foreach (DataRow dr in ds.Tables["dinesh"].Rows)
{
DSRCManagementSystem.Models.MasterList ob = new DSRCManagementSystem.Models.MasterList();
Array values = dr.ItemArray;
ob.val = values;
Name.ColumnValues.Add(ob.val.GetValue(i));
}
}
return(View(Name));
}
public ActionResult AddMaster(DSRCManagementSystem.Models.MasterList Name, string result, string z)
{
DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1();
if (Convert.ToString(Session["selectmasterTableName"]) == "--Select--" || Session["selectmasterTableName"] == null)
{
Response.Write("<script language=javascript>alert('Please Select the table Name');</script>");
return(View("MasterView"));
}
else
{
var count = db.Sp_GetColumn(Session["selectmasterTableName"].ToString()).Count();
var ColumnName = db.Sp_GetColumn(Session["selectmasterTableName"].ToString()).ToList();
var columnDatatype = db.Sp_MasterDataType(Session["selectmasterTableName"].ToString()).ToList();
ViewBag.columndatatype = columnDatatype;
ViewBag.ColumnName = ColumnName;
Name.ColumnNames = new List <Addmasterjoin>();
Name.ColumnDataTypes = new List <Addmasterjoin>();
for (int s = 0; s <= ColumnName.Count - 1; s++)
{
cs.ColumnName0.Add(ColumnName[s]);
Name.ColumnNames.Add(new Addmasterjoin(ColumnName[s]));
}
for (int i = 1; i <= columnDatatype.Count - 1; i++)
{
cs.ColumnDataType.Add(columnDatatype[i]);
Name.ColumnDataTypes.Add(new Addmasterjoin(columnDatatype[i]));
}
ViewBag.count = count - 1;
return(View(Name));
}
}
public ActionResult AddMaster(DSRCManagementSystem.Models.MasterList Name, string Column)
{
try
{
var values = "";
List <string> objuser = new List <string>();
string[] value = Column.Split(',');
for (int k = 0; k < value.Count(); k++)
{
if (value[k] != "")
{
objuser.Add(value[k]);
}
}
DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1();
var TableName = Session["selectmasterTableName"];
var ColumnName = db.Sp_GetColumn(Session["selectmasterTableName"].ToString()).ToList();
var columnDatatype = db.Sp_MasterDataType(Session["selectmasterTableName"].ToString()).ToList();
Name.ColumnNames = new List <Addmasterjoin>();
Name.ColumnDataTypes = new List <Addmasterjoin>();
for (int s = 0; s <= ColumnName.Count - 1; s++)
{
cs.ColumnName0.Add(ColumnName[s]);
Name.ColumnNames.Add(new Addmasterjoin(ColumnName[s]));
}
for (int i = 0; i < objuser.Count(); i++)
{
if (columnDatatype[i + 1] == "datetime")
{
values = values + (values == string.Empty ? values.Trim() : ",") + "" + objuser[i].ToString() + "";
}
else
{
values = values + (values == string.Empty ? values.Trim() : ",") + "'" + objuser[i].ToString() + "'";
}
}
string cmdstr = string.Format("INSERT INTO " + TableName + " VALUES ({0})", values);
string constr = ConfigurationManager.AppSettings["connstr"];
SqlConnection objcon = new SqlConnection(constr);
objcon.Open();
SqlCommand cmd = new SqlCommand(cmdstr, objcon);
cmd.ExecuteNonQuery();
objcon.Close();
return(Json(new { Result = "Success", URL = @Url.Action("AlertPopUp", "Popup") }, JsonRequestBehavior.AllowGet));
}
catch (Exception)
{
return(Json(new { Result = "Already", URL = @Url.Action("AlertPopUp", "Popup") }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult DeleteMaster(DSRCManagementSystem.Models.MasterList Name, string uid)
{
try
{
DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1();
var TableName = Session["selectmasterTableName"];
var ColumnName = db.Sp_GetColumn(Session["selectmasterTableName"].ToString()).ToList();
var columnDatatype = db.Sp_MasterDataType(Session["selectmasterTableName"].ToString()).ToList();
Name.ColumnNames = new List <Addmasterjoin>();
Name.ColumnDataTypes = new List <Addmasterjoin>();
var col = "";
for (int s = 0; s <= ColumnName.Count - 1; s++)
{
cs.ColumnName0.Add(ColumnName[s]);
col = ColumnName[0];
Name.ColumnNames.Add(new Addmasterjoin(ColumnName[s]));
}
for (int i = 1; i <= columnDatatype.Count - 1; i++)
{
cs.ColumnDataType.Add(columnDatatype[i]);
Name.ColumnDataTypes.Add(new Addmasterjoin(columnDatatype[i]));
}
string DeleteMasterTableRow = "delete from " + TableName + " where " + col + " = " + uid;
string constr = ConfigurationManager.AppSettings["connstr"];
SqlConnection objcon = new SqlConnection(constr);
objcon.Open();
SqlCommand cmd = new SqlCommand(DeleteMasterTableRow, objcon);
cmd.ExecuteNonQuery();
objcon.Close();
return(Json(new { Result = "Success", URL = @Url.Action("AlertPopUp", "Popup") }, JsonRequestBehavior.AllowGet));
}
catch (Exception)
{
return(Json(new { Result = "Already", URL = @Url.Action("AlertPopUp", "Popup") }, JsonRequestBehavior.AllowGet));
}
}
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));
}
}
public ActionResult EditMaster(DSRCManagementSystem.Models.MasterList Name, string ColumnValues)
{
try
{
DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1();
string values = string.Empty;
List <string> column = new List <string>();
List <string> objuser = new List <string>();
int ids = Convert.ToInt16(Session["id"]);
string[] value = ColumnValues.Split(',');
for (int k = 0; k < value.Count(); k++)
{
if (value[k] != "")
{
objuser.Add(value[k].Replace(",", "''"));
}
}
for (int i = 0; i < objuser.Count(); i++)
{
values = values + (values == string.Empty ? values.Trim() : ",") + "'" + objuser[i].ToString() + "'";
}
var col = "";
var TableName = Session["selectmasterTableName"];
var ColumnName = db.Sp_GetColumn(Session["selectmasterTableName"].ToString()).ToList();
for (int i = 1; i < ColumnName.Count; i++)
{
//column = column + (column == string.Empty ? column.Trim() : ",") + "'" + ColumnName[i].ToString() + "'";
column.Add(ColumnName[i]);
}
string[] cols = column.ToArray();
//string convToSingleData = String.Join(",", column.Select(x=>x.ToString()));
var columnDatatype = db.Sp_MasterDataType(Session["selectmasterTableName"].ToString()).ToList();
Name.ColumnNames = new List <Addmasterjoin>();
Name.ColumnDataTypes = new List <Addmasterjoin>();
for (int s = 0; s <= ColumnName.Count - 1; s++)
{
cs.ColumnName0.Add(ColumnName[s]);
col = ColumnName[0];
Name.ColumnNames.Add(new Addmasterjoin(ColumnName[s]));
}
for (int i = 1; i <= columnDatatype.Count - 1; i++)
{
cs.ColumnDataType.Add(columnDatatype[i]);
Name.ColumnDataTypes.Add(new Addmasterjoin(columnDatatype[i]));
}
string dd = string.Empty;
for (int j = 0; j < ColumnName.Count - 1; j++)
{
try
{
if (j != ColumnName.Count - 2)
{
dd += column[j] + " = " + objuser[j].Replace(objuser[j], " " + Convert.ToInt32(objuser[j]) + " ") + ",";
}
else if (columnDatatype[j + 1] == "datetime")
{
dd += column[j] + " = " + objuser[j].Replace(objuser[j], " " + objuser[j] + " ") + "";
}
else
{
dd += column[j] + " = " + objuser[j].Replace(objuser[j], " " + Convert.ToInt32(objuser[j]) + " ") + "";
}
}
catch (Exception)
{
if (j != ColumnName.Count - 2)
{
dd += column[j] + " = " + objuser[j].Replace(objuser[j], "' " + objuser[j] + " '") + ",";
}
else if (columnDatatype[j + 1] == "datetime")
{
dd += column[j] + " = " + objuser[j].Replace(objuser[j], " " + objuser[j] + " ") + "";
}
else
{
dd += column[j] + " = " + objuser[j].Replace(objuser[j], "' " + objuser[j] + " '") + "";
}
}
}
// string replaced = "," + dd.Replace(",", "','") + "'";
string UpdateQuery = "update " + TableName + " set " + dd + " where " + col + " = " + ids;
// string UpdateQuery = "update " + TableName + " set " + column + " = " + values + " where " + col + " = " + ids + "";
//string UpdateQuery = " UPDATE " + TableName + " VALUES " + values + " WHERE " + col + " = " + ids;
string constr = ConfigurationManager.AppSettings["connstr"];
SqlConnection objcon = new SqlConnection(constr);
objcon.Open();
SqlCommand cmd = new SqlCommand(UpdateQuery, objcon);
cmd.ExecuteNonQuery();
objcon.Close();
return(Json(new { Result = "Success", URL = @Url.Action("AlertPopUp", "Popup") }, JsonRequestBehavior.AllowGet));
}
catch (Exception)
{
return(Json(new { Result = "Already", URL = @Url.Action("AlertPopUp", "Popup") }, JsonRequestBehavior.AllowGet));
}
}
