public ActionResult Index(int id) { ViewModel obj = new ViewModel(); var ctx = new CosmicVerseEntities1(); //Article List <Article> querylist = new List <Article>(); querylist = (from m in ctx.Articles where m.ID == id select m).ToList(); foreach (var item in querylist) { obj.ArticleDateTime = item.DateTime.ToString(); obj.ArticleTitle = item.Title; obj.Body = item.Body; obj.ShortDesc = item.ShortDesc; obj.Author = item.Author; obj.ArticleID = item.ID; } IEnumerable <Treeview.Comment> querylistC; querylistC = (from m in ctx.Comments where m.ArticleID == id && m.Flag == true select m); obj.allComments = querylistC; return(View(obj)); }
public ActionResult SaveNode(string childid, string parentid) { //*****REVISION******Do not allow reportsto = itself if (childid != null && parentid != null && parentid != childid) { string source = childid; string destination = parentid; using (var ctx = new CosmicVerseEntities1()) { var personals = ctx.Personals.Where(m => m.Name == source).First(); var personalsParent = ctx.Personals.Where(m => m.Name == destination).First(); //***check //*****REVISION******Do not allow make circle in data base such as P1 is parent for P2 and also P2 is parent for P1 ==> Prevent these mistake by checking it // if (personalsParent.ReportsTo != personals.ID) { personals.ReportsTo = Convert.ToInt16(personalsParent.ID); ctx.SaveChanges(); } //***check } } return(RedirectToAction("Index")); }
public ActionResult CreateContent(Treeview.Models.Content content) { using (var ctx = new CosmicVerseEntities1()) { Content cont = new Content(); cont.Title = content.ContentTitle; cont.Body = content.ContentBody; contentRepository.InsertContent(cont); contentRepository.Save(); } return(RedirectToAction("Index")); }
public ActionResult Links() { Content cont = new Content(); Treeview.Models.Content contM = new Treeview.Models.Content(); using (var ctx = new CosmicVerseEntities1()) { cont = contentRepository.GetContentByID(4); contM.ContentTitle = cont.Title; contM.ContentBody = cont.Body; } return(View(contM)); }
public ActionResult Edit(Content content) { // string strmy=Request.QueryString["Body"]; using (var ctx = new CosmicVerseEntities1()) { Content cont = new Content(); cont.ID = content.ID; cont.Title = content.Title; cont.Body = content.Body; contentRepository.UpdateContent(cont); contentRepository.Save(); } return(RedirectToAction("Index")); }
public ActionResult Edit(ViewModel article) { // string strmy=Request.QueryString["Body"]; using (var ctx = new CosmicVerseEntities1()) { Article art = new Article(); art.ID = article.ArticleID; art.Title = article.ArticleTitle; art.Body = article.Body; art.ShortDesc = article.ShortDesc; art.DateTime = DateTime.Now.DayOfWeek.ToString() + " " + DateTime.Now.Month.ToString() + " " + DateTime.Now.Year.ToString() + " " + DateTime.Now.Hour.ToString() + ":" + DateTime.Now.Minute.ToString(); art.Author = "Mahsa Hassankashi"; articleRepository.UpdateArticle(art); articleRepository.Save(); } return(RedirectToAction("Index")); }
public ActionResult Comment(ViewModel vcomment) { // string strmy=Request.QueryString["Body"]; using (var ctx = new CosmicVerseEntities1()) { Comment com = new Comment(); com.ArticleID = vcomment.ArticleID; com.Title = vcomment.ArticleTitle; com.BodyMsg = vcomment.BodyMsg; com.Name = vcomment.Name; com.Email = vcomment.Email; com.DateTime = DateTime.Now.DayOfWeek.ToString() + " " + DateTime.Now.Month.ToString() + " " + DateTime.Now.Year.ToString() + " " + DateTime.Now.Hour.ToString() + ":" + DateTime.Now.Minute.ToString(); com.Flag = false; //************START try { MailMessage objeto_mail = new MailMessage(); SmtpClient client = new SmtpClient(); client.Port = 25; client.Host = "smtp.internal.cosmicverse.info"; client.Timeout = 10000; client.DeliveryMethod = SmtpDeliveryMethod.Network; client.UseDefaultCredentials = false; client.Credentials = new System.Net.NetworkCredential("*****@*****.**", "75337533"); objeto_mail.From = new MailAddress("*****@*****.**"); objeto_mail.To.Add(new MailAddress(vcomment.Email)); objeto_mail.Bcc.Add(new MailAddress("*****@*****.**")); objeto_mail.Subject = "cosmic verse"; objeto_mail.Body = "Thank you dear for your comment. Your comment is in queue process"; client.Send(objeto_mail); } catch (Exception ex) { } //***************END commentRepository.InsertComment(com); commentRepository.Save(); } //Notification : your message is in confirm process return(RedirectToAction("Index")); }
//************** //*********** public ActionResult EditView(int id) { Content obj = new Content(); var ctx = new CosmicVerseEntities1(); //Article List <Content> querylist = new List <Content>(); querylist = (from m in ctx.Contents where m.ID == id select m).ToList(); foreach (var item in querylist) { obj.ID = item.ID; obj.Title = item.Title; obj.Body = item.Body; } return(View(obj)); }
public ActionResult EditView(int id) { ViewModel obj = new ViewModel(); var ctx = new CosmicVerseEntities1(); //Article List <Article> querylist = new List <Article>(); querylist = (from m in ctx.Articles where m.ID == id select m).ToList(); foreach (var item in querylist) { obj.ArticleDateTime = item.DateTime.ToString(); obj.ArticleTitle = item.Title; obj.Body = item.Body; obj.ShortDesc = item.ShortDesc; obj.Author = item.Author; obj.ArticleID = item.ID; } return(View(obj)); }
public ActionResult CommentList() { //string strID=TempData["articleID"].ToString(); IEnumerable <Comment> obj = commentRepository.GetCommentByArticleID(1); var ctx = new CosmicVerseEntities1(); ////Comment //List<Comment> querylistC = new List<Comment>(); //querylistC = (from m in ctx.Comments // where m.ArticleID == Convert.ToInt16(strID) && m.Flag == true // select m).ToList(); //foreach (var item in querylistC) //{ // obj.Name = item.Name; // obj.Email = item.Email; // obj.BodyMsg = item.BodyMsg; // obj.commentDateTime = item.DateTime; //} return(View(obj)); }
public ActionResult LinkHit(string link) { //this line is to check the clien ip address from the server itself string IP = ""; string strHostName = ""; strHostName = System.Net.Dns.GetHostName(); IPHostEntry ipEntry = System.Net.Dns.GetHostEntry(strHostName); IPAddress[] addr = ipEntry.AddressList; IP = addr[2].ToString(); //Initializing a new xml document object to begin reading the xml file returned XmlDocument doc = new XmlDocument(); doc.Load("http://www.freegeoip.net/xml"); XmlNodeList nodeLst_IP = doc.GetElementsByTagName("Ip"); XmlNodeList nodeLst_CountryCode = doc.GetElementsByTagName("CountryCode"); XmlNodeList nodeLst_CountryName = doc.GetElementsByTagName("CountryName"); XmlNodeList nodeLst_RegionCode = doc.GetElementsByTagName("RegionCode"); XmlNodeList nodeLst_RegionName = doc.GetElementsByTagName("RegionName"); XmlNodeList nodeLst_City = doc.GetElementsByTagName("City"); XmlNodeList nodeLst_ZipCode = doc.GetElementsByTagName("ZipCode"); XmlNodeList nodeLst_Latitude = doc.GetElementsByTagName("Latitude"); XmlNodeList nodeLst_Longitude = doc.GetElementsByTagName("Longitude"); XmlNodeList nodeLst_MetroCode = doc.GetElementsByTagName("MetroCode"); XmlNodeList nodeLst_AreaCode = doc.GetElementsByTagName("AreaCode"); //IP = "" + nodeLst_IP[0].InnerText + "<br>" + nodeLst_CountryCode[0].InnerText + "<br>" + // nodeLst_CountryName[0].InnerText; //Response.Write(IP); //this is my header that I love if (link != null) { string source = link; //string destination = parentid; using (var ctx = new CosmicVerseEntities1()) { LinkHit lnkhit = new LinkHit(); lnkhit.Link = link; lnkhit.Date = DateTime.Now.Date.Date.ToString(); lnkhit.Time = DateTime.Now.TimeOfDay.ToString(); lnkhit.countrycode = nodeLst_CountryCode[0].InnerText; lnkhit.countryname = nodeLst_CountryName[0].InnerText; lnkhit.city = nodeLst_City[0].InnerText; lnkhit.IP = nodeLst_IP[0].InnerText; lnkhit.regioncode = nodeLst_RegionCode[0].InnerText; lnkhit.regionname = nodeLst_RegionName[0].InnerText; lnkhit.areacode = nodeLst_AreaCode[0].InnerText; lnkhit.longitude = nodeLst_Longitude[0].InnerText; lnkhit.latitude = nodeLst_Latitude[0].InnerText; lnkhit.zipcode = nodeLst_ZipCode[0].InnerText; ctx.LinkHits.Add(lnkhit); ctx.SaveChanges(); } } return(RedirectToAction(link)); }
public string Treeview(int itemID, string mystr, int j, int flag) { List <Personal> querylist = new List <Personal>(); var ctx = new CosmicVerseEntities1(); if (flag == 0) { querylist = (from m in ctx.Personals where m.ReportsTo == null select m).ToList(); mainNode = querylist.Count; mystr += "["; } if (flag == 1) { querylist = (from m in ctx.Personals where m.ReportsTo == itemID select m).ToList(); mainNode = querylist.Count; mystr += ",items:["; } //Below line shows an example of how to make parent node with his child //[{ id: "1", text: "P1", items: [{ id: "5", text: "P2" }] }] int i = 1; foreach (var item in querylist) { myflag = 0; mystr += "{id:\"" + item.ID + "\",text:\"" + item.Name + "\""; List <Personal> querylistParent = new List <Personal>(); //Check this parent has child or not , if yes how many? querylistParent = (from m in ctx.Personals where m.ReportsTo == item.ID select m).ToList(); childquantity = querylistParent.Count; //If Parent Has Child again call Treeview with new parameter if (childquantity > 0) { mystr = Treeview(item.ID, mystr, i, 1); } //No Child and No Last Node else if (childquantity == 0 && i < querylist.Count) { mystr += "},"; } //No Child and Last Node else if (childquantity == 0 && i == querylist.Count) { int fcheck2 = 0; int fcheck3 = 0; int counter = 0; int flagbreak = 0; int currentparent; List <Personal> parentquery; List <Personal> childlistquery; TempData["counter"] = 0; currentparent = Convert.ToInt16(item.ReportsTo); int coun; while (currentparent != 0) { //count parent of parent fcheck2 = 0; fcheck3 = 0; parentquery = new List <Personal>(); parentquery = (from m in ctx.Personals where m.ID == currentparent select m).ToList(); var rep2 = (from h in parentquery select new { h.ReportsTo }).First(); //put {[ up to end //list of child childlistquery = new List <Personal>(); childlistquery = (from m in ctx.Personals where m.ReportsTo == currentparent select m).ToList(); foreach (var item22 in childlistquery) { if (mystr.Contains(item22.ID.ToString())) { if (item22.ReportsTo == currentparent) { fcheck3 += 1; if (fcheck3 == 1) { counter += 1; } } } else { myflag = 1; if (item22.ReportsTo == currentparent) { fcheck2 += 1; if (fcheck2 == 1) { counter -= 1; flagbreak = 1; } } } } var result55 = (from h in parentquery select new { h.ID }).First(); coun = Convert.ToInt16(result55.ID); TempData["coun"] = Convert.ToInt16(coun); currentparent = Convert.ToInt16(rep2.ReportsTo); if (flagbreak == 1) { break; } } for (int i2 = 0; i2 < counter; i2++) { mystr += "}]"; } List <Personal> lastchild = new List <Personal>(); lastchild = (from m in ctx.Personals where m.ReportsTo == item.ReportsTo select m).ToList(); List <Personal> lastparent = new List <Personal>(); lastparent = (from m in ctx.Personals where m.ReportsTo == null select m).ToList(); if (lastchild.Count > 0) { var result_lastchild = (from h in lastchild select new { h.ID }).Last(); var result_lastparent = (from h in lastparent select new { h.ID }).Last(); int mycount = Convert.ToInt16(TempData["coun"]); if (item.ID == result_lastchild.ID && mycount == result_lastparent.ID && myflag == 0) { mystr += "}]"; } else if (item.ID == result_lastchild.ID && mycount == result_lastparent.ID && myflag == 1) { mystr += "},"; } else if (item.ID == result_lastchild.ID && mycount != result_lastparent.ID) { mystr += "},"; } } // finish }] else if (lastchild.Count == 0 && item.ReportsTo == null) { mystr += "}]"; } } i++; } return(mystr); }