//
// GET: /WorkflowSettings/Details/5
public ActionResult Details(int id)
{
var model = AutoMapper.Mapper.Map <WorkflowDetails>(_pageBLL.GetPageByID(id));
model.CurrentMenu = PageInfo;
model.MainMenu = _mainMenu;
model.Details = AutoMapper.Mapper.Map <List <WorkflowMappingDetails> >(_workflowSettingBLL.GetAllByFormId(id));
return(View(model));
}
public MasterDataApprovalSettingDto GetAllEditableColumn(int pageId)
{
var page = _pageBLL.GetPageByID(pageId);
var tableDetails = _repository.GetTableDetail(page.MAIN_TABLE);
Expression <Func <MASTER_DATA_APPROVE_SETTING, bool> > queryFilter = PredicateHelper.True <MASTER_DATA_APPROVE_SETTING>();
queryFilter = queryFilter.And(c => c.PAGE_ID == page.PAGE_ID);
var masterDataSettings = _repository.Get(queryFilter, null, includeTables).ToList();
var rc = Mapper.Map <MasterDataApprovalSettingDto>(page);
foreach (var table in tableDetails)
{
var detail = Mapper.Map <MasterDataApprovalSettingDetail>(table);
var isApproval = masterDataSettings.Where(x => x.COLUMN_NAME == detail.COLUMN_NAME).Select(x => x.IS_APPROVAL).FirstOrDefault();
detail.IsPrimary = table.IsUniquePrimaryKey;
if (table.IsUniquePrimaryKey)
{
detail.IS_APPROVAL = true;
}
else
{
if (pageId == (int)Core.Enums.MenuList.POAMap)
{
if (!table.IsNullable)
{
detail.IS_APPROVAL = true;
detail.IsPrimary = true;
}
else
{
detail.IS_APPROVAL = isApproval;
}
}
else
{
detail.IS_APPROVAL = isApproval;
}
}
detail.PAGE_ID = page.PAGE_ID;
if (detail.ColumnDescription != null)
{
rc.Details.Add(detail);
}
}
if (pageId == (int)Core.Enums.MenuList.MaterialMaster)
{
rc.Details.Add(new MasterDataApprovalSettingDetail()
{
COLUMN_NAME = "CONVERTION",
ColumnDescription = "Convertion",
IS_APPROVAL = true,
IsPrimary = true,
PAGE_ID = pageId
});
}
return(rc);
}
public List <MASTER_DATA_APPROVAL_DETAIL> GetObjectDetails(string formId, int pageId)
{
PropertyInfo propInfo;
var page = _pageBLL.GetPageByID(pageId);
var tableDetails = _repository.GetTableDetail(page.MAIN_TABLE);
var returnDetails = new List <MASTER_DATA_APPROVAL_DETAIL>();
object data = null;
if (pageId == (int)Enums.MenuList.BrandRegistration)
{
var tempId = formId.Split('-');
var werks = tempId[0];
var facode = tempId[1];
var stickerCode = tempId[2];
data = _brandRegistrationBLL.GetByPlantIdAndFaCodeStickerCode(werks, facode, stickerCode);
}
else if (pageId == (int)Enums.MenuList.POA)
{
data = _poaBll.GetById(formId);
}
else if (pageId == (int)Enums.MenuList.POAMap)
{
var tempId = formId.Split('-');
var poaId = tempId[0];
var nppbkc = tempId[1];
var plantid = tempId[2];
data = _poaMapBLL.GetByNppbckId(nppbkc, plantid, poaId);
}
else if (pageId == (int)Enums.MenuList.MaterialMaster)
{
var tempId = formId.Split('-');
var werks = tempId[0];
var materialnumber = tempId[1];
var tempdata = _materialBLL.GetByMaterialAndPlantId(materialnumber, werks);
data = Mapper.Map <MaterialDto>(tempdata);
}
if (data != null)
{
foreach (var detail in tableDetails)
{
if (detail.Documentation == null)
{
continue;
}
var detailTable = new MASTER_DATA_APPROVAL_DETAIL();
//propInfo = typeof(ZAIDM_EX_BRAND).GetProperty(detail.PropertyName);
detailTable.COLUMN_NAME = detail.PropertyName;
detailTable.COLUMN_DESCRIPTION = detail.Documentation.LongDescription;
var propValue = data.GetType().GetProperty(detail.PropertyName).GetValue(data);
if (propValue != null)
{
detailTable.OLD_VALUE = propValue.ToString();
}
else
{
detailTable.OLD_VALUE = string.Empty;
}
returnDetails.Add(detailTable);
}
if (pageId == (int)Enums.MenuList.MaterialMaster)
{
returnDetails.Add(new MASTER_DATA_APPROVAL_DETAIL()
{
COLUMN_NAME = "CONVERTION",
COLUMN_DESCRIPTION = "Convertion",
OLD_VALUE = ((MaterialDto)data).CONVERTION
});
}
if (pageId == (int)Core.Enums.MenuList.BrandRegistration)
{
var dataBrand = (ZAIDM_EX_BRAND)data;
var dataMaterial = _materialBLL.GetByMaterialAndPlantId(dataBrand.FA_CODE, dataBrand.WERKS);
returnDetails.Add(new MASTER_DATA_APPROVAL_DETAIL()
{
COLUMN_NAME = "BRAND_CE",
COLUMN_DESCRIPTION = "Brand Description (SAP)",
OLD_VALUE = dataMaterial.MATERIAL_DESC
});
}
}
return(returnDetails);
}