Guest User

Untitled

a guest
Jul 26th, 2018
135
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.19 KB | None | 0 0
  1. Insert Data Into My DB trouble
  2. <%@ Page Title="" Language="C#" MasterPageFile="~/Views/Shared/Site.Master" Inherits="System.Web.Mvc.ViewPage<IEnumerable<J2V.Models.preinscrit>>" %>
  3. // some Html Code
  4. <% foreach (var item in Model) { %>
  5. <li>
  6. <div class="listinfo">
  7. <h3>
  8. <%: Html.DisplayFor(modelItem => item.Nag) %>
  9. </h3>
  10. <p>
  11. <%: Html.DisplayFor(modelItem => item.Idag) %>
  12.  
  13. </p>
  14. <span class="price"> <%: Html.DisplayFor(modelItem => item.Adrag) %> <%: Html.DisplayFor(modelItem => item.Vilag) %> <%: Html.DisplayFor(modelItem => item.Gov) %></span> <span class="media">Tel : <%: Html.DisplayFor(modelItem => item.Telag) %> |</span> <%: Html.DisplayFor(modelItem => item.Mailag) %>
  15. </div>
  16. <div class="listingbtns">
  17. <span class="listbuttons"><%: Html.ActionLink("Valide", "Valide", new {mod= item}) %> |</span>
  18. <span class="listbuttons"><%: Html.ActionLink("Supprime", "Delete", new { id=item.Idag }) %></span>
  19. </div>
  20. <div class="clear">
  21. &nbsp;
  22. </div>
  23. </li>
  24. <% } %>
  25.  
  26. [HttpGet]
  27. public ActionResult Valide(Models.preinscrit model )
  28. {
  29.  
  30. var db = new Models.J2VEntities();
  31. Models.agence ag = new Models.agence();
  32. Models.user user = new Models.user();
  33. ag.Adrag = model.Adrag ;
  34. ag.Gov = model.Gov ;
  35. ag.Idag = model.Idag;
  36. ag.Mailag = model.Mailag;
  37. ag.Nomag = model.Nag;
  38. ag.Vilag = model.Vilag;
  39.  
  40. user.IsAdmin = false;
  41. user.iduser = model.Idag;
  42. user.password = Models.LogModel.register.CreateRandomPassword();
  43.  
  44. db.AddTouser(user);
  45. db.AddToagence(ag);
  46. return View("index");
  47. }
  48.  
  49. <span class="listbuttons"><%: Html.ActionLink("Valide", "Valide", new {id= item.id}) %> |</span>
  50.  
  51. public ActionResult Valide(int id )
  52. {
  53.  
  54. var db = new Models.J2VEntities();
  55. Models.agence ag = new Models.agence();
  56. Models.user user = new Models.user();
  57.  
  58. //select from databese by id and valide
  59.  
  60. ag.Adrag = model.Adrag ;
  61. ag.Gov = model.Gov ;
  62. ag.Idag = model.Idag;
  63. ag.Mailag = model.Mailag;
  64. ag.Nomag = model.Nag;
  65. ag.Vilag = model.Vilag;
  66.  
  67. user.IsAdmin = false;
  68. user.iduser = model.Idag;
  69. user.password = Models.LogModel.register.CreateRandomPassword();
  70.  
  71. db.AddTouser(user);
  72. db.AddToagence(ag);
  73. return View("index");
  74. }
  75.  
  76. //select list by id
  77. public IEnumerable<makale> select_makaleler_by_kategori(int kategori_id)
  78. {
  79. IEnumerable<makale> makale = (from m in entity.makale
  80. where m.kategori_id == kategori_id
  81. orderby m.olusturma_tarihi
  82. select m).ToList<makale>();
  83.  
  84. return makale;
  85. }
  86.  
  87. //select one element by id
  88. public makale select_makale(int makale_id)
  89. {
  90. makale makale = (from m in entity.makale
  91. where m.makale_id == makale_id
  92. select m).SingleOrDefault();
  93.  
  94. return makale;
  95. }
Add Comment
Please, Sign In to add comment