public bool Delete <T>(List <T> entities)
{
bool returnValue = false;
foreach (T entity in entities)
{
if ((entity as DDRM_MAST).IsNotNullOrEmpty())
{
DDRM_MAST obj = null;
DDRM_MAST activeEntity = (entity as DDRM_MAST);
try
{
obj = (from row in DB.DDRM_MAST
where row.IDPK == activeEntity.IDPK
select row).SingleOrDefault <DDRM_MAST>();
if (obj.IsNotNullOrEmpty())
{
obj.RM_CODE = activeEntity.RM_CODE;
obj.RM_DESC = activeEntity.RM_DESC;
obj.LOC_COST = activeEntity.LOC_COST;
obj.EXP_COST = activeEntity.EXP_COST;
obj.DELETE_FLAG = true;
obj.UPDATED_BY = userInformation.UserName;
obj.UPDATED_DATE = serverDateTime;
DB.DDRM_MAST.DeleteOnSubmit(obj);
returnValue = true;
}
}
catch (ChangeConflictException)
{
foreach (ObjectChangeConflict conflict in DB.ChangeConflicts)
{
conflict.Resolve(RefreshMode.KeepChanges);
}
}
catch (Exception ex)
{
ex.LogException();
DB.DDRM_MAST.Context.Refresh(System.Data.Linq.RefreshMode.OverwriteCurrentValues, obj);
}
}
if ((entity as DDRM_SIZE_MAST).IsNotNullOrEmpty())
{
DDRM_SIZE_MAST objChild = null;
DDRM_SIZE_MAST activeEntityChild = (entity as DDRM_SIZE_MAST);
try
{
objChild = (from row in DB.DDRM_SIZE_MAST
where row.IDPK == activeEntityChild.IDPK
select row).SingleOrDefault <DDRM_SIZE_MAST>();
if (objChild.IsNotNullOrEmpty())
{
objChild.RM_CODE = activeEntityChild.RM_CODE;
objChild.RM_DIA_MIN = activeEntityChild.RM_DIA_MIN;
objChild.RM_DIA_MAX = activeEntityChild.RM_DIA_MAX;
objChild.LOC_CODE = activeEntityChild.LOC_CODE.IsNotNullOrEmpty() ? activeEntityChild.LOC_CODE : "0";
objChild.DELETE_FLAG = false;
objChild.UPDATED_BY = userInformation.UserName;
objChild.UPDATED_DATE = serverDateTime;
DB.DDRM_SIZE_MAST.DeleteOnSubmit(objChild);
returnValue = true;
}
}
catch (ChangeConflictException)
{
foreach (ObjectChangeConflict conflict in DB.ChangeConflicts)
{
conflict.Resolve(RefreshMode.KeepChanges);
}
}
catch (Exception ex)
{
ex.LogException();
DB.DDRM_SIZE_MAST.Context.Refresh(System.Data.Linq.RefreshMode.OverwriteCurrentValues, activeEntityChild);
}
}
}
return(returnValue);
}
public bool Insert <T>(List <T> entities)
{
bool returnValue = false;
foreach (T entity in entities)
{
if ((entity as DDRM_MAST).IsNotNullOrEmpty())
{
DDRM_MAST obj = entity as DDRM_MAST;
try
{
obj.ROWID = Guid.NewGuid();
obj.DELETE_FLAG = false;
obj.ENTERED_BY = userName;
obj.ENTERED_DATE = serverDateTime;
DB.DDRM_MAST.InsertOnSubmit(obj);
DB.SubmitChanges();
DB.Refresh(RefreshMode.OverwriteCurrentValues);
}
catch (ChangeConflictException)
{
foreach (ObjectChangeConflict conflict in DB.ChangeConflicts)
{
conflict.Resolve(RefreshMode.KeepChanges);
}
}
catch (Exception ex)
{
ex.LogException();
DB.DDRM_MAST.DeleteOnSubmit(obj);
}
}
if ((entity as DDRM_SIZE_MAST).IsNotNullOrEmpty())
{
DDRM_SIZE_MAST obj = entity as DDRM_SIZE_MAST;
try
{
if (obj.IDPK == 0)
{
obj.IDPK = GenerateNextNumber("DDRM_SIZE_MAST", "IDPK").ToIntValue();
}
obj.ROWID = Guid.NewGuid();
obj.DELETE_FLAG = false;
obj.ENTERED_BY = userName;
obj.ENTERED_DATE = serverDateTime;
DB.DDRM_SIZE_MAST.InsertOnSubmit(obj);
DB.SubmitChanges();
}
catch (ChangeConflictException)
{
foreach (ObjectChangeConflict conflict in DB.ChangeConflicts)
{
conflict.Resolve(RefreshMode.KeepChanges);
}
}
catch (Exception ex)
{
ex.LogException();
DB.DDRM_SIZE_MAST.DeleteOnSubmit(obj);
}
}
}
returnValue = true;
return(returnValue);
}
