Exemplo n.º 1
0
        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));
                    }
                }
            }
        }
Exemplo n.º 2
0
        //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));
            }
        }
Exemplo n.º 3
0
        //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));
            }
        }
Exemplo n.º 4
0
        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));
            }
        }
Exemplo n.º 5
0
        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());
        }
Exemplo n.º 6
0
 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());
     }
 }
Exemplo n.º 7
0
        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));
        }
Exemplo n.º 8
0
 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));
     }
 }
Exemplo n.º 9
0
        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));
        }
Exemplo n.º 10
0
        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));
            }
        }
Exemplo n.º 11
0
        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));
            }
        }
Exemplo n.º 12
0
        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());
        }
Exemplo n.º 13
0
 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));
     }
 }
Exemplo n.º 14
0
        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"]);
        }
Exemplo n.º 15
0
 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));
     }
 }
Exemplo n.º 16
0
 // 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());
     }
 }
Exemplo n.º 17
0
        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"));
            }
        }
Exemplo n.º 18
0
        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));
                }
            }
        }
Exemplo n.º 19
0
        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));
        }
Exemplo n.º 20
0
 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));
         }
     }
 }
Exemplo n.º 21
0
 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));
         }
     }
 }
Exemplo n.º 22
0
 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));
         }
     }
 }
Exemplo n.º 23
0
 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));
         }
     }
 }
Exemplo n.º 24
0
 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));
     }
 }
Exemplo n.º 25
0
 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));
         }
     }
 }
Exemplo n.º 26
0
        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));
            }
        }
Exemplo n.º 27
0
        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);
        }
Exemplo n.º 28
0
        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));
                }
            }
        }
Exemplo n.º 29
0
        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());
        }
Exemplo n.º 30
0
        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());
        }