private Int64 Delete(BDProcessAssignedResourceEntity bDProcessAssignedResourceEntity, String filterExpression, DatabaseOperationType option) { long returnCode = -99; const string SP = "dbo.BDProcessAssignedResource_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("BDProcessAssignedResourceEntity already exists. Please specify another BDProcessAssignedResourceEntity."); } case SqlConstants.DB_STATUS_CODE_DATAUPDATEDFROMOTHERSESSION: { throw new ArgumentException("BDProcessAssignedResourceEntity data already updated from different session."); } case SqlConstants.DB_STATUS_CODE_FAIL_OPERATION: { throw new ArgumentException("BDProcessAssignedResourceEntity already exists. Please specify another BDProcessAssignedResourceEntity."); } } } } return(returnCode); }
protected void btnAddNew_Click(object sender, EventArgs e) { _ProcessAssignedResourceID = 0; _BDProcessAssignedResourceEntity = new BDProcessAssignedResourceEntity(); PrepareInitialView(); }
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 IBDProcessAssignedResourceFacade.Delete(BDProcessAssignedResourceEntity bDProcessAssignedResourceEntity, String filterExpression, DatabaseOperationType option, TransactionRequired reqTran) { return(DataAccessFactory.CreateBDProcessAssignedResourceDataAccess().Delete(bDProcessAssignedResourceEntity, filterExpression, option, reqTran)); }
Int64 IBDProcessAssignedResourceFacade.Add(BDProcessAssignedResourceEntity bDProcessAssignedResourceEntity, DatabaseOperationType option, TransactionRequired reqTran) { return(DataAccessFactory.CreateBDProcessAssignedResourceDataAccess().Add(bDProcessAssignedResourceEntity, option, reqTran)); }