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));
}
