public IList <BDProcessAssignedResourceMapEntity> GetPagedData(Int32 startRowIndex, Int32 pageSize, String sortExpression)
{
IList <BDProcessAssignedResourceMapEntity> bDProcessAssignedResourceMapEntityList = new List <BDProcessAssignedResourceMapEntity>();
try
{
if (pageSize == -1)
{
pageSize = 1000000000;
}
if (String.IsNullOrEmpty(sortExpression))
{
sortExpression = BDProcessAssignedResourceMapEntity.FLD_NAME_ProcessAssignedResourceMapID + " " + SQLConstants.SORT_ORDER_DESCENDING;
}
startRowIndex = Convert.ToInt32(startRowIndex / pageSize) + 1;
bDProcessAssignedResourceMapEntityList = FCCBDProcessAssignedResourceMap.GetFacadeCreate().GetIL(startRowIndex, pageSize, sortExpression, null, DatabaseOperationType.LoadPagedWithSortExpression);
if (bDProcessAssignedResourceMapEntityList != null && bDProcessAssignedResourceMapEntityList.Count > 0)
{
totalRowCount = bDProcessAssignedResourceMapEntityList[0].TotalRowCount;
}
}
catch (Exception ex)
{
}
return(bDProcessAssignedResourceMapEntityList ?? new List <BDProcessAssignedResourceMapEntity>());
}
protected void lvBDProcessAssignedResourceMap_ItemCommand(object sender, ListViewCommandEventArgs e)
{
Int64 ProcessAssignedResourceMapID;
Int64.TryParse(e.CommandArgument.ToString(), out ProcessAssignedResourceMapID);
if (ProcessAssignedResourceMapID > 0)
{
if (string.Equals(e.CommandName, "EditItem"))
{
_ProcessAssignedResourceMapID = ProcessAssignedResourceMapID;
PrepareEditView();
}
else if (string.Equals(e.CommandName, "DeleteItem"))
{
try
{
Int64 result = -1;
String fe = SqlExpressionBuilder.PrepareFilterExpression(BDProcessAssignedResourceMapEntity.FLD_NAME_ProcessAssignedResourceMapID, ProcessAssignedResourceMapID.ToString(), SQLMatchType.Equal);
BDProcessAssignedResourceMapEntity bDProcessAssignedResourceMapEntity = new BDProcessAssignedResourceMapEntity();
result = FCCBDProcessAssignedResourceMap.GetFacadeCreate().Delete(bDProcessAssignedResourceMapEntity, fe, DatabaseOperationType.Delete, TransactionRequired.No);
if (result == 0)
{
_ProcessAssignedResourceMapID = 0;
_BDProcessAssignedResourceMapEntity = new BDProcessAssignedResourceMapEntity();
PrepareInitialView();
BindBDProcessAssignedResourceMapList();
MiscUtil.ShowMessage(lblMessage, "Process Assigned Resource Map has been successfully deleted.", true);
}
else
{
MiscUtil.ShowMessage(lblMessage, "Failed to delete Process Assigned Resource Map.", true);
}
}
catch (Exception ex)
{
MiscUtil.ShowMessage(lblMessage, ex.Message, true);
}
}
}
}
public IList <BDProcessAssignedResourceMapEntity> GetData()
{
IList <BDProcessAssignedResourceMapEntity> bDProcessAssignedResourceMapEntityList = new List <BDProcessAssignedResourceMapEntity>();
try
{
bDProcessAssignedResourceMapEntityList = FCCBDProcessAssignedResourceMap.GetFacadeCreate().GetIL(null, null, null, null, DatabaseOperationType.Load);
if (bDProcessAssignedResourceMapEntityList != null && bDProcessAssignedResourceMapEntityList.Count > 0)
{
totalRowCount = bDProcessAssignedResourceMapEntityList[0].TotalRowCount;
}
}
catch (Exception ex)
{
}
return(bDProcessAssignedResourceMapEntityList ?? new List <BDProcessAssignedResourceMapEntity>());
}
private void SaveBDProcessAssignedResourceEntity()
{
if (IsValid)
{
try
{
BDProcessAssignedResourceEntity bDProcessAssignedResourceEntity = BuildBDProcessAssignedResourceEntity();
Int64 result = -1;
if (bDProcessAssignedResourceEntity.IsNew)
{
result = FCCBDProcessAssignedResource.GetFacadeCreate().Add(bDProcessAssignedResourceEntity, DatabaseOperationType.Add, TransactionRequired.No);
}
else
{
String filterExpression = SqlExpressionBuilder.PrepareFilterExpression(BDProcessAssignedResourceEntity.FLD_NAME_ProcessAssignedResourceID, bDProcessAssignedResourceEntity.ProcessAssignedResourceID.ToString(), SQLMatchType.Equal);
result = FCCBDProcessAssignedResource.GetFacadeCreate().Update(bDProcessAssignedResourceEntity, filterExpression, DatabaseOperationType.Update, TransactionRequired.No);
}
if (result > 0)
{
BDProcessAssignedResourceMapEntity bDProcessAssignedResourceMapEntity = CurrentBDProcessAssignedResourceMapEntity;
String fe = SqlExpressionBuilder.PrepareFilterExpression(BDProcessAssignedResourceMapEntity.FLD_NAME_ProcessAssignedResourceID, result.ToString(), SQLMatchType.Equal);
IList <BDProcessAssignedResourceMapEntity> mappedItemsFromDB = FCCBDProcessAssignedResourceMap.GetFacadeCreate().GetIL(null, null, String.Empty, fe, DatabaseOperationType.LoadWithFilterExpression);
IList <CRMContactList_CustomEntity> tempAddList = new List <CRMContactList_CustomEntity>();
if (mappedItemsFromDB != null && mappedItemsFromDB.Count > 0)
{
foreach (BDProcessAssignedResourceMapEntity ent in mappedItemsFromDB)
{
CRMContactList_CustomEntity cRMContactList_CustomEntity = new CRMContactList_CustomEntity();
cRMContactList_CustomEntity.ResourceID = ent.ReferenceID;
cRMContactList_CustomEntity.ResourceCategoryID = ent.ResourceCategoryID.ToString();
cRMContactList_CustomEntity.ResourceName = ent.ResourceName;
cRMContactList_CustomEntity.ResourceDesignation = ent.ResourceDesignation;
cRMContactList_CustomEntity.ResourceEmail = ent.ResourceEmail;
cRMContactList_CustomEntity.AddressLine1 = ent.AddressLine1;
cRMContactList_CustomEntity.AddressLine2 = ent.AddressLine2;
cRMContactList_CustomEntity.ResourceMobileNo = ent.ResourceMobileNo;
Int64 resourceTypeID = 0;
Int64.TryParse(ent.ResourceTypeID.ToString(), out resourceTypeID);
cRMContactList_CustomEntity.ResourceTypeID = resourceTypeID;
cRMContactList_CustomEntity.ResourceCompany = ent.ResourceCompany;
tempAddList.Add(cRMContactList_CustomEntity);
}
}
IList <CRMContactList_CustomEntity> finalAddList = IssueCRMContactList_CustomEntityList.Except(tempAddList, new CustomerComparer()).ToList();
IList <CRMContactList_CustomEntity> finalDeleteList = tempAddList.Except(IssueCRMContactList_CustomEntityList, new CustomerComparer()).ToList();
foreach (CRMContactList_CustomEntity ent in finalAddList)
{
bDProcessAssignedResourceMapEntity.ProcessAssignedResourceID = result;
bDProcessAssignedResourceMapEntity.ResourceCategoryID = Int64.Parse(ent.ResourceCategoryID.ToString());
bDProcessAssignedResourceMapEntity.ReferenceID = ent.ResourceID;
bDProcessAssignedResourceMapEntity.ResourceName = ent.ResourceName;
bDProcessAssignedResourceMapEntity.ResourceDesignation = ent.ResourceDesignation;
bDProcessAssignedResourceMapEntity.ResourceEmail = ent.ResourceEmail;
bDProcessAssignedResourceMapEntity.ResourceMobileNo = ent.ResourceMobileNo;
bDProcessAssignedResourceMapEntity.AddressLine1 = ent.AddressLine1;
bDProcessAssignedResourceMapEntity.AddressLine2 = ent.AddressLine2;
Int64 resourceTypeID = 0;
Int64.TryParse(ent.ResourceTypeID.ToString(), out resourceTypeID);
bDProcessAssignedResourceMapEntity.ResourceTypeID = resourceTypeID;
bDProcessAssignedResourceMapEntity.ResourceCompany = ent.ResourceCompany;
bDProcessAssignedResourceMapEntity.Remarks = txtRemarks.Text.Trim();
FCCBDProcessAssignedResourceMap.GetFacadeCreate().Add(bDProcessAssignedResourceMapEntity, DatabaseOperationType.Add, TransactionRequired.No);
}
foreach (CRMContactList_CustomEntity ent in finalDeleteList)
{
String fe1 = SqlExpressionBuilder.PrepareFilterExpression(BDProcessAssignedResourceMapEntity.FLD_NAME_ReferenceID, ent.ResourceID.ToString(), SQLMatchType.Equal);
String fe2 = SqlExpressionBuilder.PrepareFilterExpression(BDProcessAssignedResourceMapEntity.FLD_NAME_ResourceCategoryID, ent.ResourceCategoryID, SQLMatchType.Equal);
String fe_delete = SqlExpressionBuilder.PrepareFilterExpression(fe1, SQLJoinType.AND, fe2);
FCCBDProcessAssignedResourceMap.GetFacadeCreate().Delete(bDProcessAssignedResourceMapEntity, fe_delete, DatabaseOperationType.Delete, TransactionRequired.No);
}
if (!bDProcessAssignedResourceEntity.IsNew)
{
//_ProcessAssignedResourceID = 0;
//_BDProcessAssignedResourceEntity = new BDProcessAssignedResourceEntity();
}
_ProcessAssignedResourceID = result;
PrepareEditView();
BindBDProcessAssignedResourceMapList();
if (bDProcessAssignedResourceEntity.IsNew)
{
MiscUtil.ShowMessage(lblMessage, "Process Assigned Resource Information has been added successfully.", false);
}
else
{
MiscUtil.ShowMessage(lblMessage, "Process Assigned Resource Information has been updated successfully.", false);
}
}
else
{
if (bDProcessAssignedResourceEntity.IsNew)
{
MiscUtil.ShowMessage(lblMessage, "Failed to add Process Assigned Resource Information.", false);
}
else
{
MiscUtil.ShowMessage(lblMessage, "Failed to update Process Assigned Resource Information.", false);
}
}
}
catch (Exception ex)
{
MiscUtil.ShowMessage(lblMessage, ex.Message, true);
}
}
}
