//------------------------------------------------------------- // Transfers all of the database value to dbAdmin class. // //------------------------------------------------------------- public bool bLoadData(SqlDataReader sqlReader) { //--------------------------------------------------------- // If there are no data to be loaded we return false // for the condition. //--------------------------------------------------------- bool bReturn = false; while (sqlReader.Read() == true) { bReturn = true; //----------------------------------------------------- // Creating a new data node and initializing the members. //----------------------------------------------------- DBCampaignData Data = new DBCampaignData(); int iCount = sqlReader.FieldCount; string strFieldName = ""; int i = 0; for (i = 0; i < iCount; i++) { //------------------------------------------------- // Since some of the stored procedures do not bring back // data from all of the columns we have to protect // against this situation by checking the list of // field names. //------------------------------------------------- strFieldName = sqlReader.GetName(i).ToString(); if (sqlReader["DateCreated"] != DBNull.Value) { Data.dtDateCreated = Convert.ToDateTime(sqlReader["DateCreated"]); } else { Data.dtDateCreated = DateTime.Today; } if (sqlReader["DateModified"] != DBNull.Value) { Data.dtDateModified = Convert.ToDateTime(sqlReader["DateModified"]); } else { Data.dtDateModified = DateTime.Today; } if (sqlReader["StartTime"] != DBNull.Value) { Data.dtStartTime = Convert.ToDateTime(sqlReader["StartTime"]); } else { Data.dtStartTime = DateTime.Today; } if (sqlReader["StopTime"] != DBNull.Value) { Data.dtStopTime = Convert.ToDateTime(sqlReader["StopTime"]); } else { Data.dtStopTime = DateTime.Today; } if (sqlReader["Allow7DigitNums"] != DBNull.Value) { Data.bAllow7DigitNums = Convert.ToBoolean(sqlReader["Allow7DigitNums"]); } else { Data.bAllow7DigitNums = false; } if (sqlReader["AllowDuplicatePhones"] != DBNull.Value) { Data.bAllowDuplicatePhones = Convert.ToBoolean(sqlReader["AllowDuplicatePhones"]); } else { Data.bAllowDuplicatePhones = false; } if (sqlReader["DialAllNumbers"] != DBNull.Value) { Data.bDialAllNumbers = Convert.ToBoolean(sqlReader["DialAllNumbers"]); } else { Data.bDialAllNumbers = false; } if (sqlReader["EnableAgentTraining"] != DBNull.Value) { Data.bEnableAgentTraining = Convert.ToBoolean(sqlReader["EnableAgentTraining"]); } else { Data.bEnableAgentTraining = false; } if (sqlReader["FlushCallQueueOnIdle"] != DBNull.Value) { Data.bFlushCallQueueOnIdle = Convert.ToBoolean(sqlReader["FlushCallQueueOnIdle"]); } else { Data.bFlushCallQueueOnIdle = false; } if (sqlReader["FundRaiserDataTracking"] != DBNull.Value) { Data.bFundRaiserDataTracking = Convert.ToBoolean(sqlReader["FundRaiserDataTracking"]); } else { Data.bFundRaiserDataTracking = false; } if (sqlReader["IsDeleted"] != DBNull.Value) { Data.bIsDeleted = Convert.ToBoolean(sqlReader["IsDeleted"]); } else { Data.bIsDeleted = false; } if (sqlReader["RecordLevelCallHistory"] != DBNull.Value) { Data.bRecordLevelCallHistory = Convert.ToBoolean(sqlReader["RecordLevelCallHistory"]); } else { Data.bRecordLevelCallHistory = false; } if (sqlReader["CampaignDBConnString"] != DBNull.Value) { Data.strCampaignDBConnString = sqlReader["CampaignDBConnString"].ToString(); } else { Data.strCampaignDBConnString = ""; } if (sqlReader["Description"] != DBNull.Value) { Data.strDescription = sqlReader["Description"].ToString(); } else { Data.strDescription = ""; } if (sqlReader["DuplicateRule"] != DBNull.Value) { Data.strDuplicateRule = sqlReader["DuplicateRule"].ToString(); } else { Data.strDuplicateRule = ""; } if (sqlReader["OutboundCallerID"] != DBNull.Value) { Data.strOutboundCallerID = sqlReader["OutboundCallerID"].ToString(); } else { Data.strOutboundCallerID = ""; } if (sqlReader["ShortDescription"] != DBNull.Value) { Data.strShortDescription = sqlReader["ShortDescription"].ToString(); } else { Data.strShortDescription = ""; } if (sqlReader["Allow10DigitNums"] != DBNull.Value) { Data.bAllow10DigitNums = Convert.ToBoolean(sqlReader["Allow10DigitNums"]); } else { Data.bAllow10DigitNums = false; } if (strFieldName == "CampaignID" && sqlReader["CampaignID"] != DBNull.Value) { Data.iCampaignID = Convert.ToInt64(sqlReader["CampaignID"]); } else if (strFieldName == "StatusID" && sqlReader["StatusID"] != DBNull.Value) { Data.iStatusID = Convert.ToInt64(sqlReader["StatusID"]); } } DataList.Add(Data); } return(bReturn); }
//------------------------------------------------------------- // Updates the Campaign table data. // // //------------------------------------------------------------- public bool bUpdate(DBCampaignData dbCampaignData) { bool bReturn = true; DBAccess dbAccess = Global.dbAccess; //---------------------------------------------------------- // Create the Command and the Connection. //---------------------------------------------------------- string strConnString = WebConfigurationManager.ConnectionStrings["RainmakerMasterConnectionString"].ConnectionString; SqlConnection con = new SqlConnection(strConnString); string strSQL = "pCampaign_Update "; strSQL = dbAccess.AddParamToSQLCmd(strSQL, "@CampaignDBConnString ", dbCampaignData.strCampaignDBConnString, SqlDbType.VarChar, false, null); strSQL = dbAccess.AddParamToSQLCmd(strSQL, "@Description ", dbCampaignData.strDescription, SqlDbType.VarChar, false, null); strSQL = dbAccess.AddParamToSQLCmd(strSQL, "@DuplicateRule ", dbCampaignData.strDuplicateRule, SqlDbType.VarChar, false, null); strSQL = dbAccess.AddParamToSQLCmd(strSQL, "@OutboundCallerID ", dbCampaignData.strOutboundCallerID, SqlDbType.VarChar, false, null); strSQL = dbAccess.AddParamToSQLCmd(strSQL, "@ShortDescription ", dbCampaignData.strShortDescription, SqlDbType.VarChar, false, null); strSQL = dbAccess.AddParamToSQLCmd(strSQL, "@iCampaignID ", dbCampaignData.iCampaignID, SqlDbType.Int, false, null); strSQL = dbAccess.AddParamToSQLCmd(strSQL, "@iStatusID ", dbCampaignData.iStatusID, SqlDbType.Int, false, null); if (dbCampaignData.bAllow7DigitNums == false) { strSQL = dbAccess.AddParamToSQLCmd(strSQL, "@Allow7DigitNums ", 1, SqlDbType.Bit, false, null); } else { strSQL = dbAccess.AddParamToSQLCmd(strSQL, "@Allow7DigitNums ", 0, SqlDbType.Bit, false, null); } if (dbCampaignData.bAllowDuplicatePhones == false) { strSQL = dbAccess.AddParamToSQLCmd(strSQL, "@AllowDuplicatePhones ", 1, SqlDbType.Bit, false, null); } else { strSQL = dbAccess.AddParamToSQLCmd(strSQL, "@AllowDuplicatePhones ", 0, SqlDbType.Bit, false, null); } if (dbCampaignData.bDialAllNumbers == false) { strSQL = dbAccess.AddParamToSQLCmd(strSQL, "@DialAllNumbers ", 1, SqlDbType.Bit, false, null); } else { strSQL = dbAccess.AddParamToSQLCmd(strSQL, "@DialAllNumbers ", 0, SqlDbType.Bit, false, null); } if (dbCampaignData.bEnableAgentTraining == false) { strSQL = dbAccess.AddParamToSQLCmd(strSQL, "@EnableAgentTraining ", 1, SqlDbType.Bit, false, null); } else { strSQL = dbAccess.AddParamToSQLCmd(strSQL, "@EnableAgentTraining ", 0, SqlDbType.Bit, false, null); } if (dbCampaignData.bFlushCallQueueOnIdle == false) { strSQL = dbAccess.AddParamToSQLCmd(strSQL, "@FlushCallQueueOnIdle ", 1, SqlDbType.Bit, false, null); } else { strSQL = dbAccess.AddParamToSQLCmd(strSQL, "@FlushCallQueueOnIdle ", 0, SqlDbType.Bit, false, null); } if (dbCampaignData.bFundRaiserDataTracking == false) { strSQL = dbAccess.AddParamToSQLCmd(strSQL, "@FundRaiserDataTracking ", 1, SqlDbType.Bit, false, null); } else { strSQL = dbAccess.AddParamToSQLCmd(strSQL, "@FundRaiserDataTracking ", 0, SqlDbType.Bit, false, null); } if (dbCampaignData.bIsDeleted == false) { strSQL = dbAccess.AddParamToSQLCmd(strSQL, "@IsDeleted ", 1, SqlDbType.Bit, false, null); } else { strSQL = dbAccess.AddParamToSQLCmd(strSQL, "@IsDeleted ", 0, SqlDbType.Bit, false, null); } if (dbCampaignData.bOnsiteTransfer == false) { strSQL = dbAccess.AddParamToSQLCmd(strSQL, "@OnsiteTransfer ", 1, SqlDbType.Bit, false, null); } else { strSQL = dbAccess.AddParamToSQLCmd(strSQL, "@OnsiteTransfer ", 0, SqlDbType.Bit, false, null); } if (dbCampaignData.bRecordLevelCallHistory == false) { strSQL = dbAccess.AddParamToSQLCmd(strSQL, "@RecordLevelCallHistory ", 1, SqlDbType.Bit, false, null); } else { strSQL = dbAccess.AddParamToSQLCmd(strSQL, "@RecordLevelCallHistory ", 0, SqlDbType.Bit, false, null); } if (dbCampaignData.bAllow10DigitNums == false) { strSQL = dbAccess.AddParamToSQLCmd(strSQL, "@Allow10DigitNums ", 1, SqlDbType.Bit, false, null); } else { strSQL = dbAccess.AddParamToSQLCmd(strSQL, "@Allow10DigitNums ", 0, SqlDbType.Bit, false, null); } strSQL = dbAccess.AddParamToSQLCmd(strSQL, "@DateCreated", dbCampaignData.dtDateCreated, SqlDbType.DateTime, false, null); strSQL = dbAccess.AddParamToSQLCmd(strSQL, "@DateModified", dbCampaignData.dtDateModified, SqlDbType.DateTime, false, null); strSQL = dbAccess.AddParamToSQLCmd(strSQL, "@StartTime", dbCampaignData.dtStartTime, SqlDbType.DateTime, false, null); strSQL = dbAccess.AddParamToSQLCmd(strSQL, "@StopTime", dbCampaignData.dtStopTime, SqlDbType.DateTime, true, null); try { SqlCommand cmd = new SqlCommand(strSQL, con); //------------------------------------------------------- // Open the Connection and get the DataReader. //------------------------------------------------------- con.Open(); cmd.ExecuteNonQuery(); } catch { bReturn = false; }; con.Close(); return(bReturn); }