public ActionResult Register2(string un, string pw) { using (CGPEntities ctx = new CGPEntities()) { Account us = ctx.Accounts.Where(p1 => p1.Username == un).FirstOrDefault(); if (us != null) { //return Content("error"); return(Json(new { success = false, responseText = "error" }, JsonRequestBehavior.AllowGet)); } else { Account u = new Account(); u.Username = un; //Mã hóa password u.Password = StringUtils.MD5(pw); try { ctx.Accounts.Add(u); ctx.SaveChanges(); // return Content("success"); return(Json(new { success = true, responseText = "success" }, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { //return Content("error"); return(Json(new { success = false, responseText = "error" }, JsonRequestBehavior.AllowGet)); } } } }
//cho nay public ActionResult getListMember(int TreeID, int Tcuu, string Ten, string FDate, string TDate) { string Where = ""; if (Tcuu == 1) { Where = "AND FullName Like '%" + Ten + "%' AND Year(Birthday) BETWEEN " + FDate + " AND " + TDate; } using (CGPEntities dt = new CGPEntities()) { string Query = "Select M1.*,Format(Birthday,'dd/MM/yyyy HH:mm') bd" + ",Case when M2.Sex = 'M' THEN M2.FullName ELSE ISNULL(M3.FullName,'') END Fa,Case when M2.Sex = 'F' THEN M2.FullName ELSE ISNULL(M3.FullName,'') END Mo" + " From" + " (Select ID,Generation,FullName,Sex,ISNULL(Memberold,0) Memberold,Birthday from Member where TreeID = " + TreeID + " AND TypeRelationship = 0 " + Where + ") AS M1" + " INNER JOIN" + " (Select ID,Memberold,FullName,Sex from Member where TreeID = " + TreeID + ") AS M2 ON M1.Memberold = M2.Id" + " LEFT JOIN" + " (Select ID,Memberold,FullName from Member where TreeID = " + TreeID + " AND TypeRelationship = 1 ) AS M3 ON M2.Id = M3.Memberold" + " UNION" + " Select ID,Generation,FullName,Sex,ISNULL(Memberold,0) Memberold,Birthday,Format(Birthday,'dd/MM/yyyy HH:mm') bd,'' Fa,'' Mo from Member where TreeID =" + TreeID + " AND TypeRelationship != 0 " + Where; var kq = dt.Database.SqlQuery <DSMember>(Query).ToList(); //var kq = dt.Members.FromSql("EXECUTE CGP.dbo.GetMostPopularBlogsForUser {0}", TreeID) // .ToList(); return(Json(kq, JsonRequestBehavior.AllowGet)); } }
//public ActionResult Login(Account model) public ActionResult Login(string u, string pa) { using (CGPEntities dt = new CGPEntities()) { //string pass = StringUtils.MD5(model.Password); //Account us = dt.Accounts // .Where(p => p.Username == model.Username && p.Password == pass) // .FirstOrDefault(); Account us = dt.Accounts .Where(p => p.Username == u && p.Password == pa) .FirstOrDefault(); if (us != null) { //if (model.Remember != null) //{ // //Cái này xử lí nếu người dùng check Ghi nhớ đăng nhập // Response.Cookies["userID"].Value = us.UserName.ToString(); // Response.Cookies["userID"].Expires = DateTime.Now.AddDays(7); //} Session["isLogin"] = 1; Session["user"] = us; Session["IdUser"] = us.ID; Session["username"] = us.Username; ViewBag.Mes = 1; //return Content("success"); return(Json(new { success = true, responseText = "success" }, JsonRequestBehavior.AllowGet)); } TempData["state"] = 5; ViewBag.Mes = 2; //return Content("error"); return(Json(new { success = false, responseText = "error" }, JsonRequestBehavior.AllowGet)); } }
public ActionResult Login2(string u, string p) { using (CGPEntities dt = new CGPEntities()) { string pass = StringUtils.MD5(p); Account us = dt.Accounts .Where(pu => pu.Username == u && pu.Password == pass) .FirstOrDefault(); if (us != null) { Session["isLogin"] = 1; Session["user"] = us; Session["IdUser"] = us.ID; Session["username"] = us.Username; ViewBag.Mes = 1; //return Content("success"); return(Json(new { success = true, responseText = "success" }, JsonRequestBehavior.AllowGet)); } ViewBag.Mes = 2; //return Content("error"); return(Json(new { success = false, responseText = "error" }, JsonRequestBehavior.AllowGet)); } }
public ActionResult Report(int?id) { Session["NameTree"] = ""; ViewBag.Tit = "Lập báo cáo"; ViewBag.Show = 1; ViewBag.Name = "FamilyTree"; ViewBag.Link = id.HasValue == false? "../" : "/CGP/FamilyTree/?id=" + id.ToString(); ViewBag.Name2 = "Report"; if (id.HasValue == false) { return(RedirectToAction("Index", "Home")); } int AccID = int.Parse(Session["IdUser"] == null ? "-1" : Session["IdUser"].ToString()); using (var ctx = new CGPEntities()) { var model = ctx.Trees.Where(p => p.TreeID == id && p.AccountID == AccID).ToList(); if (model.Count() == 0) { return(RedirectToAction("Index", "Home")); } Session["NameTree"] = "Gia tộc " + model[0].Name.ToString(); } ViewBag.Id = id; return(View()); }
public ActionResult FamilyTree(int?id) { ViewBag.Tit = "Quản lý thành viên"; ViewBag.Show = 1; ViewBag.Name = "CGP"; ViewBag.Link = "../"; ViewBag.Name2 = "FamilyTree"; if (id.HasValue == false) { return(RedirectToAction("Index", "Home")); } ViewBag.Id = id; using (var ctx = new CGPEntities()) { int idt = int.Parse(id.ToString()); CurrentContext.SetCurrentTree(idt); int AccID = int.Parse(Session["IdUser"].ToString()); var model = ctx.Trees.Where(p => p.TreeID == id && p.AccountID == AccID).ToList(); if (model.Count() > 0) { Session["NameTree"] = "Gia tộc " + model[0].Name.ToString(); } else { Session["NameTree"] = ""; return(RedirectToAction("Index", "CGP")); } return(View()); } }
public ActionResult MemberInfo(int id) { ViewBag.Id = CurrentContext.GetCurrentTree(); CGPEntities ctx = new CGPEntities(); Member model = ctx.Members.Where(p => p.Id == id).FirstOrDefault(); return(View(model)); }
public ActionResult GetBurialPlace() { using (CGPEntities dt = new CGPEntities()) { int t = CurrentContext.GetCurrentTree(); var m = dt.BurialPlaces.Where(b => b.TreeID == t).ToList(); return(Json(m, JsonRequestBehavior.AllowGet)); } }
public ActionResult Edit(int Id) { CGPEntities c = new CGPEntities(); var mb = c.Members; //Get the student from studentList sample collection for demo purpose. //You can get the student from the database in the real application var std = mb.Where(s => s.Id == Id).FirstOrDefault(); return(View(std)); }
public ActionResult UpdateCod(int jID, string jName) { using (CGPEntities dt = new CGPEntities()) { int t = CurrentContext.GetCurrentTree(); CauseOfDeath m = dt.CauseOfDeaths.Where(j => j.TreeID == t && j.CauseOfDeathID == jID).FirstOrDefault(); m.CauseOfDeathText = jName; dt.SaveChanges(); return(Json(m, JsonRequestBehavior.AllowGet)); } }
public ActionResult UpdateBrP(int jID, string jName) { using (CGPEntities dt = new CGPEntities()) { int t = CurrentContext.GetCurrentTree(); BurialPlace m = dt.BurialPlaces.Where(j => j.TreeID == t && j.BurialPlaceID == jID).FirstOrDefault(); m.BurialPlaceName = jName; dt.SaveChanges(); return(Json(m, JsonRequestBehavior.AllowGet)); } }
public ActionResult Create() { CGPEntities db = new CGPEntities(); //Build SelectList ViewBag.BPlace = new SelectList(db.BirthPlaces, "BirthPlaceID", "BirthPlaceName"); ViewBag.BurPlace = new SelectList(db.BurialPlaces, "BurialPlaceID", "BurialPlaceName"); ViewBag.CoDeath = new SelectList(db.CauseOfDeaths, "CauseOfDeathID", "CauseOfDeathText"); //List<Job> dpl = db.Jobs.ToList(); //IEnumerable<SelectListItem> items = db.Jobs.Select(c => new SelectListItem { Value = c.JobID.ToString(), Text = c.JobName }); //ViewBag.Job = items; ViewBag.Job = new SelectList(db.Jobs, "JobID", "JobName"); return(View()); }
public ActionResult GetControl(int ID) { using (CGPEntities dt = new CGPEntities()) { var Ach = dt.ListAchievements.Where(b => b.TreeID == ID).ToList(); var Bl = dt.BirthPlaces.Where(b => b.TreeID == ID).ToList(); var Jo = dt.Jobs.Where(b => b.TreeID == ID).ToList(); var Bp = dt.BurialPlaces.Where(b => b.TreeID == ID).ToList(); var Cod = dt.CauseOfDeaths.Where(b => b.TreeID == ID).ToList(); var OldID = dt.Members.Where(b => b.TreeID == ID && b.TypeRelationship != 1).Select(b => new { ID = b.Id, Name = b.FullName }).ToList(); var couple = dt.Database.SqlQuery <Couple>("select A.Id ID1,A.Sex Sex1,ISNULL(B.Id,0) ID2,ISNULL(B.Sex,'') Sex2 from (Select Id,Memberold,Sex from Member where TreeID = " + ID + ") A LEFT JOIN (Select ID,Memberold,Sex from Member where TreeID = " + ID + " AND TypeRelationship = 1 ) B ON A.ID = ISNULL(B.Memberold,0) OR ISNULL(A.Memberold,0) =B.Id").ToList(); return(Json(new { Ach = Ach, Bl = Bl, Jo = Jo, Bp = Bp, Cod = Cod, OldID = OldID, couple = couple }, JsonRequestBehavior.AllowGet)); } }
public static Account GetCurUser() { string id = ((Account)HttpContext.Current.Session["user"]).Username; using (var ctx = new CGPEntities()) { var user = ctx.Accounts.Where(u => u.Username == id).FirstOrDefault(); HttpContext.Current.Session["user"] = null; if (user != null) { HttpContext.Current.Session["user"] = user; } } return((Account)HttpContext.Current.Session["user"]); }
public ActionResult Index() { ViewBag.Tit = "Quản lý Gia Tộc"; ViewBag.Show = 1; ViewBag.Link = "/CGP"; ViewBag.Name = "CGP"; ViewBag.Name2 = "Index"; using (CGPEntities ctx = new CGPEntities()) { int id = 0; id = int.Parse(Session["IdUser"].ToString()); List <Tree> List = ctx.Trees.Where(p => p.AccountID == id).ToList(); return(View(List)); } }
// GET: CGP/CreateCGP //[CheckLogin] public ActionResult CreateCGP(int?id) { if (id.HasValue == false) { return(RedirectToAction("Index", "Home")); } ViewBag.Id = id; using (var ctx = new CGPEntities()) { int idt = int.Parse(id.ToString()); CurrentContext.SetCurrentTree(idt); var model = ctx.Trees.Where(p => p.TreeID == id).FirstOrDefault(); return(View()); } }
public ActionResult Register(Account model) { using (CGPEntities ctx = new CGPEntities()) { //Check exists account //Account us = ctx.Accounts.Where(p => p.Email == model.Email.ToString()).FirstOrDefault(); Account us = ctx.Accounts.Where(p => p.Username == model.Username.ToString()).FirstOrDefault(); if (us != null) { ViewBag.Mes = 2; return(RedirectToAction("Index", "Home")); } else { Account u = new Account(); u.Username = model.Username; //u.Password = model.Password; //Mã hóa password u.Password = StringUtils.MD5(model.Password); //u.Email = model.Email; try { ctx.Accounts.Add(u); ctx.SaveChanges(); @ViewBag.Error = false; //Login(model); ViewBag.Mes = 1; // Response.Write("<script LANGUAGE='JavaScript' >alert('Đăng ký thành công. Đang chuyển về trang chủ')</script>"); return(RedirectToAction("Index", "Home")); } catch (Exception ex) { Response.Write("<script LANGUAGE='JavaScript' >alert('Lỗi.')</script>" + ex.ToString()); } } ViewBag.Mes = 2; return(RedirectToAction("Index", "Home")); } }
public JsonResult AddMemberNew(int TreeID, string FName, string DChi, string GTinh, string VLam, string MBOld, int QHe, string NSinh, string NoiSinh, string CDate) { CGPEntities db = new CGPEntities(); var Mem = new Member(); Mem.TreeID = TreeID; Mem.FullName = FName; Mem.AddressID = DChi; Mem.Sex = GTinh; if (VLam != "") { Mem.Job = Int32.Parse(VLam); } Mem.TypeRelationship = QHe; Mem.Birthday = DateTime.ParseExact(NSinh, "dd/MM/yyyy HH:mm:tt", CultureInfo.InvariantCulture); Mem.Date_Create = DateTime.ParseExact(CDate, "dd/MM/yyyy HH:mm:tt", CultureInfo.InvariantCulture); if (NoiSinh != "") { Mem.BirthPlaceId = Int32.Parse(NoiSinh); } int SoDoi = 1; //neu khong co thanh vien cu (la nguoi đứng đầu gia phả) if (MBOld != "") { int tempID = Int32.Parse(MBOld); var kq = db.Members.Where(b => b.TreeID == TreeID && b.Id == tempID).Select(b => new { Doi = b.Generation }).ToList(); SoDoi = Int32.Parse(kq[0].Doi.ToString()); Mem.Memberold = Int32.Parse(MBOld); } var Doi = QHe == -1 ? 1 : QHe == 1 ? SoDoi : SoDoi + 1; Mem.Generation = Doi; using (CGPEntities ctx = new CGPEntities()) { try { ctx.Members.Add(Mem); ctx.SaveChanges(); return(Json("Thêm Thành Công !", JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json(ex.Message, JsonRequestBehavior.AllowGet)); } } }
public ActionResult MemberInfo(Member m) { ViewBag.Id = CurrentContext.GetCurrentTree(); CGPEntities ctx = new CGPEntities(); Member m2 = ctx.Members.Where(p => p.Id == m.Id).FirstOrDefault(); m2.FullName = m.FullName; m2.Job = m.Job; m2.AddressID = m.AddressID; m2.Sex = m.Sex; m2.Birthday = m.Birthday; m2.BirthPlaceId = m.BirthPlaceId; ctx.SaveChanges(); return(View(m)); }
public JsonResult UpdateMemberInfo2(int fid, string fdod, int fbp, int fcod) { using (CGPEntities ctx = new CGPEntities()) { try { Member m = ctx.Members.Where(p => p.Id == fid).FirstOrDefault(); m.DateOfDeath = DateTime.ParseExact(fdod, "dd/MM/yyyy", CultureInfo.InvariantCulture); m.BurialPlaceId = fbp; m.CauseOfDeath = fcod; ctx.SaveChanges(); return(Json("Cập Nhật Thành Công !", JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json(ex.Message, JsonRequestBehavior.AllowGet)); } } }
public ActionResult AddJob(string jobname) { using (CGPEntities ctx = new CGPEntities()) { try { Job j = new Job(); j.JobName = jobname; j.TreeID = CurrentContext.GetCurrentTree(); ctx.Jobs.Add(j); ctx.SaveChanges(); return(Json("Thêm Thành Công !", JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json(ex.Message, JsonRequestBehavior.AllowGet)); } } }
public ActionResult AddCod(string jName) { using (CGPEntities ctx = new CGPEntities()) { try { CauseOfDeath b = new CauseOfDeath(); b.CauseOfDeathText = jName; b.TreeID = CurrentContext.GetCurrentTree(); ctx.CauseOfDeaths.Add(b); ctx.SaveChanges(); return(Json("Thêm Thành Công !", JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json(ex.Message, JsonRequestBehavior.AllowGet)); } } }
public ActionResult AddBrP(string jName) { using (CGPEntities ctx = new CGPEntities()) { try { BurialPlace b = new BurialPlace(); b.BurialPlaceName = jName; b.TreeID = CurrentContext.GetCurrentTree(); ctx.BurialPlaces.Add(b); ctx.SaveChanges(); return(Json("Thêm Thành Công !", JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json(ex.Message, JsonRequestBehavior.AllowGet)); } } }
public JsonResult GetReportMember(string TreeID, string Year, string Year1, int Type) { using (CGPEntities dt = new CGPEntities()) { if (Type == 0) { string Query = "Select row_number() OVER (ORDER BY Nam) STT,Nam,Sum(S) SlS,Sum(KH) SlKH,Sum(MT) SlMT" + " FROM" + "(" + " Select Year(Birthday) Nam,1 S,0 KH,0 MT" + " From Member where TreeID = " + TreeID + " AND Year(Birthday) BETWEEN " + Year + " AND " + Year1 + " UNION ALL" + " Select Year(Date_Create) Nam,0 S,1 KH,0 MT" + " From Member where TreeID = " + TreeID + " AND Year(Date_Create) BETWEEN " + Year + " AND " + Year1 + " AND TypeRelationship = 1" + " UNION ALL" + " Select ISNULL(Year(DateOfDeath),0) Nam, 0 S,0 KH,1 MT" + " From Member where TreeID = " + TreeID + " AND ISNULL(Year(DateOfDeath),0) BETWEEN " + Year + " AND " + Year1 + " ) AS A" + " Group by Nam"; var kq = dt.Database.SqlQuery <ReportTG>(Query).ToList(); //int? memberold = kq[0].Memberold; //var IdNodept = dt.Database.SqlQuery<int>("Select * From CGP.dbo.Member Where TreeID=" + TreeID + " AND ID =" + ID).ToList(); //var kq = dt.Members.FromSql("EXECUTE CGP.dbo.GetMostPopularBlogsForUser {0}", TreeID) // .ToList(); return(Json(kq, JsonRequestBehavior.AllowGet)); } else if (Type == 1) { string Query = "Select row_number() OVER (ORDER BY A.AchievementID) STT,B.AchievementName TenTT,count(*) Sl" + " From AchievementDetail A ,ListAchievement B" + " Where A.AchievementID = B.IDAchievement AND Year(DateIncurred) BETWEEN " + Year + " AND " + Year1 + " AND A.TreeID = " + TreeID + "Group BY A.AchievementID,B.AchievementName"; var kq = dt.Database.SqlQuery <ReportTC>(Query).ToList(); //int? memberold = kq[0].Memberold; //var IdNodept = dt.Database.SqlQuery<int>("Select * From CGP.dbo.Member Where TreeID=" + TreeID + " AND ID =" + ID).ToList(); //var kq = dt.Members.FromSql("EXECUTE CGP.dbo.GetMostPopularBlogsForUser {0}", TreeID) // .ToList(); return(Json(kq, JsonRequestBehavior.AllowGet)); } return(Json(null, JsonRequestBehavior.AllowGet)); } }
public JsonResult UpdateMemberAchievement(int fid, int fach, string fdate) { using (CGPEntities ctx = new CGPEntities()) { try { AchievementDetail a = new AchievementDetail(); a.MemberID = fid; a.AchievementID = fach; a.DateIncurred = DateTime.ParseExact(fdate, "dd/MM/yyyy", CultureInfo.InvariantCulture); a.TreeID = CurrentContext.GetCurrentTree(); ctx.AchievementDetails.Add(a); ctx.SaveChanges(); return(Json("Cập Nhật Thành Công !", JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json(ex.Message, JsonRequestBehavior.AllowGet)); } } }
public ActionResult InfomationMember(string ID) { using (CGPEntities dt = new CGPEntities()) { try { string Query = "Select * From Member Where ID =" + ID; var kq = dt.Database.SqlQuery <Member>(Query).ToList(); //int? memberold = kq[0].Memberold; //var IdNodept = dt.Database.SqlQuery<int>("Select * From CGP.dbo.Member Where TreeID=" + TreeID + " AND ID =" + ID).ToList(); //var kq = dt.Members.FromSql("EXECUTE CGP.dbo.GetMostPopularBlogsForUser {0}", TreeID) // .ToList(); return(Json(kq, JsonRequestBehavior.AllowGet)); } catch (Exception) { } return(Json(null, JsonRequestBehavior.AllowGet)); } }
public static bool IsLogged() { var flag = HttpContext.Current.Session["isLogin"]; if (flag == null || (int)flag == 0) { if (HttpContext.Current.Request.Cookies["userID"] != null) { string userIdCookie = Convert.ToString(HttpContext.Current.Request.Cookies["userID"].Value); using (var ctx = new CGPEntities()) { var user = ctx.Accounts.Where(u => u.Username == userIdCookie).FirstOrDefault(); HttpContext.Current.Session["isLogin"] = 1; HttpContext.Current.Session["user"] = user; } return(true); } return(false); } return(true); }
public JsonResult UpdateMemberInfo(int fid, string fname, int fjob, string faddress, string fsex, string fbirthday, int fbirthplace) { using (CGPEntities ctx = new CGPEntities()) { try { Member m2 = ctx.Members.Where(p => p.Id == fid).FirstOrDefault(); m2.FullName = fname; m2.Job = fjob; m2.AddressID = faddress; m2.Sex = fsex; m2.Birthday = DateTime.ParseExact(fbirthday, "dd/MM/yyyy HH:mm:tt", CultureInfo.InvariantCulture); m2.BirthPlaceId = fbirthplace; ctx.SaveChanges(); return(Json("Cập Nhật Thành Công !", JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json(ex.Message, JsonRequestBehavior.AllowGet)); } } }
public ActionResult CreateCGP(Member model) { int x = CurrentContext.GetCurrentTree(); model.Date_Create = DateTime.Now; model.DateOfDeath = DateTime.Now; //model.Birthday = DateTime.Now; //model.Job = "Cong viec test 1"; //model.Sex = "M"; if (model.Sex == null) { model.Sex = "M"; } model.TypeRelationship = 1; model.Memberold = 1; //model.BirthPlaceId = 1; model.BurialPlaceId = 1; model.CauseOfDeath = 1; model.TreeID = x; //model.AddressID = "Dia chi test 1"; //model.FullName = "Ho va ten test 1"; using (CGPEntities ctx = new CGPEntities()) { try { ctx.Members.Add(model); ctx.SaveChanges(); } catch (Exception ex) { Response.Write("<script LANGUAGE='JavaScript' >alert('Lỗi.')</script>" + ex.ToString()); } } return(View()); }
public ActionResult Create(Member m) { CGPEntities db = new CGPEntities(); //Build SelectList ViewBag.BPlace = new SelectList(db.BirthPlaces, "BirthPlaceID", "BirthPlaceName"); ViewBag.BurPlace = new SelectList(db.BurialPlaces, "BurialPlaceID", "BurialPlaceName"); ViewBag.CoDeath = new SelectList(db.CauseOfDeaths, "CauseOfDeathID", "CauseOfDeathText"); ViewBag.Job = new SelectList(db.Jobs, "JobID", "JobName"); //Chỗ này chưa xử lý nen để mặc định m.Date_Create = DateTime.Now; m.Memberold = 1; m.TreeID = 1; m.TypeRelationship = 1; var t = m; using (CGPEntities ctx = new CGPEntities()) { try { ctx.Members.Add(m); ctx.SaveChanges(); //@ViewBag.Error = false; Response.Write("<script LANGUAGE='JavaScript' >alert('OK')</script>"); } catch (Exception ex) { Response.Write("<script LANGUAGE='JavaScript' >alert('Lỗi.')</script>" + ex.ToString()); } } return(View()); }