Пример #1
0
        public object DeleteAcademic(UpdateAcademicYear PM)
        {
            try
            {
                Tbl_AcademicYear_Master obj = db.Tbl_AcademicYear_Master.Where(r => r.AcademicID == PM.AcademicID).FirstOrDefault();


                if (obj.Status == 1)
                {
                    obj.Status = 0;
                }
                else
                {
                    obj.Status = 1;
                }

                db.SaveChanges();

                return(new Result()
                {
                    IsSucess = true, ResultData = "State Deactivated Successfully."
                });
            }
            catch (Exception e)
            {
                return(new Error()
                {
                    IsError = true, Message = e.Message
                });
            }
        }
        public object AcademicUpdate(UpdateAcademicYear b)
        {
            if (b.Type == null)
            {
                return(new Error()
                {
                    IsError = true, Message = "Required State"
                });
            }
            var data = db.Tbl_AcademicYear_Master.Where(r => r.AcademicID == b.AcademicID).FirstOrDefault();

            try
            {
                Tbl_AcademicYear_Master obj = new Tbl_AcademicYear_Master();
                data.Type         = b.Type;
                data.StartDate    = Convert.ToDateTime(b.StartDate.ToShortDateString());
                data.EndDate      = Convert.ToDateTime(b.EndDate.ToShortDateString());
                data.ModifiedBy   = null;
                data.ModifiedDate = System.DateTime.Today.Date;
                db.SaveChanges();
                return(new Result()
                {
                    IsSucess = true, ResultData = "Update Academic"
                });
            }
            catch (Exception e)
            {
                return(new Error()
                {
                    IsError = true, Message = e.Message
                });
            }
        }
Пример #3
0
        public object SaveAcademic(AcademicParam b)
        {
            if (b.Type == null)
            {
                return(new Error()
                {
                    IsError = true, Message = "Required Type"
                });
            }
            var data = db.Tbl_AcademicYear_Master.FirstOrDefault(r => r.Type == b.Type && r.Status == 0);

            if (data != null)
            {
                return(new Error()
                {
                    IsError = true, Message = "Duplicate Entry Not Allowed"
                });
            }
            try
            {
                Tbl_AcademicYear_Master obj = new Tbl_AcademicYear_Master();
                obj.Type         = b.Type;
                obj.AcademicYear = b.AcademicYear;
                obj.StartDate    = Convert.ToDateTime(b.StartDate.ToShortDateString());
                obj.EndDate      = Convert.ToDateTime(b.EndDate.ToShortDateString());
                obj.Status       = 1;
                obj.CreatedBy    = 1;
                obj.CreatedDate  = System.DateTime.Today.Date;
                obj.ModifiedBy   = null;
                obj.ModifiedDate = System.DateTime.Today.Date;
                db.Tbl_AcademicYear_Master.Add(obj);
                db.SaveChanges();
                return(new Result()
                {
                    IsSucess = true, ResultData = "Created Academic Year"
                });
            }
            catch (Exception e)
            {
                return(new Error()
                {
                    IsError = true, Message = e.Message
                });
            }
        }