public List <DDCOST_CENT_MAST> GetCostCentreMasterDetailsByCode(DDCOST_CENT_MAST paramEntity = null)
{
List <DDCOST_CENT_MAST> lstEntity = null;
try
{
if (!DB.IsNotNullOrEmpty())
{
return(lstEntity);
}
if (paramEntity.IsNotNullOrEmpty() && paramEntity.COST_CENT_CODE.IsNotNullOrEmpty())
{
lstEntity = (from row in DB.DDCOST_CENT_MAST
where (Convert.ToBoolean(Convert.ToInt16(row.DELETE_FLAG)) == false || row.DELETE_FLAG == null) && row.COST_CENT_CODE == paramEntity.COST_CENT_CODE
select row).ToList <DDCOST_CENT_MAST>();
}
else
{
lstEntity = (from row in DB.DDCOST_CENT_MAST
where (Convert.ToBoolean(Convert.ToInt16(row.DELETE_FLAG)) == false || row.DELETE_FLAG == null)
select row).ToList <DDCOST_CENT_MAST>();
}
}
catch (Exception ex)
{
ex.LogException();
}
return(lstEntity);
}
/// <summary>
///
///
/// </summary>
/// <param name="costCenterMaster"></param>
/// <param name="mode"></param>
/// <returns></returns>
public bool SaveCostCenterMaster(CostCenterMaster costCenterMaster, OperationMode opermode)
{
DDCOST_CENT_MAST ddCC = null;
bool insert = false;
bool update = false;
bool submit = false;
try
{
ddCC = new DDCOST_CENT_MAST();
if (opermode == OperationMode.AddNew)
{
ddCC = new DDCOST_CENT_MAST();
}
else
{
ddCC = (from c in DB.DDCOST_CENT_MAST
where c.COST_CENT_CODE == costCenterMaster.CostCentCode
select c).Single <DDCOST_CENT_MAST>();
}
ddCC.COST_CENT_CODE = costCenterMaster.CostCentCode;
ddCC.COST_CENT_DESC = costCenterMaster.CostCentDesc;
ddCC.CATE_CODE = costCenterMaster.CateCode;
ddCC.LOC_CODE = costCenterMaster.LocCode;
ddCC.MODULE = costCenterMaster.Module;
ddCC.EFFICIENCY = Convert.ToDecimal(costCenterMaster.Efficiency);
ddCC.MACHINE_NAME = costCenterMaster.MachineName;
ddCC.DELETE_FLAG = false;
if (opermode == OperationMode.AddNew)
{
ddCC.ENTERED_BY = userInformation.UserName;
ddCC.ENTERED_DATE = serverDateTime;
insert = true;
DB.DDCOST_CENT_MAST.InsertOnSubmit(ddCC);
}
else
{
ddCC.UPDATED_BY = userInformation.UserName;
ddCC.UPDATED_DATE = serverDateTime;
update = true;
}
submit = true;
DB.SubmitChanges();
SaveCostDetails(costCenterMaster);
return(true);
}
catch (Exception ex)
{
if (submit == true)
{
if (update == true)
{
DB.DDCOST_CENT_MAST.Context.Refresh(System.Data.Linq.RefreshMode.OverwriteCurrentValues, ddCC);
}
if (insert == true)
{
DB.DDCOST_CENT_MAST.DeleteOnSubmit(ddCC);
}
}
throw ex.LogException();
}
}
