public ResultHelper AddSubUnit(SubUnitDto subUnitDto)
{
try
{
if (IsThere(subUnitDto))
{
return(new ResultHelper(false, subUnitDto.SubUnitID, ResultHelper.IsThereItem));
}
subunit item = new subunit();
item.SubUnitID = subUnitDto.SubUnitID;
item.MainUnitID = subUnitDto.MainUnitID;
item.Name = subUnitDto.Name;
using (UnitOfWork unitofWork = new UnitOfWork())
{
unitofWork.GetRepository <subunit>().Insert(item);
unitofWork.saveChanges();
return(new ResultHelper(true, item.SubUnitID, ResultHelper.SuccessMessage));
}
}
catch (Exception ex)
{
return(new ResultHelper(false, subUnitDto.SubUnitID, ResultHelper.UnSuccessMessage));
}
}
public List <SubUnitDto> GetAllSubUnit()
{
try
{
List <SubUnitDto> sDtoList = new List <SubUnitDto>();
using (UnitOfWork unitOfWork = new UnitOfWork())
{
var subUnits = from s in unitOfWork.GetRepository <subunit>().Select(null, null)
join m in unitOfWork.GetRepository <mainunit>().Select(null, null) on s.MainUnitID equals m.MainUnitID
select new
{
SubUnitID = s.SubUnitID,
SName = s.Name,
MainUnitID = m.MainUnitID,
MainUnitName = m.Name
};
foreach (var item in subUnits)
{
SubUnitDto sDto = new SubUnitDto();
sDto.SubUnitID = item.SubUnitID;
sDto.Name = item.SName;
sDto.MainUnitID = item.MainUnitID;
sDto.MainUnitDto = new MainUnitDto();
sDto.MainUnitDto.MainUnitID = item.MainUnitID;
sDto.MainUnitDto.Name = item.MainUnitName;
sDtoList.Add(sDto);
}
return(sDtoList);
}
}
catch (Exception ex)
{
return(new List <SubUnitDto>());
}
}
public ActionResult Edit(SubUnitDto model)
{
ResultHelper result = JsonConvert.DeserializeObject <ResultHelper>(subUnitService.SetSubUnit(model));
GetMainUnits();
ViewBag.Message = Helper.GetResultMessage(result.Result, result.ResultDescription);
return(View());
}
public bool IsThere(SubUnitDto subUnitDto)
{
using (UnitOfWork unitofWork = new UnitOfWork())
{
var item = unitofWork.GetRepository <subunit>().GetById(x => x.Name.ToUpper() == subUnitDto.Name.ToUpper());
if (item != null)
{
return(true);
}
else
{
return(false);
}
}
}
public SubUnitDto GetSubUnit(int subUnitID)
{
try
{
using (UnitOfWork unitofWork = new UnitOfWork())
{
subunit item = new subunit();
item = unitofWork.GetRepository <subunit>().GetById(x => x.SubUnitID == subUnitID);
SubUnitDto subUnitDto = new SubUnitDto();
subUnitDto.SubUnitID = item.SubUnitID;
subUnitDto.Name = item.Name;
subUnitDto.MainUnitID = (int)item.MainUnitID;
return(subUnitDto);
}
}
catch (Exception)
{
return(null);
}
}
public List <SubUnitDto> GetAllWithByMainUnitID(int mainUnitID)
{
try
{
List <SubUnitDto> sDtoList = new List <SubUnitDto>();
using (UnitOfWork unitOfWork = new UnitOfWork())
{
var list = unitOfWork.GetRepository <subunit>().Select(null, null).Where(a => a.MainUnitID == mainUnitID).ToList();
foreach (var item in list)
{
SubUnitDto sDto = new SubUnitDto();
sDto.SubUnitID = item.SubUnitID;
sDto.MainUnitID = item.MainUnitID.Value;
sDto.Name = item.Name;
sDtoList.Add(sDto);
}
return(sDtoList);
}
}
catch (Exception ex)
{
return(new List <SubUnitDto>());
}
}
public string SetSubUnit(SubUnitDto subUnitDto)
{
return(JsonConvert.SerializeObject(subUnitLogic.SetSubUnit(subUnitDto)));
}
