Int64 IBDProcessAssignedResourceMapDataAccess.Add(BDProcessAssignedResourceMapEntity bDProcessAssignedResourceMapEntity, DatabaseOperationType option, TransactionRequired reqTran)
{
try
{
long retValues = -99;
switch (reqTran)
{
case TransactionRequired.No:
{
retValues = Add(bDProcessAssignedResourceMapEntity, option);
break;
}
case TransactionRequired.Yes:
{
retValues = AddTran(bDProcessAssignedResourceMapEntity, option);
break;
}
default:
{
retValues = -99;
break;
}
}
return(retValues);
}
catch (Exception ex)
{
throw ex;
}
}
private void PrepareEditView()
{
BDProcessAssignedResourceMapEntity bDProcessAssignedResourceMapEntity = CurrentBDProcessAssignedResourceMapEntity;
if (!bDProcessAssignedResourceMapEntity.IsNew)
{
}
}
private Int64 Update(BDProcessAssignedResourceMapEntity bDProcessAssignedResourceMapEntity, String filterExpression, DatabaseOperationType option)
{
long returnCode = -99;
const string SP = "dbo.BDProcessAssignedResourceMap_SET";
using (DbCommand cmd = Database.GetStoredProcCommand(SP))
{
AddOptionParameter(cmd, option);
AddOutputParameter(cmd);
AddFilterExpressionParameter(cmd, filterExpression);
Database.AddInParameter(cmd, "@ProcessAssignedResourceMapID", DbType.Int64, bDProcessAssignedResourceMapEntity.ProcessAssignedResourceMapID);
Database.AddInParameter(cmd, "@ProcessAssignedResourceID", DbType.Int64, bDProcessAssignedResourceMapEntity.ProcessAssignedResourceID);
Database.AddInParameter(cmd, "@ResourceCategoryID", DbType.Int64, bDProcessAssignedResourceMapEntity.ResourceCategoryID);
Database.AddInParameter(cmd, "@ReferenceID", DbType.Int64, bDProcessAssignedResourceMapEntity.ReferenceID);
Database.AddInParameter(cmd, "@ResourceName", DbType.String, bDProcessAssignedResourceMapEntity.ResourceName);
Database.AddInParameter(cmd, "@ResourceDesignation", DbType.String, bDProcessAssignedResourceMapEntity.ResourceDesignation);
Database.AddInParameter(cmd, "@ResourceCompany", DbType.String, bDProcessAssignedResourceMapEntity.ResourceCompany);
Database.AddInParameter(cmd, "@ResourceMobileNo", DbType.String, bDProcessAssignedResourceMapEntity.ResourceMobileNo);
Database.AddInParameter(cmd, "@ResourceEmail", DbType.String, bDProcessAssignedResourceMapEntity.ResourceEmail);
Database.AddInParameter(cmd, "@AddressLine1", DbType.String, bDProcessAssignedResourceMapEntity.AddressLine1);
Database.AddInParameter(cmd, "@AddressLine2", DbType.String, bDProcessAssignedResourceMapEntity.AddressLine2);
Database.AddInParameter(cmd, "@ResourceTypeID", DbType.Int64, bDProcessAssignedResourceMapEntity.ResourceTypeID);
Database.AddInParameter(cmd, "@ResourceDOB", DbType.DateTime, bDProcessAssignedResourceMapEntity.ResourceDOB);
Database.AddInParameter(cmd, "@Remarks", DbType.String, bDProcessAssignedResourceMapEntity.Remarks);
using (IDataReader reader = Database.ExecuteReader(cmd))
{
returnCode = GetReturnCodeFromParameter(cmd);
switch (returnCode)
{
case SqlConstants.DB_STATUS_CODE_DATAALREADYEXIST:
{
throw new ArgumentException("BDProcessAssignedResourceMapEntity already exists. Please specify another BDProcessAssignedResourceMapEntity.");
}
case SqlConstants.DB_STATUS_CODE_DATAUPDATEDFROMOTHERSESSION:
{
throw new ArgumentException("BDProcessAssignedResourceMapEntity data already updated from different session.");
}
case SqlConstants.DB_STATUS_CODE_FAIL_OPERATION:
{
throw new ArgumentException("BDProcessAssignedResourceMapEntity already exists. Please specify another BDProcessAssignedResourceMapEntity.");
}
}
}
}
return(returnCode);
}
private Int64 DeleteTran(BDProcessAssignedResourceMapEntity bDProcessAssignedResourceMapEntity, String filterExpression, DatabaseOperationType option)
{
long returnCode = -99;
const string SP = "dbo.BDProcessAssignedResourceMap_SET";
Database db = DatabaseFactory.CreateDatabase();
using (DbCommand cmd = db.GetStoredProcCommand(SP))
{
AddOptionParameter(cmd, option);
AddOutputParameter(cmd, db);
AddFilterExpressionParameter(cmd, filterExpression, db);
DbConnection connection = db.CreateConnection();
connection.Open();
DbTransaction transaction = connection.BeginTransaction();
try
{
using (IDataReader reader = db.ExecuteReader(cmd, transaction))
{
returnCode = GetReturnCodeFromParameter(cmd);
}
if (returnCode >= 0)
{
transaction.Commit();
}
else
{
throw new ArgumentException("Error Code." + returnCode.ToString());
}
}
catch (Exception ex)
{
transaction.Rollback();
throw ex;
}
finally
{
transaction.Dispose();
connection.Close();
connection = null;
}
}
return(returnCode);
}
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);
}
}
}
}
private Int64 Delete(BDProcessAssignedResourceMapEntity bDProcessAssignedResourceMapEntity, String filterExpression, DatabaseOperationType option)
{
long returnCode = -99;
const string SP = "dbo.BDProcessAssignedResourceMap_SET";
using (DbCommand cmd = Database.GetStoredProcCommand(SP))
{
AddOptionParameter(cmd, option);
AddOutputParameter(cmd);
AddFilterExpressionParameter(cmd, filterExpression);
using (IDataReader reader = Database.ExecuteReader(cmd))
{
returnCode = GetReturnCodeFromParameter(cmd);
switch (returnCode)
{
case SqlConstants.DB_STATUS_CODE_DATAALREADYEXIST:
{
throw new ArgumentException("BDProcessAssignedResourceMapEntity already exists. Please specify another BDProcessAssignedResourceMapEntity.");
}
case SqlConstants.DB_STATUS_CODE_DATAUPDATEDFROMOTHERSESSION:
{
throw new ArgumentException("BDProcessAssignedResourceMapEntity data already updated from different session.");
}
case SqlConstants.DB_STATUS_CODE_FAIL_OPERATION:
{
throw new ArgumentException("BDProcessAssignedResourceMapEntity already exists. Please specify another BDProcessAssignedResourceMapEntity.");
}
}
}
}
return(returnCode);
}
protected void lvBDProcessAssignedResourceMap_ItemDataBound(object sender, ListViewItemEventArgs e)
{
if (e.Item.ItemType == ListViewItemType.DataItem)
{
ListViewDataItem dataItem = (ListViewDataItem)e.Item;
BDProcessAssignedResourceMapEntity ent = (BDProcessAssignedResourceMapEntity)dataItem.DataItem;
HyperLink hypEnvelopReport = (HyperLink)e.Item.FindControl("hypEnvelopReport");
HyperLink hypLargeEvelopReport = (HyperLink)e.Item.FindControl("hypLargeEvelopReport");
HyperLink hypLegalEnvelopReport = (HyperLink)e.Item.FindControl("hypLegalEnvelopReport");
HyperLink hypTransmissionSheet = (HyperLink)e.Item.FindControl("hypTransmissionSheet");
hypEnvelopReport.NavigateUrl = UrlHelper.BuildSecureUrl("~/Reports/ReportViewer.aspx", string.Empty, "do", ReportConstants.ENVELOP_REPORT, UrlConstants.OVERVIEW_PROCESS_ASSIGNED_RESOURCE_MAP_ID, ent.ProcessAssignedResourceMapID.ToString()).ToString();
hypLargeEvelopReport.NavigateUrl = UrlHelper.BuildSecureUrl("~/Reports/ReportViewer.aspx", string.Empty, "do", ReportConstants.LARGE_ENVELOP_REPORT, UrlConstants.OVERVIEW_PROCESS_ASSIGNED_RESOURCE_MAP_ID, ent.ProcessAssignedResourceMapID.ToString()).ToString();
hypLegalEnvelopReport.NavigateUrl = UrlHelper.BuildSecureUrl("~/Reports/ReportViewer.aspx", string.Empty, "do", ReportConstants.LEGEL_ENVELOP_REPORT, UrlConstants.OVERVIEW_PROCESS_ASSIGNED_RESOURCE_MAP_ID, ent.ProcessAssignedResourceMapID.ToString()).ToString();
hypTransmissionSheet.NavigateUrl = UrlHelper.BuildSecureUrl("~/Reports/ReportViewer.aspx", string.Empty, "do", ReportConstants.TRANSMISSION_SHEET_REPORT, UrlConstants.OVERVIEW_PROCESS_ASSIGNED_RESOURCE_MAP_ID, ent.ProcessAssignedResourceMapID.ToString()).ToString();
hypEnvelopReport.Target = "_blank";
hypLargeEvelopReport.Target = "_blank";
hypLegalEnvelopReport.Target = "_blank";
hypTransmissionSheet.Target = "_blank";
}
}
private Int64 UpdateTran(BDProcessAssignedResourceMapEntity bDProcessAssignedResourceMapEntity, String filterExpression, DatabaseOperationType option)
{
long returnCode = -99;
const string SP = "dbo.BDProcessAssignedResourceMap_SET";
Database db = DatabaseFactory.CreateDatabase();
using (DbCommand cmd = db.GetStoredProcCommand(SP))
{
AddOptionParameter(cmd, option, db);
AddOutputParameter(cmd, db);
AddFilterExpressionParameter(cmd, filterExpression, db);
db.AddInParameter(cmd, "@ProcessAssignedResourceMapID", DbType.Int64, bDProcessAssignedResourceMapEntity.ProcessAssignedResourceMapID);
db.AddInParameter(cmd, "@ProcessAssignedResourceID", DbType.Int64, bDProcessAssignedResourceMapEntity.ProcessAssignedResourceID);
db.AddInParameter(cmd, "@ResourceCategoryID", DbType.Int64, bDProcessAssignedResourceMapEntity.ResourceCategoryID);
db.AddInParameter(cmd, "@ReferenceID", DbType.Int64, bDProcessAssignedResourceMapEntity.ReferenceID);
db.AddInParameter(cmd, "@ResourceName", DbType.String, bDProcessAssignedResourceMapEntity.ResourceName);
db.AddInParameter(cmd, "@ResourceDesignation", DbType.String, bDProcessAssignedResourceMapEntity.ResourceDesignation);
db.AddInParameter(cmd, "@ResourceCompany", DbType.String, bDProcessAssignedResourceMapEntity.ResourceCompany);
db.AddInParameter(cmd, "@ResourceMobileNo", DbType.String, bDProcessAssignedResourceMapEntity.ResourceMobileNo);
db.AddInParameter(cmd, "@ResourceEmail", DbType.String, bDProcessAssignedResourceMapEntity.ResourceEmail);
db.AddInParameter(cmd, "@AddressLine1", DbType.String, bDProcessAssignedResourceMapEntity.AddressLine1);
db.AddInParameter(cmd, "@AddressLine2", DbType.String, bDProcessAssignedResourceMapEntity.AddressLine2);
db.AddInParameter(cmd, "@ResourceTypeID", DbType.Int64, bDProcessAssignedResourceMapEntity.ResourceTypeID);
db.AddInParameter(cmd, "@ResourceDOB", DbType.DateTime, bDProcessAssignedResourceMapEntity.ResourceDOB);
db.AddInParameter(cmd, "@Remarks", DbType.String, bDProcessAssignedResourceMapEntity.Remarks);
DbConnection connection = db.CreateConnection();
connection.Open();
DbTransaction transaction = connection.BeginTransaction();
try
{
using (IDataReader reader = db.ExecuteReader(cmd, transaction))
{
returnCode = GetReturnCodeFromParameter(cmd);
}
if (returnCode > 0)
{
transaction.Commit();
}
else
{
throw new ArgumentException("Error Code." + returnCode.ToString());
}
}
catch (Exception ex)
{
transaction.Rollback();
throw ex;
}
finally
{
transaction.Dispose();
connection.Close();
connection = null;
}
}
return(returnCode);
}
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);
}
}
}
Int64 IBDProcessAssignedResourceMapFacade.Delete(BDProcessAssignedResourceMapEntity bDProcessAssignedResourceMapEntity, String filterExpression, DatabaseOperationType option, TransactionRequired reqTran)
{
return(DataAccessFactory.CreateBDProcessAssignedResourceMapDataAccess().Delete(bDProcessAssignedResourceMapEntity, filterExpression, option, reqTran));
}
Int64 IBDProcessAssignedResourceMapFacade.Add(BDProcessAssignedResourceMapEntity bDProcessAssignedResourceMapEntity, DatabaseOperationType option, TransactionRequired reqTran)
{
return(DataAccessFactory.CreateBDProcessAssignedResourceMapDataAccess().Add(bDProcessAssignedResourceMapEntity, option, reqTran));
}
