public void AddInterface(tbl_Interface tblInterface)
{
try
{
IGenericDataRepository <tbl_Interface> repository = new GenericDataRepository <tbl_Interface>();
repository.Add(tblInterface);
}
catch (Exception)
{
throw;
}
}
//public int SaveDataInterface(IList<tbl_Interface> tblInterface)
//{
// try
// {
// IGenericDataRepository<tbl_Interface> repository = new GenericDataRepository<tbl_Interface>();
// foreach (var item in tblInterface)
// repository.Add(item);
// return 1;
// }
// catch (Exception ex)
// {
// return 0;
// }
//}
public void DeleteInterfaceAttr(int id)
{
try
{
tbl_Interface objtblinterface = new tbl_Interface();
tbl_InterfaceAttrMapping objinterfaceMapping = new tbl_InterfaceAttrMapping();
IGenericDataRepository <tbl_Interface> repository = new GenericDataRepository <tbl_Interface>();
IList <tbl_Interface> lstInterfaceid = repository.GetList(q => q.InterfaceID.Equals(id));
IGenericDataRepository <tbl_InterfaceAttrMapping> repository1 = new GenericDataRepository <tbl_InterfaceAttrMapping>();
if (lstInterfaceid != null)
{
foreach (var item in lstInterfaceid)
{
objtblinterface.daId = item.daId;
objtblinterface.InterfaceAttrMapID = item.InterfaceAttrMapID;
objtblinterface.InterfaceID = item.InterfaceID;
objtblinterface.TransactionSeq = item.TransactionSeq;
objtblinterface.EntityState = EntityState.Deleted;
IList <tbl_InterfaceAttrMapping> lstInterfaceMapId = repository1.GetList(q => q.InterfaceAttrMapID.Equals(item.InterfaceAttrMapID));
if (lstInterfaceMapId != null)
{
foreach (var item1 in lstInterfaceMapId)
{
objinterfaceMapping.AttrID1 = item1.AttrID1;
objinterfaceMapping.AttrID2 = item1.AttrID2;
objinterfaceMapping.AttrID3 = item1.AttrID3;
objinterfaceMapping.AttrID4 = item1.AttrID4;
objinterfaceMapping.AttrID5 = item1.AttrID5;
objinterfaceMapping.AttrID6 = item1.AttrID6;
objinterfaceMapping.AttrID7 = item1.AttrID7;
objinterfaceMapping.AttrID8 = item1.AttrID8;
objinterfaceMapping.AttrID9 = item1.AttrID9;
objinterfaceMapping.AttrID10 = item1.AttrID10;
objinterfaceMapping.AttrValueID1 = item1.AttrValueID1;
objinterfaceMapping.AttrValueID2 = item1.AttrValueID2;
objinterfaceMapping.AttrValueID3 = item1.AttrValueID3;
objinterfaceMapping.AttrValueID4 = item1.AttrValueID4;
objinterfaceMapping.AttrValueID5 = item1.AttrValueID5;
objinterfaceMapping.AttrValueID6 = item1.AttrValueID6;
objinterfaceMapping.AttrValueID7 = item1.AttrValueID7;
objinterfaceMapping.AttrValueID8 = item1.AttrValueID8;
objinterfaceMapping.AttrValueID9 = item1.AttrValueID9;
objinterfaceMapping.AttrValueID10 = item1.AttrValueID10;
objinterfaceMapping.InterfaceAttrMapID = item1.InterfaceAttrMapID;
objinterfaceMapping.InterfaceDesc = item1.InterfaceDesc;
objinterfaceMapping.ModeTypeId = item1.ModeTypeId;
objinterfaceMapping.ReqReference = item1.ReqReference;
objinterfaceMapping.SourceId = item1.SourceId;
objinterfaceMapping.DestinationId = item1.DestinationId;
objinterfaceMapping.EntityState = EntityState.Deleted;
repository1.Remove(objinterfaceMapping);
}
}
repository.Remove(objtblinterface);
}
}
}
catch (Exception)
{
throw;
}
}
public int SaveData(IList <InterfaceViewModel> interfaceViewModel, int daId)
{
try
{
int result = 0;
InterfaceManager interfaceManager = new InterfaceManager();
List <tbl_InterfaceAttrMapping> lstInterfaceAttrMapping = new List <tbl_InterfaceAttrMapping>();
var allInterfaces = interfaceViewModel.GroupBy(i => i.interfaceAttrMapId);
foreach (var intfs in allInterfaces)
{
tbl_InterfaceAttrMapping tblInterfaceAttrMapping = new tbl_InterfaceAttrMapping();
if (intfs.Key.ToString().Length > 5 && intfs.Key.ToString().Substring(intfs.Key.ToString().Length - 2, 2).Equals("00"))
{
#region Add new Interfaces
var counter = 1;
var newInterface = interfaceViewModel.Where(e => e.interfaceAttrMapId == intfs.Key && e.IsLinked.Equals(true));
foreach (var item in newInterface)
{
if (counter == 1)
{
tblInterfaceAttrMapping.ReqReference = (item.reqReference == null ? "" : item.reqReference);
tblInterfaceAttrMapping.InterfaceDesc = item.interfaceDesc;
tblInterfaceAttrMapping.SourceId = Convert.ToInt32(item.sourceId);
tblInterfaceAttrMapping.DestinationId = Convert.ToInt32(item.destinationId);
tblInterfaceAttrMapping.ModeTypeId = Convert.ToInt32(item.modeTypeId);
tblInterfaceAttrMapping.AttrID1 = Convert.ToInt32(item.attrID1);
tblInterfaceAttrMapping.AttrValueID1 = Convert.ToInt32(item.attrValueID1);
tblInterfaceAttrMapping.AttrID2 = item.attrID2;
tblInterfaceAttrMapping.AttrValueID2 = item.attrValueID2;
tblInterfaceAttrMapping.AttrID3 = item.attrID3;
tblInterfaceAttrMapping.AttrValueID3 = item.attrValueID3;
tblInterfaceAttrMapping.AttrID4 = item.attrID4;
tblInterfaceAttrMapping.AttrValueID4 = item.attrValueID4;
tblInterfaceAttrMapping.AttrID5 = item.attrID5;
tblInterfaceAttrMapping.AttrValueID5 = item.attrValueID5;
tblInterfaceAttrMapping.AttrID6 = item.attrID6;
tblInterfaceAttrMapping.AttrValueID6 = item.attrValueID6;
tblInterfaceAttrMapping.AttrID7 = item.attrID7;
tblInterfaceAttrMapping.AttrValueID7 = item.attrValueID7;
tblInterfaceAttrMapping.AttrID8 = item.attrID8;
tblInterfaceAttrMapping.AttrValueID8 = item.attrValueID8;
tblInterfaceAttrMapping.AttrID9 = item.attrID9;
tblInterfaceAttrMapping.AttrValueID9 = item.attrValueID9;
tblInterfaceAttrMapping.AttrID10 = item.attrID10;
tblInterfaceAttrMapping.AttrValueID10 = item.attrValueID10;
tblInterfaceAttrMapping.EntityState = DA.DomainModel.EntityState.Added;
}
counter++;
tbl_Interface tblInterface = new tbl_Interface();
tblInterface.daId = daId;
tblInterface.TransactionSeq = item.transactionSeq;
//to enter the FK interfaceMappingID
tblInterface.tbl_InterfaceAttrMapping = tblInterfaceAttrMapping;
tblInterface.EntityState = DA.DomainModel.EntityState.Added;
tblInterfaceAttrMapping.tbl_Interface.Add(tblInterface);
}
lstInterfaceAttrMapping.Add(tblInterfaceAttrMapping);
#endregion
}
else
{
#region Add,Modify,Delete Interfaces
var counter = 1;
var existingInterface = interfaceViewModel.Where(e => e.interfaceAttrMapId == intfs.Key && (e.IsLinked.Equals(true) || e.interfaceId != 0));
foreach (var item in existingInterface)
{
if (counter == 1)
{
tblInterfaceAttrMapping.InterfaceAttrMapID = Convert.ToInt32(item.interfaceAttrMapId);
tblInterfaceAttrMapping.ReqReference = (item.reqReference == null ? "" : item.reqReference);
tblInterfaceAttrMapping.InterfaceDesc = item.interfaceDesc;
tblInterfaceAttrMapping.SourceId = Convert.ToInt32(item.sourceId);
tblInterfaceAttrMapping.DestinationId = Convert.ToInt32(item.destinationId);
tblInterfaceAttrMapping.ModeTypeId = Convert.ToInt32(item.modeTypeId);
tblInterfaceAttrMapping.AttrID1 = Convert.ToInt32(item.attrID1);
tblInterfaceAttrMapping.AttrValueID1 = Convert.ToInt32(item.attrValueID1);
tblInterfaceAttrMapping.AttrID2 = item.attrID2;
tblInterfaceAttrMapping.AttrValueID2 = item.attrValueID2;
tblInterfaceAttrMapping.AttrID3 = item.attrID3;
tblInterfaceAttrMapping.AttrValueID3 = item.attrValueID3;
tblInterfaceAttrMapping.AttrID4 = item.attrID4;
tblInterfaceAttrMapping.AttrValueID4 = item.attrValueID4;
tblInterfaceAttrMapping.AttrID5 = item.attrID5;
tblInterfaceAttrMapping.AttrValueID5 = item.attrValueID5;
tblInterfaceAttrMapping.AttrID6 = item.attrID6;
tblInterfaceAttrMapping.AttrValueID6 = item.attrValueID6;
tblInterfaceAttrMapping.AttrID7 = item.attrID7;
tblInterfaceAttrMapping.AttrValueID7 = item.attrValueID7;
tblInterfaceAttrMapping.AttrID8 = item.attrID8;
tblInterfaceAttrMapping.AttrValueID8 = item.attrValueID8;
tblInterfaceAttrMapping.AttrID9 = item.attrID9;
tblInterfaceAttrMapping.AttrValueID9 = item.attrValueID9;
tblInterfaceAttrMapping.AttrID10 = item.attrID10;
tblInterfaceAttrMapping.AttrValueID10 = item.attrValueID10;
tblInterfaceAttrMapping.EntityState = DA.DomainModel.EntityState.Modified;
}
counter++;
tbl_Interface tblInterface = new tbl_Interface();
tblInterface.daId = daId;
tblInterface.InterfaceID = item.interfaceId;
tblInterface.InterfaceAttrMapID = Convert.ToInt32(item.interfaceAttrMapId);
tblInterface.TransactionSeq = Convert.ToInt32(item.transactionSeq);
//To keep record as it is
if ((item.interfaceId != 0) && (item.IsLinked == true))
{
tblInterface.EntityState = DA.DomainModel.EntityState.Unchanged;
}
//to remove unchecked transaction
else if ((item.interfaceId != 0) && (item.IsLinked == false))
{
tblInterface.EntityState = DA.DomainModel.EntityState.Deleted;
}
//to add newly checked transaction
else if ((item.interfaceId == 0) && (item.IsLinked == true))
{
tblInterface.EntityState = DA.DomainModel.EntityState.Added;
}
tblInterfaceAttrMapping.tbl_Interface.Add(tblInterface);
}
lstInterfaceAttrMapping.Add(tblInterfaceAttrMapping);
#endregion
}
}
result = interfaceManager.SaveDataMapping(lstInterfaceAttrMapping);
return(result);
}
catch (Exception)
{
throw;
}
}
