public static string Savexml(string XML, string Name, string legoid, string status, string htmlc)
{
ProcessSharkEntities context = new ProcessSharkEntities();
string _PUserName = HttpContext.Current.User.Identity.Name.ToString();
string _Employeeid = Convert.ToString(context.Employees.Where(x => x.UserName == _PUserName).Select(y => y.EmployeeId).FirstOrDefault());
string _Companyid = Convert.ToString(context.Employees.Where(x => x.UserName == _PUserName).Select(y => y.CompanyId).FirstOrDefault());
Date = Name;
XMLfile = XML;
lego = legoid;
htmlfile = htmlc;
try
{
var task = Task.Run((Func <Task>)store.run);
task.Wait();
DBAccess _dbacc = new DBAccess();
if (status == "false")
{
string query = "insert INTO connection(connection_name,legoid,createby,createddate,last_modified,comments,position) VALUES('" + Name + "','" + legoid + "','" + _Employeeid + "','" + DateTime.Now + "','','',(select ISNULL(Max(position)+1,0) as position from connection where legoid=" + legoid + "))";
query += " insert into Tab_Changelog values(" + _Companyid + "," + _Employeeid + "," + legoid + "," + _Employeeid + ",'' ,'Created Diagram(" + Name + ")'," + legoid + ",1,getdate(),'Connections')";
_dbacc.ExecuteCommand(query);
}
}
catch (Exception ex)
{
throw ex;
}
//try
//{
// // string FilePath = "/IntelliModule/XML";
// var FilePath = System.Web.Hosting.HostingEnvironment.MapPath("~/XML");
// var Filesave = File.Create(FilePath + "/" + Name);
// Thread th = Thread.CurrentThread;
// XmlDocument doc = new XmlDocument();
// doc.AppendChild(doc.CreateElement(XML));
// doc.Save(Filesave + "/" + XML);
//}
//catch (Exception ex)
//{
// throw ex;
//}
return("");
}
public static List <Module_det> get_m_data(string model, string view, string L11)
{
ProcessSharkEntities context = new ProcessSharkEntities();
DBAccess _dacc = new DBAccess();
DataSet dsS = new DataSet();
string strQry = "";
string _PUserName = HttpContext.Current.User.Identity.Name.ToString();
_dacc = new DBAccess();
string _Companyid = Convert.ToString(context.Employees.Where(x => x.UserName == _PUserName).Select(y => y.CompanyId).FirstOrDefault());
string StrSql = _Companyid;
string strsql1 = model;
strQry = "exec detailshelpwindow_proc_new '" + StrSql + "','" + strsql1 + "'";
dsS = _dacc.GetDataSet(strQry);
List <Module_det> lmd = new List <Module_det>();
foreach (DataRow row in dsS.Tables[0].Rows)
{
Module_det md = new Module_det();
md.mname = row["LegoName"].ToString() + " ( " + row["LegoId"] + " )";
string L1 = Getaccess_value(row["LegoId"].ToString());
string link = "../../../../Account/model.aspx?Mode=O&ModelId=" + row["LegoId"] + "&L1=" + L1 + "&View=" + view + "&TempId=0";
md.mlink = link;
lmd.Add(md);
}
// string json = JsonConvert.SerializeObject(dsS, Formatting.Indented);
return(lmd);
}
