public IEnumerable <OfficeDTOs> GetClildOfficeListByEmpCode(int Empcode) { OfficeDTOs office = new OfficeDTOs(); var conn = DbConnectHelper.GetConnection(); conn.Open(); SqlCommand cmd = new SqlCommand("sp_MyRoleOfficesList", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@EmpCode", Empcode); SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); da.Dispose(); cmd.Dispose(); conn.Close(); conn.Dispose(); foreach (DataRow dr in dt.Rows) { yield return(new OfficeDTOs { OfficeId = Convert.ToInt32(dr["ChildOfficeId"].ToString()), OfficeName = dr["ChildOfficeName"].ToString() }); } }
public OfficeDTOs InsertOffice(OfficeDTOs data) { Office off = OfficeRequestFormatter.ConvertRespondentInfoFromDTO(data); Office Offices = _unitOfWork.OfficeRepository.GetById(data.OfficeId); return(OfficeRequestFormatter.ConvertRespondentInfoToDTO(_unitOfWork.OfficeRepository.Create(off))); }
public ActionResult BranchCreate(OfficeDTOs data) { //if (!ViewBag.AllowCreate) //{ // ViewBag.Error = "You are not Authorize to use this Page"; // return PartialView("_partialviewNotFound"); //} OfficeDTOs officeData = new OfficeDTOs(); try { ViewBag.officeList = _officeService.GetOfficeData(); ViewBag.officeTypeList = _officeTypeService.GetOfficeTypes(); officeData.EmployeeList = _officeService.GetEmployeeList(); officeData.RemoteList = _officeService.GetRemoteList(); OfficeDTOs resOfficeDTO = new OfficeDTOs(); resOfficeDTO = _officeService.InsertOffice(data); ViewBag.success = String.Format("New Branch Added"); ModelState.Clear(); return(View(officeData)); } catch (Exception Ex) { ViewBag.error = Ex.Message; return(View(officeData)); } }
public int UpdateDarbandi(OfficeDTOs data) { Office off = OfficeRequestFormatter.ConvertRespondentInfoFromDTO(data); var response = _unitOfWork.OfficeRepository.Update(off); _unitOfWork.Save(); return(response); }
public ActionResult BranchEdit(int officeId) { ViewBag.officeList = _officeService.GetOfficeData(); ViewBag.officeTypeList = _officeTypeService.GetOfficeTypes(); OfficeDTOs officebyID = _officeService.GetOfficeById(officeId); officebyID.EmployeeList = _officeService.GetEmployeeList(); officebyID.RemoteList = _officeService.GetRemoteList(); return(View(officebyID)); }
public ActionResult BranchEdit(OfficeDTOs data) { OfficeDTOs officeData = new OfficeDTOs(); ViewBag.officeList = _officeService.GetOfficeData(); ViewBag.officeTypeList = _officeTypeService.GetOfficeTypes(); officeData.EmployeeList = _officeService.GetEmployeeList(); officeData.RemoteList = _officeService.GetRemoteList(); int reOffice = _officeService.UpdateDarbandi(data); ViewBag.success = String.Format("Darbandi Updated"); ModelState.Clear(); return(View(officeData)); }
public ActionResult BranchCreate() { //if (!ViewBag.AllowCreate) //{ // ViewBag.Error = "You are not Authorize to use this Page"; // return PartialView("_partialviewNotFound"); //} ViewBag.officeList = _officeService.GetOfficeData(); ViewBag.officeTypeList = _officeTypeService.GetOfficeTypes(); OfficeDTOs officeData = new OfficeDTOs(); officeData.EmployeeList = _officeService.GetEmployeeList(); officeData.RemoteList = _officeService.GetRemoteList(); return(View(officeData)); }
public string GetOfficeName(int officeId) { if (officeId == 0) { return("Head Office"); } OfficeDTOs office = new OfficeDTOs(); var conn = DbConnectHelper.GetConnection(); conn.Open(); SqlCommand cmd = new SqlCommand("SELECt OfficeName FROM Offices WHERE OfficeId = '" + officeId + "'", conn); cmd.CommandType = CommandType.Text; cmd.Parameters.AddWithValue("@officeId", officeId); SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); da.Dispose(); cmd.Dispose(); conn.Close(); conn.Dispose(); return(dt.Rows[0]["officeName"].ToString()); }
public static Office ConvertRespondentInfoFromDTO(OfficeDTOs officeDTO) { Mapper.CreateMap <OfficeDTOs, Office>().ConvertUsing( m => { return(new Office { OfficeGeoLocation = m.OfficeGeoLocation, OfficeAddress = m.OfficeAddress, OfficeCode = m.OfficeCode, OfficeId = m.OfficeId, OfficeName = m.OfficeName, OfficeParentId = m.OfficeParentId, OfficePhone = m.OfficePhone, OfficeStatus = m.OfficeStatus, OfficeTypeId = m.OfficeTypeId, IsActive = m.IsActive, OfficeLocationId = m.OfficeLocationId, PayrollRemmoteSetupRemoteId = m.PayrollRemmoteSetupRemoteId, OfficeHeadEmpCode = m.OfficeHeadEmpCode }); }); return(Mapper.Map <OfficeDTOs, Office>(officeDTO)); }