public IList <CMNEventInvitationInformationEntity> GetPagedData(Int32 startRowIndex, Int32 pageSize, String sortExpression) { IList <CMNEventInvitationInformationEntity> cMNEventInvitationInformationEntityList = new List <CMNEventInvitationInformationEntity>(); try { if (pageSize == -1) { pageSize = 1000000000; } if (String.IsNullOrEmpty(sortExpression)) { sortExpression = CMNEventInvitationInformationEntity.FLD_NAME_EventInvitationInformationID + " " + SQLConstants.SORT_ORDER_DESCENDING; } startRowIndex = Convert.ToInt32(startRowIndex / pageSize) + 1; cMNEventInvitationInformationEntityList = FCCCMNEventInvitationInformation.GetFacadeCreate().GetIL(startRowIndex, pageSize, sortExpression, null, DatabaseOperationType.LoadPagedWithSortExpression); if (cMNEventInvitationInformationEntityList != null && cMNEventInvitationInformationEntityList.Count > 0) { totalRowCount = cMNEventInvitationInformationEntityList[0].TotalRowCount; } } catch (Exception ex) { } return(cMNEventInvitationInformationEntityList ?? new List <CMNEventInvitationInformationEntity>()); }
private void SaveCMNEventInvitationInformationEntity() { if (IsValid) { try { CMNEventInvitationInformationEntity cMNEventInvitationInformationEntity = BuildCMNEventInvitationInformationEntity(); Int64 result = -1; if (cMNEventInvitationInformationEntity.IsNew) { result = FCCCMNEventInvitationInformation.GetFacadeCreate().Add(cMNEventInvitationInformationEntity, DatabaseOperationType.Add, TransactionRequired.No); } else { String filterExpression = SqlExpressionBuilder.PrepareFilterExpression(CMNEventInvitationInformationEntity.FLD_NAME_EventInvitationInformationID, cMNEventInvitationInformationEntity.EventInvitationInformationID.ToString(), SQLMatchType.Equal); result = FCCCMNEventInvitationInformation.GetFacadeCreate().Update(cMNEventInvitationInformationEntity, filterExpression, DatabaseOperationType.Update, TransactionRequired.No); } if (result > 0) { _EventInvitationInformationID = 0; _CMNEventInvitationInformationEntity = new CMNEventInvitationInformationEntity(); PrepareInitialView(); BindCMNEventInvitationInformationList(); if (cMNEventInvitationInformationEntity.IsNew) { MiscUtil.ShowMessage(lblMessage, "Event Invitation Information Information has been added successfully.", false); } else { MiscUtil.ShowMessage(lblMessage, "Event Invitation Information Information has been updated successfully.", false); } } else { if (cMNEventInvitationInformationEntity.IsNew) { MiscUtil.ShowMessage(lblMessage, "Failed to add Event Invitation Information Information.", false); } else { MiscUtil.ShowMessage(lblMessage, "Failed to update Event Invitation Information Information.", false); } } } catch (Exception ex) { MiscUtil.ShowMessage(lblMessage, ex.Message, true); } } }
protected void lvCMNEventInvitationInformation_ItemCommand(object sender, ListViewCommandEventArgs e) { Int64 EventInvitationInformationID; Int64.TryParse(e.CommandArgument.ToString(), out EventInvitationInformationID); if (EventInvitationInformationID > 0) { if (string.Equals(e.CommandName, "EditItem")) { _EventInvitationInformationID = EventInvitationInformationID; PrepareEditView(); } else if (string.Equals(e.CommandName, "DeleteItem")) { try { Int64 result = -1; String fe = SqlExpressionBuilder.PrepareFilterExpression(CMNEventInvitationInformationEntity.FLD_NAME_EventInvitationInformationID, EventInvitationInformationID.ToString(), SQLMatchType.Equal); CMNEventInvitationInformationEntity cMNEventInvitationInformationEntity = new CMNEventInvitationInformationEntity(); result = FCCCMNEventInvitationInformation.GetFacadeCreate().Delete(cMNEventInvitationInformationEntity, fe, DatabaseOperationType.Delete, TransactionRequired.No); if (result == 0) { _EventInvitationInformationID = 0; _CMNEventInvitationInformationEntity = new CMNEventInvitationInformationEntity(); PrepareInitialView(); BindCMNEventInvitationInformationList(); MiscUtil.ShowMessage(lblMessage, "Event Invitation Information has been successfully deleted.", true); } else { MiscUtil.ShowMessage(lblMessage, "Failed to delete Event Invitation Information.", true); } } catch (Exception ex) { MiscUtil.ShowMessage(lblMessage, ex.Message, true); } } } }
public IList <CMNEventInvitationInformationEntity> GetData() { IList <CMNEventInvitationInformationEntity> cMNEventInvitationInformationEntityList = new List <CMNEventInvitationInformationEntity>(); try { cMNEventInvitationInformationEntityList = FCCCMNEventInvitationInformation.GetFacadeCreate().GetIL(null, null, null, null, DatabaseOperationType.Load); if (cMNEventInvitationInformationEntityList != null && cMNEventInvitationInformationEntityList.Count > 0) { totalRowCount = cMNEventInvitationInformationEntityList[0].TotalRowCount; } } catch (Exception ex) { } return(cMNEventInvitationInformationEntityList ?? new List <CMNEventInvitationInformationEntity>()); }
protected void odsCMNEvent_Selecting(object sender, ObjectDataSourceSelectingEventArgs e) { String fe1 = SqlExpressionBuilder.PrepareFilterExpression(CMNEventEntity.FLD_NAME_EventIdentityCategoryID, OverviewEventIdentityCategoryID.ToString(), SQLMatchType.Equal); String fe2 = SqlExpressionBuilder.PrepareFilterExpression(CMNEventEntity.FLD_NAME_CreatedByMemberID, CurrentMember.MemberID.ToString(), SQLMatchType.Equal); String fe = SqlExpressionBuilder.PrepareFilterExpression(fe1, SQLJoinType.AND, fe2); String fe_invitation = SqlExpressionBuilder.PrepareFilterExpression(CMNEventInvitationInformationEntity.FLD_NAME_InitationGivenToMemberID, CurrentMember.MemberID.ToString(), SQLMatchType.Equal); IList <CMNEventInvitationInformationEntity> lstCMNEventInvitationInformationEntity = FCCCMNEventInvitationInformation.GetFacadeCreate().GetIL(null, null, String.Empty, fe_invitation, DatabaseOperationType.LoadWithFilterExpression); if (lstCMNEventInvitationInformationEntity != null && lstCMNEventInvitationInformationEntity.Count > 0) { String compositeEventID = String.Empty; foreach (CMNEventInvitationInformationEntity ent in lstCMNEventInvitationInformationEntity) { compositeEventID += ent.EventID + ","; } compositeEventID = compositeEventID.Substring(0, compositeEventID.Length - 1); String fe_compsite = "EventID In(" + compositeEventID + ")"; fe = SqlExpressionBuilder.PrepareFilterExpression(fe, SQLJoinType.AND, fe_compsite); } if (chbxFilter.Checked) { String fe3 = SqlExpressionBuilder.PrepareFilterExpression(CMNEventEntity.FLD_NAME_Title, txtSearchText.Text.ToString(), SQLMatchType.LikeWithBothMath); String fe4 = SqlExpressionBuilder.PrepareFilterExpression(CMNEventEntity.FLD_NAME_EventReferenceNo, txtSearchText.Text.ToString(), SQLMatchType.LikeWithBothMath); String fe5 = SqlExpressionBuilder.PrepareFilterExpression(fe3, SQLJoinType.OR, fe4); fe = SqlExpressionBuilder.PrepareFilterExpression(fe, SQLJoinType.AND, fe5); } e.InputParameters["filterExpression"] = fe; }
protected void btnSendMailToGuest_Click(object sender, EventArgs e) { //Mail will implement here. #region Guest Invitation Mail CMNEventEntity cMNEventEntity = FCCCMNEvent.GetFacadeCreate().GetByID(OverviewEventID); String MailBody = String.Empty; String Subject = String.Empty; StringBuilder sb = new StringBuilder(); sb.Append("Dear Sir,"); sb.Append("<br/>"); sb.Append("This is a auto generated mail from the ERP."); sb.Append("<br/>"); sb.Append("An Event has created."); sb.Append("<br/>"); sb.Append("Dated : " + cMNEventEntity.ExpectedStartDate.ToString(UIConstants.SHORT_DATE_FORMAT)); sb.Append("<br/>"); sb.Append("-"); sb.Append("<br/>"); sb.Append("Thanks"); sb.Append("<br/>"); sb.Append("ERP System"); MailBody = sb.ToString(); Subject = "ERP, Event"; String fe1 = SqlExpressionBuilder.PrepareFilterExpression(CMNEventInvitationInformationEntity.FLD_NAME_EventID, OverviewEventID.ToString(), SQLMatchType.Equal); String fe2 = SqlExpressionBuilder.PrepareFilterExpression(CMNEventInvitationInformationEntity.FLD_NAME_EventInvitatedPersonTypeID, MasterDataConstants.EventInvitationPersonType.GUEST.ToString(), SQLMatchType.Equal); String fe = SqlExpressionBuilder.PrepareFilterExpression(fe1, SQLJoinType.AND, fe2); IList <CMNEventInvitationInformationEntity> lstEventInvitationInformationEntity = FCCCMNEventInvitationInformation.GetFacadeCreate().GetIL(null, null, String.Empty, fe, DatabaseOperationType.LoadWithFilterExpression); if (lstEventInvitationInformationEntity != null && lstEventInvitationInformationEntity.Count > 0) { String[] sendToMail = new String[10]; // Should change here. Int64 i = 0; foreach (CMNEventInvitationInformationEntity ent in lstEventInvitationInformationEntity) { HRMemberEntity hRMemberEntity = FCCHRMember.GetFacadeCreate().GetByID(ent.InitationGivenToMemberID); if (hRMemberEntity != null && hRMemberEntity.MemberID > 0) { switch (hRMemberEntity.MemberTypeID) { case MasterDataConstants.MemberType.HR_MEMBER: String fe_member = SqlExpressionBuilder.PrepareFilterExpression(HREmployeeEntity.FLD_NAME_MemberID, ent.InitationGivenToMemberID.ToString(), SQLMatchType.Equal); IList <HREmployeeEntity> lsthREmployeeEntity = FCCHREmployee.GetFacadeCreate().GetIL(null, null, String.Empty, fe_member, DatabaseOperationType.LoadWithFilterExpression); if (lsthREmployeeEntity != null && lsthREmployeeEntity.Count > 0) { sendToMail[i++] = lsthREmployeeEntity[0].PrimaryEmail; } break; //Will Implement Later on... case MasterDataConstants.MemberType.CONSULATANT: break; //case MasterDataConstants.MemberType.CONSULATANT: // break; } } } MiscUtil.SendMail(sendToMail, Subject, MailBody); } #endregion }