Int64 ICMNEventInvitationInformationDataAccess.Add(CMNEventInvitationInformationEntity cMNEventInvitationInformationEntity, DatabaseOperationType option, TransactionRequired reqTran) { try { long retValues = -99; switch (reqTran) { case TransactionRequired.No: { retValues = Add(cMNEventInvitationInformationEntity, option); break; } case TransactionRequired.Yes: { retValues = AddTran(cMNEventInvitationInformationEntity, option); break; } default: { retValues = -99; break; } } return(retValues); } catch (Exception ex) { throw ex; } }
private Int64 UpdateTran(CMNEventInvitationInformationEntity cMNEventInvitationInformationEntity, String filterExpression, DatabaseOperationType option) { long returnCode = -99; const string SP = "dbo.CMNEventInvitationInformation_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, "@EventInvitationInformationID", DbType.Int64, cMNEventInvitationInformationEntity.EventInvitationInformationID); db.AddInParameter(cmd, "@EventID", DbType.Int64, cMNEventInvitationInformationEntity.EventID); db.AddInParameter(cmd, "@InitationGivenByMemberID", DbType.Int64, cMNEventInvitationInformationEntity.InitationGivenByMemberID); db.AddInParameter(cmd, "@SharedDateTime", DbType.DateTime, cMNEventInvitationInformationEntity.SharedDateTime); db.AddInParameter(cmd, "@Message", DbType.String, cMNEventInvitationInformationEntity.Message); db.AddInParameter(cmd, "@InitationGivenToMemberID", DbType.Int64, cMNEventInvitationInformationEntity.InitationGivenToMemberID); db.AddInParameter(cmd, "@EventInvitatedPersonTypeID", DbType.Int64, cMNEventInvitationInformationEntity.EventInvitatedPersonTypeID); db.AddInParameter(cmd, "@IsGuestGoing", DbType.Boolean, cMNEventInvitationInformationEntity.IsGuestGoing); db.AddInParameter(cmd, "@IP", DbType.String, cMNEventInvitationInformationEntity.IP); 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 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); } } }
private Int64 DeleteTran(CMNEventInvitationInformationEntity cMNEventInvitationInformationEntity, String filterExpression, DatabaseOperationType option) { long returnCode = -99; const string SP = "dbo.CMNEventInvitationInformation_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 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); } } } }
private Int64 Update(CMNEventInvitationInformationEntity cMNEventInvitationInformationEntity, String filterExpression, DatabaseOperationType option) { long returnCode = -99; const string SP = "dbo.CMNEventInvitationInformation_SET"; using (DbCommand cmd = Database.GetStoredProcCommand(SP)) { AddOptionParameter(cmd, option); AddOutputParameter(cmd); AddFilterExpressionParameter(cmd, filterExpression); Database.AddInParameter(cmd, "@EventInvitationInformationID", DbType.Int64, cMNEventInvitationInformationEntity.EventInvitationInformationID); Database.AddInParameter(cmd, "@EventID", DbType.Int64, cMNEventInvitationInformationEntity.EventID); Database.AddInParameter(cmd, "@InitationGivenByMemberID", DbType.Int64, cMNEventInvitationInformationEntity.InitationGivenByMemberID); Database.AddInParameter(cmd, "@SharedDateTime", DbType.DateTime, cMNEventInvitationInformationEntity.SharedDateTime); Database.AddInParameter(cmd, "@Message", DbType.String, cMNEventInvitationInformationEntity.Message); Database.AddInParameter(cmd, "@InitationGivenToMemberID", DbType.Int64, cMNEventInvitationInformationEntity.InitationGivenToMemberID); Database.AddInParameter(cmd, "@EventInvitatedPersonTypeID", DbType.Int64, cMNEventInvitationInformationEntity.EventInvitatedPersonTypeID); Database.AddInParameter(cmd, "@IsGuestGoing", DbType.Boolean, cMNEventInvitationInformationEntity.IsGuestGoing); Database.AddInParameter(cmd, "@IP", DbType.String, cMNEventInvitationInformationEntity.IP); using (IDataReader reader = Database.ExecuteReader(cmd)) { returnCode = GetReturnCodeFromParameter(cmd); switch (returnCode) { case SqlConstants.DB_STATUS_CODE_DATAALREADYEXIST: { throw new ArgumentException("CMNEventInvitationInformationEntity already exists. Please specify another CMNEventInvitationInformationEntity."); } case SqlConstants.DB_STATUS_CODE_DATAUPDATEDFROMOTHERSESSION: { throw new ArgumentException("CMNEventInvitationInformationEntity data already updated from different session."); } case SqlConstants.DB_STATUS_CODE_FAIL_OPERATION: { throw new ArgumentException("CMNEventInvitationInformationEntity already exists. Please specify another CMNEventInvitationInformationEntity."); } } } } return(returnCode); }
private CMNEventInvitationInformationEntity BuildCMNEventInvitationInformationEntity() { CMNEventInvitationInformationEntity cMNEventInvitationInformationEntity = CurrentCMNEventInvitationInformationEntity; if (OverviewEventID > 0) { cMNEventInvitationInformationEntity.EventID = OverviewEventID; } cMNEventInvitationInformationEntity.InitationGivenByMemberID = CurrentMember.MemberID; cMNEventInvitationInformationEntity.SharedDateTime = DateTime.Now; cMNEventInvitationInformationEntity.Message = txtMessage.Text.Trim(); if (ddlInitationGivenToMemberID.Items.Count > 0) { if (ddlInitationGivenToMemberID.SelectedValue == "0") { } else { cMNEventInvitationInformationEntity.InitationGivenToMemberID = Int64.Parse(ddlInitationGivenToMemberID.SelectedValue); } } if (ddlEventInvitatedPersonTypeID.Items.Count > 0) { if (ddlEventInvitatedPersonTypeID.SelectedValue == "0") { } else { cMNEventInvitationInformationEntity.EventInvitatedPersonTypeID = Int64.Parse(ddlEventInvitatedPersonTypeID.SelectedValue); } } cMNEventInvitationInformationEntity.IsGuestGoing = false; cMNEventInvitationInformationEntity.IP = MiscUtil.GetLocalIP(); return(cMNEventInvitationInformationEntity); }
private void PrepareEditView() { CMNEventInvitationInformationEntity cMNEventInvitationInformationEntity = CurrentCMNEventInvitationInformationEntity; if (!cMNEventInvitationInformationEntity.IsNew) { if (ddlInitationGivenToMemberID.Items.Count > 0 && cMNEventInvitationInformationEntity.InitationGivenToMemberID != null) { ddlInitationGivenToMemberID.SelectedValue = cMNEventInvitationInformationEntity.InitationGivenToMemberID.ToString(); } if (ddlEventInvitatedPersonTypeID.Items.Count > 0 && cMNEventInvitationInformationEntity.EventInvitatedPersonTypeID != null) { ddlEventInvitatedPersonTypeID.SelectedValue = cMNEventInvitationInformationEntity.EventInvitatedPersonTypeID.ToString(); } txtMessage.Text = cMNEventInvitationInformationEntity.Message.ToString(); btnSubmit.Text = "Update"; btnAddNew.Visible = true; } }
private Int64 Delete(CMNEventInvitationInformationEntity cMNEventInvitationInformationEntity, String filterExpression, DatabaseOperationType option) { long returnCode = -99; const string SP = "dbo.CMNEventInvitationInformation_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("CMNEventInvitationInformationEntity already exists. Please specify another CMNEventInvitationInformationEntity."); } case SqlConstants.DB_STATUS_CODE_DATAUPDATEDFROMOTHERSESSION: { throw new ArgumentException("CMNEventInvitationInformationEntity data already updated from different session."); } case SqlConstants.DB_STATUS_CODE_FAIL_OPERATION: { throw new ArgumentException("CMNEventInvitationInformationEntity already exists. Please specify another CMNEventInvitationInformationEntity."); } } } } return(returnCode); }
Int64 ICMNEventInvitationInformationFacade.Delete(CMNEventInvitationInformationEntity cMNEventInvitationInformationEntity, String filterExpression, DatabaseOperationType option, TransactionRequired reqTran) { return(DataAccessFactory.CreateCMNEventInvitationInformationDataAccess().Delete(cMNEventInvitationInformationEntity, filterExpression, option, reqTran)); }
Int64 ICMNEventInvitationInformationFacade.Add(CMNEventInvitationInformationEntity cMNEventInvitationInformationEntity, DatabaseOperationType option, TransactionRequired reqTran) { return(DataAccessFactory.CreateCMNEventInvitationInformationDataAccess().Add(cMNEventInvitationInformationEntity, option, reqTran)); }
protected void btnAddNew_Click(object sender, EventArgs e) { _EventInvitationInformationID = 0; _CMNEventInvitationInformationEntity = new CMNEventInvitationInformationEntity(); PrepareInitialView(); }