public virtual EFReturnValue SaveHeaderDetail <T, T1, T2, T3, T4, T5>(T tblHeader, string idReferenceColName, T1 tblDetail1, T2 tblDetail2, T3 tblDetail3, T4 tblDetail4, T5 tblDetail5)
where T : class
where T1 : class
where T2 : class
where T3 : class
where T4 : class
where T5 : class
{
object objIDColumnHeader = null; eFReturn = new EFReturnValue {
IsSuccessConnection = false, IsSuccessQuery = false, ErrorMessage = ErrorMessage.EntityCannotBeNull, ReturnValue = null
};
bool resultDetail = false;
if (tblHeader != null & !string.IsNullOrEmpty(idReferenceColName) & tblDetail1 != null)
{
RepoSave repoSave = new RepoSave();
tblHeader = EntityPreparationBantuan.GetInstance.DictEntityPreparation["save"].SetPreparationEntity <T>(tblHeader);
var saveMainTable = repoSave.Save <T>(tblHeader); // Safe first in main table
if (saveMainTable.IsSuccessConnection & saveMainTable.IsSuccessQuery)
{
var propIdColumnHeader = ColumnPropGet.GetInstance.GetIdentityColumnProps <T>();
objIDColumnHeader = propIdColumnHeader != null?propIdColumnHeader.GetValue(tblHeader) : null;
if (objIDColumnHeader != null)
{
ColumnPropSet.GetInstance.SetColValue <T1>(tblDetail1, idReferenceColName, objIDColumnHeader); // set value ref id to tbldetails
ColumnPropSet.GetInstance.SetColValue <T2>(tblDetail2, idReferenceColName, objIDColumnHeader); // set value ref id to tbldetails
ColumnPropSet.GetInstance.SetColValue <T3>(tblDetail3, idReferenceColName, objIDColumnHeader); // set value ref id to tbldetails
ColumnPropSet.GetInstance.SetColValue <T4>(tblDetail4, idReferenceColName, objIDColumnHeader); // set value ref id to tbldetails
ColumnPropSet.GetInstance.SetColValue <T5>(tblDetail5, idReferenceColName, objIDColumnHeader); // set value ref id to tbldetails
tblDetail1 = EntityPreparationBantuan.GetInstance.DictEntityPreparation["save"].SetPreparationEntity <T1>(tblDetail1);
tblDetail2 = EntityPreparationBantuan.GetInstance.DictEntityPreparation["save"].SetPreparationEntity <T2>(tblDetail2);
tblDetail3 = EntityPreparationBantuan.GetInstance.DictEntityPreparation["save"].SetPreparationEntity <T3>(tblDetail3);
tblDetail4 = EntityPreparationBantuan.GetInstance.DictEntityPreparation["save"].SetPreparationEntity <T4>(tblDetail4);
tblDetail5 = EntityPreparationBantuan.GetInstance.DictEntityPreparation["save"].SetPreparationEntity <T5>(tblDetail5);
var saveDetailTable = repoSave.Save <T1, T2, T3, T4, T5>(tblDetail1, tblDetail2, tblDetail3, tblDetail4, tblDetail5);//save to T1
if (resultDetail)
{
eFReturn = eFReturn.SetEFReturnValue(eFReturn, true, 1, tblDetail1, tblDetail2, tblDetail3, tblDetail4, tblDetail5);
}
else
{
RepoDelete repoDelete = new RepoDelete();
repoDelete.Delete <T>(tblHeader);
eFReturn = eFReturn.SetEFReturnValue(eFReturn, false, 0, ErrorMessage.SaveHeaderDetailFailed);
}
}
}
}
return(eFReturn);
}
public virtual EFReturnValue SaveHeaderDetailList <T, T1, T2, T3>(T tblHeader, string idReferenceColName, List <T1> listTblDetail1, List <T2> listTblDetail2, List <T3> listTblDetail3)
where T : class
where T1 : class
where T2 : class
where T3 : class
{
object objIDColumnHeader = null; eFReturn = new EFReturnValue {
IsSuccessConnection = false, IsSuccessQuery = false, ErrorMessage = ErrorMessage.EntityCannotBeNull, ReturnValue = null
};
if (tblHeader != null & !string.IsNullOrEmpty(idReferenceColName) & listTblDetail1 != null)
{
RepoSave repoSave = new RepoSave();
tblHeader = EntityPreparationBantuan.GetInstance.DictEntityPreparation["save"].SetPreparationEntity <T>(tblHeader);
var saveMainTable = repoSave.Save <T>(tblHeader); // Safe first in main table
RepoSaveList repoSaveList = new RepoSaveList();
if (saveMainTable.IsSuccessConnection & saveMainTable.IsSuccessQuery)
{
var propIdColumnHeader = ColumnPropGet.GetInstance.GetIdentityColumnProps <T>();
objIDColumnHeader = propIdColumnHeader != null?propIdColumnHeader.GetValue(tblHeader) : null;
if (objIDColumnHeader != null)
{
ColumnPropSet.GetInstance.SetColValue <List <T1> >(listTblDetail1, idReferenceColName, objIDColumnHeader); // set value ref id to tbldetails
ColumnPropSet.GetInstance.SetColValue <List <T2> >(listTblDetail2, idReferenceColName, objIDColumnHeader); // set value ref id to tbldetails
ColumnPropSet.GetInstance.SetColValue <List <T3> >(listTblDetail3, idReferenceColName, objIDColumnHeader); // set value ref id to tbldetails
listTblDetail1 = EntityPreparationBantuan.GetInstance.DictEntityPreparation["save"].SetPreparationEntity <T1>(listTblDetail1);
listTblDetail2 = EntityPreparationBantuan.GetInstance.DictEntityPreparation["save"].SetPreparationEntity <T2>(listTblDetail2);
listTblDetail3 = EntityPreparationBantuan.GetInstance.DictEntityPreparation["save"].SetPreparationEntity <T3>(listTblDetail3);;
var saveDetailTable = repoSaveList.SaveList <T1, T2, T3>(listTblDetail1, listTblDetail2, listTblDetail3);//save to T1 & others
if (saveDetailTable.IsSuccessConnection & saveDetailTable.IsSuccessQuery)
{
eFReturn = eFReturn.SetEFReturnValue(eFReturn, true, 1, listTblDetail1);
}
else
{
eFReturn = eFReturn.SetEFReturnValue(eFReturn, false, 0, ErrorMessage.SaveHeaderDetailFailed);
RepoDelete repoDelete = new RepoDelete();
repoDelete.Delete <T>(tblHeader);
}
}
}
}
return(eFReturn);
}
