public void CreateMsEntity(GetAllMsEntityListDto input)
{
Logger.InfoFormat("CreateMsEntity() Started.");
Logger.DebugFormat("CreateMsEntity() - Start checking existing entityCode, entityName. Parameters sent: {0} " +
"entityCode = {1}{0}" +
"entityName = {2}{0}"
, Environment.NewLine, input.entityCode, input.entityName);
var checkEntity = (from A in _msEntityRepo.GetAll()
where A.entityCode == input.entityCode || A.entityName == input.entityName
select A).Count();
Logger.DebugFormat("CreateMsEntity() - End checking existing entityCode, entityName. Result = {0}", checkEntity);
if (checkEntity == 0)
{
var createMsEntity = new MS_Entity
{
entityName = input.entityName,
entityCode = input.entityCode
};
try
{
Logger.DebugFormat("CreateMsEntity() - Start Insert Entity. Parameters sent: {0} " +
"entityName = {1}{0}" +
"entityCode = {2}{0}"
, Environment.NewLine, input.entityName, input.entityCode);
_msEntityRepo.Insert(createMsEntity);
CurrentUnitOfWork.SaveChanges();
Logger.DebugFormat("CreateMsEntity() - End Insert Entity. Result = {0}", checkEntity);
}
catch (DataException ex)
{
Logger.DebugFormat("CreateMsEntity() - ERROR DataException. Result = {0}", ex.Message);
throw new UserFriendlyException("Db Error: " + ex.Message);
}
catch (Exception ex)
{
Logger.DebugFormat("CreateMsEntity() - ERROR Exception. Result = {0}", ex.Message);
throw new UserFriendlyException("Error: " + ex.Message);
}
}
else
{
Logger.DebugFormat("CreateMsEntity() - ERROR. Result = {0}", "Entity Code or Entity Name Already Exist !");
throw new UserFriendlyException("Entity Code or Entity Name Already Exist !");
}
Logger.InfoFormat("CreateMsEntity() - Finished.");
}
public void UpdateMsEntity(GetAllMsEntityListDto input)
{
Logger.InfoFormat("UpdateMsEntity() - Started.");
Logger.DebugFormat("UpdateMsEntity() - Start checking existing entityCode, entityName. Parameters sent: {0} " +
"enityID = {1}{0}" +
"entityCode = {2}{0}" +
"entityName = {3}{0}"
, Environment.NewLine, input.Id, input.entityCode, input.entityName);
var checkEntity = (from entity in _msEntityRepo.GetAll()
where entity.Id != input.Id && (entity.entityCode == input.entityCode || entity.entityName == input.entityName)
select entity).Any();
Logger.DebugFormat("UpdateMsEntity() - End checking existing entityCode, entityName. Result = {0}", checkEntity);
var checkMsAccount = (from account in _contextProp.MS_Account
where account.entityID == input.Id
select account).Any();
var checkMsArea = (from area in _contextProp.MS_Area
where area.entityID == input.Id
select area).Any();
var checkMsBank = (from bank in _contextProp.MS_Bank
where bank.entityID == input.Id
select bank).Any();
var checkMsBankBranch = (from bankBranch in _contextProp.MS_BankBranch
where bankBranch.entityID == input.Id
select bankBranch).Any();
var checkMsCategory = (from category in _contextProp.MS_Category
where category.entityID == input.Id
select category).Any();
var checkMsCluster = (from cluster in _contextProp.MS_Cluster
where cluster.entityID == input.Id
select cluster).Any();
var checkMsCompany = (from company in _contextProp.MS_Company
where company.entityID == input.Id
select company).Any();
var checkMsDetail = (from detail in _contextProp.MS_Detail
where detail.entityID == input.Id
select detail).Any();
var checkMsFacade = (from facade in _contextProp.MS_Facade
where facade.entityID == input.Id
select facade).Any();
var checkMsGroupTerm = (from groupTerm in _contextProp.MS_GroupTerm
where groupTerm.entityID == input.Id
select groupTerm).Any();
var checkMsProduct = (from product in _contextProp.MS_Product
where product.entityID == input.Id
select product).Any();
var checkMsProject = (from project in _contextProp.MS_Project
where project.entityID == input.Id
select project).Any();
var checkMsTerm = (from term in _contextProp.MS_Term
where term.entityID == input.Id
select term).Any();
var checkMsTermAddDisc = (from termAdd in _contextProp.MS_TermAddDisc
where termAdd.entityID == input.Id
select termAdd).Any();
var checkMsTermDp = (from termDp in _contextProp.MS_TermDP
where termDp.entityID == input.Id
select termDp).Any();
var checkMsTermMain = (from termMain in _contextProp.MS_TermMain
where termMain.entityID == input.Id
select termMain).Any();
var checkMsTermPmt = (from termPmt in _contextProp.MS_TermPmt
where termPmt.entityID == input.Id
select termPmt).Any();
var checkMsUnit = (from unit in _contextProp.MS_Unit
where unit.entityID == input.Id
select unit).Any();
var checkMsUnitCode = (from unitCode in _contextProp.MS_UnitCode
where unitCode.entityID == input.Id
select unitCode).Any();
var checkMsUnitItem = (from unitItem in _contextProp.MS_UnitItem
where unitItem.entityID == input.Id
select unitItem).Any();
var checkMsUnitItemPrice = (from unitItemPrice in _contextProp.MS_UnitItemPrice
where unitItemPrice.entityID == input.Id
select unitItemPrice).Any();
var checkMsZoning = (from zoning in _msZoningRepo.GetAll()
where zoning.entityID == input.Id
select zoning).Any();
if (!checkEntity)
{
Logger.DebugFormat("UpdateMsEntity() - Start get entity for update. Parameters sent: {0} " +
"enityID = {1}{0}", Environment.NewLine, input.Id);
var getMsEntity = (from A in _msEntityRepo.GetAll()
where input.Id == A.Id
select A).FirstOrDefault();
Logger.DebugFormat("UpdateMsEntity() - End get entity for update. Result = {0}", getMsEntity);
var updateMsentity = getMsEntity.MapTo <MS_Entity>();
if (!checkMsAccount && !checkEntity && !checkMsArea && !checkMsBank && !checkMsBankBranch && !checkMsCategory &&
!checkMsCluster && !checkMsCompany && !checkMsDetail && !checkMsFacade && !checkMsGroupTerm &&
!checkMsProduct && !checkMsProject && !checkMsTerm && !checkMsTermAddDisc && !checkMsTermDp &&
!checkMsTermMain && !checkMsTermPmt && !checkMsUnit && !checkMsUnitCode && !checkMsUnitItem &&
!checkMsUnitItemPrice && !checkMsZoning)
{
updateMsentity.entityName = input.entityName;
updateMsentity.entityCode = input.entityCode;
}
else
{
Logger.DebugFormat("UpdateMsEntity() - This Entity is used in another table. entityId = {0}", input.Id);
throw new UserFriendlyException("This Entity is used !");
}
try
{
Logger.DebugFormat("UpdateMsEntity() - Start update msEntity. Parameters sent: {0} " +
"entityName = {1}{0}" +
"entityCode = {2}{0}", Environment.NewLine, input.entityName, input.entityCode);
_msEntityRepo.Update(updateMsentity);
CurrentUnitOfWork.SaveChanges();
Logger.DebugFormat("UpdateMsEntity() - End update msEntity.");
}
catch (DataException ex)
{
Logger.DebugFormat("UpdateMsEntity() - ERROR DataException. Result = {0}", ex.Message);
throw new UserFriendlyException("Db Error: " + ex.Message);
}
catch (Exception ex)
{
Logger.DebugFormat("UpdateMsEntity() - ERROR Exception. Result = {0}", ex.Message);
throw new UserFriendlyException("Error: " + ex.Message);
}
}
else
{
Logger.DebugFormat("UpdateMsEntity() - ERROR Exception. Result = {0}", "Entity Code or Entity Name Already Exist !");
throw new UserFriendlyException("Entity Code or Entity Name Already Exist !");
}
Logger.InfoFormat("UpdateMsEntity() - Finished.");
}
