Example #1
0
            /// <summary>
            /// Insert Department Information
            /// </summary>
            /// <param name="data">Department Information</param>
            /// <returns>Number Affected Row</returns>
            public static Tuple <ErrorObject, string> Department(tblDepartment data)
            {
                erros = new ErrorObject();
                try
                {
                    using (HSCMEntities db = new HSCMEntities())
                    {
                        int propertyFind = db.tblDepartment.Count();
                        if (propertyFind > 0)
                        {
                            data.id = db.tblDepartment.Max(s => s.id);
                        }
                        else
                        {
                            data.id = 1;
                        }
                        db.tblDepartment.Add(data);
                        result  = db.SaveChanges();
                        Message = "Affected Row: " + result.ToString();

                        return(new Tuple <ErrorObject, string>(erros.IfError(false), Message));
                    }
                }
                catch (Exception ex)
                {
                    erros.InfoError(ex);
                    return(new Tuple <ErrorObject, string>(erros, String.Empty));
                }
            }
Example #2
0
        public ActionResult AddOrEdit(int id = 0)
        {
            if (id == 0)
            {
                using (Entities db = new Entities())
                {
                    ViewBag.Students = db.tblStudents.ToList();
                    ViewBag.Action   = "Add New Department";
                    return(View(new DepartmentViewModel()));
                }
            }
            else
            {
                using (Entities db = new Entities())
                {
                    ViewBag.Action   = "Edit Department";
                    ViewBag.Students = db.tblStudents.ToList();
                    tblDepartment       item   = db.tblDepartments.Where(i => i.DepartmentId == id).FirstOrDefault();
                    DepartmentViewModel itemvm = new DepartmentViewModel();
                    itemvm.DepartmentId = item.DepartmentId;
                    //  itemvm.StudentId = Convert.ToInt32(item.StudentId);
                    itemvm.DepartmentName = item.DepartmentName;
                    itemvm.TeacherId      = item.TeacherId;
                    itemvm.ReportId       = item.ReportId;


                    return(View(itemvm));
                }
            }
        }
        public IHttpActionResult PosttblDepartment(DepartmentModel department)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }
            object Lock  = new object();
            int    depId = 0;

            lock (Lock)
            {
                depId         = db.tblDepartments.Select(i => i.ID).DefaultIfEmpty(0).Max();
                department.ID = depId;
                tblDepartment tblDepartment = new tblDepartment()
                {
                    ID       = department.ID,
                    Name     = department.Name,
                    Location = department.Location
                };

                db.tblDepartments.Add(tblDepartment);
                int save = db.SaveChanges();
            }

            return(CreatedAtRoute("DefaultApi", new { id = depId }, department));
        }
        public ActionResult Save(tblDepartment department)
        {
            if (!ModelState.IsValid)
            {
                return(View("DepartmentForm"));
            }

            if (department.d_ID == 0)
            {
                department.d_IsActive = true;
                db.tblDepartment.Add(department);
            }

            else
            {
                var upDepartment = db.tblDepartment.Find(department.d_ID);
                if (upDepartment == null)
                {
                    return(HttpNotFound());
                }

                upDepartment.d_Name = department.d_Name;
            }

            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
 public bool InsertDepartment(CollegeModel collegeModel)
 {
     try
     {
         tblDepartment check = new tblDepartment();
         check = _unitOfWork.DepartmentRepository.Get(prop => prop.DepartmentCode == collegeModel.DepartmentCode).FirstOrDefault();
         Guid newGuid = Guid.NewGuid();
         if (check == null)
         {
             tblDepartment entity = new tblDepartment()
             {
                 DepartmentID   = newGuid,
                 DepartmentCode = collegeModel.DepartmentCode,
                 DepartmentName = collegeModel.DepartmentName,
                 CollegeId      = collegeModel.CollegeID,
                 TotalSem       = collegeModel.TotalSem,
                 IsDeleted      = false
             };
             _unitOfWork.DepartmentRepository.Insert(entity);
             _unitOfWork.Save();
             return(true);
         }
         else
         {
             return(false);
         }
     }
     catch (Exception e)
     {
         string currentFile = new System.Diagnostics.StackTrace(true).GetFrame(0).GetFileName();
         ErrorLogger.LogException(e, currentFile);
         CollegeModel college = new CollegeModel();
         return(false);
     }
 }
Example #6
0
        public IActionResult IsAvailable([FromBody] tblDepartment _dep)
        {
            if (_dep.Id == 0)
            {
                var Check = _context.tblDepartment.Where(x => x.DepartmentName == _dep.DepartmentName).Count();

                if (Check > 0)
                {
                    return(Json(false));
                }
                else
                {
                    return(Json(true));
                }
            }
            else
            {
                var Check = _context.tblDepartment.Where(x => x.DepartmentName == _dep.DepartmentName && x.Id != _dep.Id).Count();

                if (Check > 0)
                {
                    return(Json("Department Already Exist"));
                }
                else
                {
                    return(Json(true));
                }
            }
        }
Example #7
0
        public async Task <IActionResult> Edit(int id, [Bind("Id,DepartmentName")] tblDepartment tblDepartment)
        {
            if (id != tblDepartment.Id)
            {
                return(NotFound());
            }

            if (ModelState.IsValid)
            {
                try
                {
                    _context.Update(tblDepartment);
                    await _context.SaveChangesAsync();
                }
                catch (DbUpdateConcurrencyException)
                {
                    if (!tblDepartmentExists(tblDepartment.Id))
                    {
                        return(NotFound());
                    }
                    else
                    {
                        throw;
                    }
                }
                return(RedirectToAction(nameof(Index)));
            }
            return(View(tblDepartment));
        }
 public static List <StudentHistoryModel> GetStudentHistory(Guid id)
 {
     try
     {
         List <StudentHistoryModel>      modelList         = new List <StudentHistoryModel>();
         IEnumerable <tblStudentHistory> historyEntityList = new List <tblStudentHistory>();
         historyEntityList = from ordered in _unitOfWork.StudentHistoryRepository.Get(filter: prop => prop.StudentID == id)
                             orderby ordered.Semester descending
                             select ordered;
         foreach (var history in historyEntityList)
         {
             tblCollege collegeEntity = new tblCollege();
             collegeEntity = _unitOfWork.CollegeRepository.Get(filter: prop => prop.CollegeID == history.CollegeID).FirstOrDefault();
             tblDepartment departmentEntity = new tblDepartment();
             departmentEntity = _unitOfWork.DepartmentRepository.Get(filter: prop => prop.DepartmentID == history.DepartmentID).FirstOrDefault();
             StudentHistoryModel newHistory = new StudentHistoryModel()
             {
                 StudentID      = history.StudentID,
                 CollegeName    = collegeEntity.CollegeName,
                 DepartmentName = departmentEntity.DepartmentName,
                 Semester       = history.Semester,
                 DateOfJoining  = history.DateOfJoining
             };
             modelList.Add(newHistory);
         }
         return(modelList);
     }
     catch (Exception e)
     {
         string currentFile = new System.Diagnostics.StackTrace(true).GetFrame(0).GetFileName();
         ErrorLogger.LogException(e, currentFile);
         List <StudentHistoryModel> modelList = new List <StudentHistoryModel>();
         return(modelList);
     }
 }
Example #9
0
        public int DeleteDepartment(int id)
        {
            tblDepartment department = _db.tblDepartments.Where(u => u.Id == id).FirstOrDefault();

            department.IsDeleted = true;
            //_db.tblDepartments.Remove(department);
            return(_db.SaveChanges());
        }
        Department fillDomainModel(tblDepartment objtbDepartment)
        {
            Department objDepartment = new Department();

            objDepartment.Id   = objtbDepartment.DeptId;
            objDepartment.Name = objtbDepartment.DeptName;

            return(objDepartment);
        }
        tblDepartment fillEntityModel(Department dept)
        {
            tblDepartment objTblDepartment = new tblDepartment();

            objTblDepartment.DeptId   = dept.Id;
            objTblDepartment.DeptName = dept.Name;

            return(objTblDepartment);
        }
Example #12
0
 public ActionResult Update(tblDepartment department)
 {
     if (ModelState.IsValid)
     {
         db.Entry(department).State = EntityState.Modified;
         db.SaveChanges();
     }
     return(Json(department, JsonRequestBehavior.AllowGet));
 }
Example #13
0
 public ActionResult Create([Bind(Exclude = "DeptCode")] tblDepartment department)
 {
     if (ModelState.IsValid)
     {
         db.tblDepartments.Add(department);
         db.SaveChanges();
     }
     return(Json(department, JsonRequestBehavior.AllowGet));
 }
Example #14
0
        public ActionResult AddOrEdit(DepartmentViewModel dvm)
        {
            using (Entities db = new Entities())
            {
                if (dvm.DepartmentId == 0)
                {
                    tblDepartment itm = new tblDepartment();

                    // itm.StudentId = Convert.ToInt32(dvm.StudentId);
                    itm.DepartmentName = dvm.DepartmentName;
                    itm.ReportId       = dvm.ReportId;
                    itm.TeacherId      = dvm.TeacherId;

                    //HttpPostedFileBase fup = Request.Files["Photo"];
                    //if (fup != null)
                    //{
                    //    if (fup.FileName != "")
                    //    {
                    //        fup.SaveAs(Server.MapPath("~/ProductImages/" + fup.FileName));
                    //        itm.Photo = fup.FileName;
                    //    }
                    //}



                    db.tblDepartments.Add(itm);
                    db.SaveChanges();
                    ViewBag.Message = "Updated Successfully";
                }
                else
                {
                    tblDepartment itm = db.tblDepartments.Where(i => i.DepartmentId == dvm.DepartmentId).FirstOrDefault();
                    // itm.StudentId = Convert.ToInt32(dvm.StudentId);
                    itm.DepartmentName = dvm.DepartmentName;
                    itm.ReportId       = dvm.ReportId;
                    itm.TeacherId      = dvm.TeacherId;

                    //HttpPostedFileBase fup = Request.Files["SmallImage"];
                    //if (fup != null)
                    //{
                    //    if (fup.FileName != "")
                    //    {
                    //        fup.SaveAs(Server.MapPath("~/ProductImages/" + fup.FileName));
                    //        itm.Photo = fup.FileName;
                    //    }
                    //}



                    db.SaveChanges();
                    ViewBag.Message = "Updated Successfully";
                }
                ViewBag.Students = db.tblStudents.ToList();
                return(View(new DepartmentViewModel()));
            }
        }
Example #15
0
 public ActionResult Edit([Bind(Include = "Id,DepartmentName")] tblDepartment tblDepartment)
 {
     if (ModelState.IsValid)
     {
         db.Entry(tblDepartment).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     return(View(tblDepartment));
 }
Example #16
0
        public tblDepartment AddDep(int departmentid, string departmentname)
        {
            var dep = new tblDepartment()
            {
                DepartmentId   = departmentid,
                DepartmentName = departmentname,
            };

            return(dep);
        }
Example #17
0
 public ActionResult Delete(int id)
 {
     using (Entities db = new Entities())
     {
         tblDepartment sm = db.tblDepartments.Where(x => x.DepartmentId == id).FirstOrDefault();
         db.tblDepartments.Remove(sm);
         db.SaveChanges();
         return(Json(new { success = true, message = "Deleted Successfully" }, JsonRequestBehavior.AllowGet));
     }
 }
Example #18
0
        public ActionResult Create([Bind(Include = "DepartmentName")] tblDepartment tblDepartment)
        {
            if (ModelState.IsValid)
            {
                db.tblDepartments.Add(tblDepartment);
                db.SaveChanges();
                return(RedirectToAction("Index"));
            }

            return(View(tblDepartment));
        }
Example #19
0
        // GET: Employee
        public ActionResult Index(string searching)
        {
            DataTable          dt     = new DataTable();
            List <tblEmployee> tblEmp = new List <tblEmployee>();

            using (SqlConnection con = new SqlConnection(connectionString))
            {
                string         query = "Select * from tblEmployee";
                SqlDataAdapter sda   = new SqlDataAdapter(query, con);
                sda.Fill(dt);
            }
            foreach (DataRow row in dt.Rows)
            {
                tblEmployee emp = new tblEmployee();
                emp.EmployeeId   = Convert.ToInt32(row["EmployeeId"]);
                emp.Name         = Convert.ToString(row["Name"]);
                emp.Gender       = Convert.ToString(row["Gender"]);
                emp.City         = Convert.ToString(row["City"]);
                emp.DepartmentId = Convert.ToInt32(row["DepartmentId"]);
                tblEmp.Add(emp);
            }
            DataTable dtDept = new DataTable();

            using (SqlConnection con = new SqlConnection(connectionString))
            {
                string         query   = "Select * from tblDepartment";
                SqlDataAdapter sdaDept = new SqlDataAdapter(query, con);
                sdaDept.Fill(dtDept);
            }
            List <tblDepartment> lstDept = new List <tblDepartment>();

            foreach (DataRow row in dtDept.Rows)
            {
                tblDepartment dept = new tblDepartment();
                dept.Id   = Convert.ToInt32(row["Id"]);
                dept.Name = Convert.ToString(row["Name"]);

                lstDept.Add(dept);
            }
            ViewBag.empdata = lstDept;

            if (!string.IsNullOrEmpty(searching))
            {
                int a = (from e in lstDept
                         where e.Name == searching
                         select e.Id).FirstOrDefault();


                tblEmp = tblEmp.Where(emp => emp.DepartmentId.Equals(a)).ToList();
            }

            return(View(tblEmp));
        }
Example #20
0
        public ActionResult GetDataById(int deptId)
        {
            tblDepartment mDepartment = new tblDepartment();
            var           efData      = db.tblDepartments.Where(x => x.Id == deptId).FirstOrDefault();

            if (efData != null)
            {
                mDepartment.Name = efData.Name;
                mDepartment.Id   = efData.Id;
            }
            return(Json(mDepartment));
        }
Example #21
0
        public int UpdateDepartment(BODepartment model)
        {
            tblDepartment department = _db.tblDepartments.Where(u => u.Id == model.Id).FirstOrDefault();

            department.phone       = model.phone;
            department.Email       = model.Email;
            department.Details     = model.Details;
            department.Name        = model.Name;
            department.LastUpdated = DateTime.Now.ToString();
            department.HOD         = model.HOD;
            return(_db.SaveChanges());
        }
 public string POST(tblDepartment dep)
 {
     try
     {
         db.tblDepartments.Add(dep);
         db.SaveChanges();
         return("Added successfully");
     }
     catch (Exception)
     {
         return("Failed to add");
     }
 }
        public IHttpActionResult DeletetblDepartment(int id)
        {
            tblDepartment tblDepartment = db.tblDepartments.Find(id);

            if (tblDepartment == null)
            {
                return(NotFound());
            }

            db.tblDepartments.Remove(tblDepartment);
            db.SaveChanges();

            return(Ok(tblDepartment));
        }
Example #24
0
        public ActionResult Edit(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            tblDepartment tblDepartment = db.tblDepartments.Find(id);

            if (tblDepartment == null)
            {
                return(HttpNotFound());
            }
            return(View(tblDepartment));
        }
        private void btnView_Click(object sender, RoutedEventArgs e)
        {
            try
            {
                object        rowDep = lupeditDep.SelectedItem;
                tblDepartment iDep   = (tblDepartment)rowDep;
                object        rowSec = lupeditSec.SelectedItem;
                tblSection    iSec   = (tblSection)rowSec;
                object        rowGro = lupeditGroup.SelectedItem;
                tblGroup      iGro   = (tblGroup)rowGro;
                if (colFromDate.DateTime != null && colToDate.DateTime != null)
                {
                    int depID = -1;
                    if (iDep != null)
                    {
                        depID = iDep.DepartmentID;
                    }
                    int secID = -1;
                    if (iSec != null)
                    {
                        secID = iSec.SectionID;
                    }
                    int groID = -1;
                    if (iGro != null)
                    {
                        groID = iGro.GroupID;
                    }
                    string empID = "-1";
                    if (txtEmpId.GetID().EmployeeID != null)
                    {
                        empID = txtEmpId.GetID().EmployeeID;
                    }
                    websv.CheckTimeListAsync(colFromDate.DateTime, colToDate.DateTime, depID, secID, groID, empID, ckbNormal.IsChecked.Value, ckbNoTimeInHasTimeOut.IsChecked.Value, ckbHasTimeInNoTimeOut.IsChecked.Value, ckbNoTimeInNoTimeOut.IsChecked.Value, ckbWorkOnHoliday.IsChecked.Value, ckbLeave.IsChecked.Value, ckbHoliday.IsChecked.Value, 3);
                    //panelThietLap.Closed = true;
                    gridCheckTimeList.View.ShowTotalSummary      = true;
                    gridCheckTimeList.View.ShowFixedTotalSummary = true;

                    tblView.SelectAll();
                    //lblTest.Content = gridCheckTimeList.VisibleRowCount.ToString();
                    //hide panel
                    Layout1.DockController.Hide(panelThietLap);
                    gridCheckTimeList.Focus();
                }
            }
            catch (Exception)
            {
                throw new Exception();
            }
        }
Example #26
0
        public BODepartment GetDepartmentById(int id)
        {
            tblDepartment model      = _db.tblDepartments.Where(u => u.Id == id).FirstOrDefault();
            BODepartment  department = new BODepartment();

            department.CompanyId  = model.CompanyId;
            department.lstCompany = blcompany.GetCompanyById(model.CompanyId.Value);
            department.phone      = model.phone;
            department.Details    = model.Details;
            department.Email      = model.Email;
            department.Id         = model.Id;
            department.Name       = model.Name;
            department.HOD        = model.HOD;
            return(department);
        }
Example #27
0
        public int CreateDepartment(BODepartment model)
        {
            tblDepartment department = new tblDepartment();

            department.CompanyId = model.CompanyId;
            department.phone     = model.phone;
            department.Email     = model.Email;
            department.Details   = model.Details;
            department.IsDeleted = false;
            department.Name      = model.Name;
            department.CreatedAt = DateTime.Now.ToString();
            department.HOD       = model.HOD;
            _db.tblDepartments.Add(department);
            return(_db.SaveChanges());
        }
Example #28
0
        public JsonResult Delete(tblDepartment _dep)
        {
            try
            {
                var _resp = db.tblDepartments.Where(x => x.Id == _dep.Id).SingleOrDefault();
                db.tblDepartments.Remove(_resp);
                db.SaveChanges();

                return(Json(200, JsonRequestBehavior.AllowGet));
            }
            catch (Exception ex)
            {
                return(Json(300, JsonRequestBehavior.AllowGet));
            }
        }
        public string Delete(int id)
        {
            try
            {
                tblDepartment tb = db.tblDepartments.Where(a => a.DepartmentId == id).FirstOrDefault();
                db.tblDepartments.Remove(tb);

                db.SaveChanges();
                return("Deleted successfully");
            }
            catch (Exception)
            {
                return("Failed to delete");
            }
        }
Example #30
0
        public JsonResult Delete([FromBody] tblDepartment _dep)
        {
            try
            {
                var _resp = _context.tblDepartment.Where(x => x.Id == _dep.Id).SingleOrDefault();
                _context.tblDepartment.Remove(_resp);
                _context.SaveChanges();

                return(Json(200));
            }
            catch (Exception ex)
            {
                return(Json(300));
            }
        }
 partial void InserttblDepartment(tblDepartment instance);
 partial void UpdatetblDepartment(tblDepartment instance);
 partial void DeletetblDepartment(tblDepartment instance);