public void DeletePigeon(string dbSource, Int64 PigeonID) { try { dbconn = new DatabaseConnection(dbSource); dbconn.DatabaseConn("DeletePigeon"); if (dbconn.sqlConn.State == ConnectionState.Open) { dbconn.sqlConn.Close(); } dbconn.sqlConn.Open(); dbconn.sqlComm.CommandTimeout = 0; dbconn.sqlComm.Parameters.Clear(); dbconn.sqlComm.Parameters.AddWithValue("@PigeonID", PigeonID); dbconn.sqlComm.ExecuteNonQuery(); dbconn.sqlConn.Close(); } catch (Exception ex) { throw ex; } finally { dbconn.sqlConn.Close(); dbconn.sqlConn.Dispose(); SqlConnection.ClearPool(dbconn.sqlConn); } }
public void UpdateInboxImport(string dbSource, string id, string replyMessage, string keyword) { try { DataSet dtResult = new DataSet(); dbconn = new DatabaseConnection(dbSource); dbconn.DatabaseConn("UpdateInboxImport"); if (dbconn.sqlConn.State == ConnectionState.Open) { dbconn.sqlConn.Close(); } dbconn.sqlConn.Open(); dbconn.sqlComm.CommandTimeout = 0; dbconn.sqlComm.Parameters.Clear(); dbconn.sqlComm.Parameters.AddWithValue("@ID", id); dbconn.sqlComm.Parameters.AddWithValue("@ReplyMessage", replyMessage); dbconn.sqlComm.Parameters.AddWithValue("@Keyword", keyword); dbconn.sqlComm.ExecuteNonQuery(); dbconn.sqlConn.Close(); } catch (Exception ex) { throw ex; } finally { dbconn.sqlConn.Close(); dbconn.sqlConn.Dispose(); SqlConnection.ClearPool(dbconn.sqlConn); } }
public DataSet GetPigeonDetails(string dbSource, Int64 PigeonID) { try { DataSet dtResult = new DataSet(); dbconn = new DatabaseConnection(dbSource); dbconn.DatabaseConn("GetPigeonDetails"); if (dbconn.sqlConn.State == ConnectionState.Open) { dbconn.sqlConn.Close(); } dbconn.sqlConn.Open(); dbconn.sqlComm.CommandTimeout = 0; dbconn.sqlComm.Parameters.Clear(); dbconn.sqlComm.Parameters.AddWithValue("@PigeonID", PigeonID); SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = dbconn.sqlComm; da.Fill(dtResult); dbconn.sqlConn.Close(); return(dtResult); } catch (Exception ex) { throw ex; } finally { dbconn.sqlConn.Close(); dbconn.sqlConn.Dispose(); SqlConnection.ClearPool(dbconn.sqlConn); } }
public DataSet UpdateInboxReply(string dbSource, string ID) { try { DataSet dtResult = new DataSet(); dbconn = new DatabaseConnection(dbSource); dbconn.DatabaseConn("UpdateInboxReply"); if (dbconn.sqlConn.State == ConnectionState.Open) { dbconn.sqlConn.Close(); } dbconn.sqlConn.Open(); dbconn.sqlComm.CommandTimeout = 0; dbconn.sqlComm.Parameters.Clear(); dbconn.sqlComm.Parameters.AddWithValue("@ID", ID); dbconn.sqlComm.ExecuteNonQuery(); dbconn.sqlConn.Close(); return(dtResult); } catch (Exception ex) { throw ex; } finally { dbconn.sqlConn.Close(); dbconn.sqlConn.Dispose(); SqlConnection.ClearPool(dbconn.sqlConn); } }
private DataSet GetClubForUpdate(string dbSource, string smscontent) { try { DataSet dtResult = new DataSet(); dbconn = new DatabaseConnection(dbSource); dbconn.DatabaseConn("GetClubPilipinasKalapati"); if (dbconn.sqlConn.State == ConnectionState.Open) { dbconn.sqlConn.Close(); } dbconn.sqlConn.Open(); dbconn.sqlComm.CommandTimeout = 0; dbconn.sqlComm.Parameters.Clear(); dbconn.sqlComm.Parameters.AddWithValue("@SMSContent", smscontent); dbconn.sqlComm.Parameters.Add("@ClubName", SqlDbType.VarChar, 5000).Direction = ParameterDirection.Output; SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = dbconn.sqlComm; da.Fill(dtResult); dbconn.sqlConn.Close(); return(dtResult); } catch (Exception ex) { throw ex; } }
private string UpdateClub(string dbSource, string smscontent) { try { string clubName = ""; DataSet dtResult = new DataSet(); dbconn = new DatabaseConnection(dbSource); if (Common.GetConnStringTypeSource() == "local") //for club backup storage { clubName = Common.DBName(); } else { dbconn.DatabaseConn("GetClubPilipinasKalapati"); if (dbconn.sqlConn.State == ConnectionState.Open) { dbconn.sqlConn.Close(); } dbconn.sqlConn.Open(); dbconn.sqlComm.CommandTimeout = 0; dbconn.sqlComm.Parameters.Clear(); dbconn.sqlComm.Parameters.AddWithValue("@SMSContent", smscontent); dbconn.sqlComm.Parameters.Add("@ClubName", SqlDbType.VarChar, 5000).Direction = ParameterDirection.Output; dbconn.sqlComm.ExecuteNonQuery(); clubName = Convert.ToString(dbconn.sqlComm.Parameters["@ClubName"].Value); dbconn.sqlConn.Close(); } return(clubName); } catch (Exception ex) { throw ex; } }
public DataSet GetSMSModemID(string dbSource) { try { DataSet dataResult = new DataSet(); dbconn = new DatabaseConnection(dbSource); dbconn.DatabaseConn("SMSViewer_GetModemIDImport"); if (dbconn.sqlConn.State == ConnectionState.Open) { dbconn.sqlConn.Close(); } dbconn.sqlConn.Open(); dbconn.sqlComm.Parameters.Clear(); SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = dbconn.sqlComm; da.Fill(dataResult); dbconn.sqlConn.Close(); return(dataResult); } catch (Exception ex) { throw ex; } finally { dbconn.sqlConn.Close(); dbconn.sqlConn.Dispose(); SqlConnection.ClearPool(dbconn.sqlConn); } }
public void SaveInbox(string dbSource, string SMSID, string SMSContent, string Sender, string SMSDate, string SMSTime, string ActivationCode, string ModemID, string Isprocess, string Source, out string ReplyMessage, out string Keyword) { try { DataSet dtResult = new DataSet(); string clubname = ValidateClub("local", SMSContent); dbconn = new DatabaseConnection(dbSource); dbconn.DatabaseConn("InboxSave", clubname); if (dbconn.sqlConn.State == ConnectionState.Open) { dbconn.sqlConn.Close(); } dbconn.sqlConn.Open(); dbconn.sqlComm.CommandTimeout = 0; dbconn.sqlComm.Parameters.Clear(); dbconn.sqlComm.Parameters.AddWithValue("@SMSID", SMSID); dbconn.sqlComm.Parameters.AddWithValue("@SMSContent", SMSContent); dbconn.sqlComm.Parameters.AddWithValue("@Sender", Sender); dbconn.sqlComm.Parameters.AddWithValue("@SMSDate", SMSDate); dbconn.sqlComm.Parameters.AddWithValue("@SMSTime", SMSTime); dbconn.sqlComm.Parameters.AddWithValue("@ActivationCode", ActivationCode); dbconn.sqlComm.Parameters.AddWithValue("@ModemID", ModemID); dbconn.sqlComm.Parameters.AddWithValue("@Isprocess", Isprocess); dbconn.sqlComm.Parameters.AddWithValue("@Source", Source); dbconn.sqlComm.Parameters.AddWithValue("@IsImport", true); if (clubname != "") { dbconn.sqlComm.Parameters.AddWithValue("@IsFromPilipinasKalapati", true); } dbconn.sqlComm.Parameters.Add("@ReplyMessage", SqlDbType.VarChar, 5000).Direction = ParameterDirection.Output; dbconn.sqlComm.Parameters.Add("@Keyword", SqlDbType.VarChar, 5000).Direction = ParameterDirection.Output; dbconn.sqlComm.ExecuteNonQuery(); //Return ReplyMessage to save in the local table ReplyMessage = Convert.ToString(dbconn.sqlComm.Parameters["@ReplyMessage"].Value); Keyword = Convert.ToString(dbconn.sqlComm.Parameters["@Keyword"].Value); dbconn.sqlConn.Close(); //return ReplyMessage; } catch (Exception ex) { throw ex; } finally { dbconn.sqlConn.Close(); dbconn.sqlConn.Dispose(); SqlConnection.ClearPool(dbconn.sqlConn); } }
public DataSet MemberSave(string dbSource, string MemberIDNo, string MemberName, Int64 PigeonID, string BandNumber, string Sex, string Color, Byte[] Photo) { try { DataSet dtResult = new DataSet(); dbconn = new DatabaseConnection(dbSource); dbconn.DatabaseConn("MemberSave"); if (dbconn.sqlConn.State == ConnectionState.Open) { dbconn.sqlConn.Close(); } dbconn.sqlConn.Open(); dbconn.sqlComm.CommandTimeout = 0; dbconn.sqlComm.Parameters.Clear(); dbconn.sqlComm.Parameters.AddWithValue("@MemberIDNo", MemberIDNo); dbconn.sqlComm.Parameters.AddWithValue("@MemberName", MemberName); dbconn.sqlComm.Parameters.AddWithValue("@PigeonID", PigeonID); dbconn.sqlComm.Parameters.AddWithValue("@BandNumber", BandNumber); dbconn.sqlComm.Parameters.AddWithValue("@Sex", Sex); dbconn.sqlComm.Parameters.AddWithValue("@Color", Color); dbconn.sqlComm.Parameters.AddWithValue("@Photo", Photo); SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = dbconn.sqlComm; da.Fill(dtResult); dbconn.sqlConn.Close(); return(dtResult); } catch (Exception ex) { throw ex; } finally { dbconn.sqlConn.Close(); dbconn.sqlConn.Dispose(); SqlConnection.ClearPool(dbconn.sqlConn); } }
public void SaveInboxLocal(string dbSource, string SMSID, string SMSContent, string Sender, string SMSDate, string SMSTime, string ActivationCode, string ModemID, string Isprocess, string Source, string ReplyMessage, string Keyword) { try { DataSet dtResult = new DataSet(); dbconn = new DatabaseConnection(dbSource); dbconn.DatabaseConn("InboxSave"); if (dbconn.sqlConn.State == ConnectionState.Open) { dbconn.sqlConn.Close(); } dbconn.sqlConn.Open(); dbconn.sqlComm.CommandTimeout = 0; dbconn.sqlComm.Parameters.Clear(); dbconn.sqlComm.Parameters.AddWithValue("@SMSID", SMSID); dbconn.sqlComm.Parameters.AddWithValue("@SMSContent", SMSContent); dbconn.sqlComm.Parameters.AddWithValue("@Sender", Sender); dbconn.sqlComm.Parameters.AddWithValue("@SMSDate", SMSDate); dbconn.sqlComm.Parameters.AddWithValue("@SMSTime", SMSTime); dbconn.sqlComm.Parameters.AddWithValue("@ActivationCode", ActivationCode); dbconn.sqlComm.Parameters.AddWithValue("@ModemID", ModemID); dbconn.sqlComm.Parameters.AddWithValue("@Isprocess", Isprocess); dbconn.sqlComm.Parameters.AddWithValue("@Source", Source); dbconn.sqlComm.Parameters.AddWithValue("@IsImport", true); dbconn.sqlComm.Parameters.AddWithValue("@ReplyMessage", ReplyMessage); dbconn.sqlComm.Parameters.AddWithValue("@Keyword", @Keyword); dbconn.sqlComm.ExecuteNonQuery(); dbconn.sqlConn.Close(); } catch (Exception ex) { throw ex; } finally { dbconn.sqlConn.Close(); dbconn.sqlConn.Dispose(); SqlConnection.ClearPool(dbconn.sqlConn); } }
public DataSet GetRecordForReply(string dbSource, string activationcode, string inboxID) { try { DataSet dtResult = new DataSet(); dbconn = new DatabaseConnection(dbSource); dbconn.DatabaseConn("GetRecordForReply"); if (dbconn.sqlConn.State == ConnectionState.Open) { dbconn.sqlConn.Close(); } dbconn.sqlConn.Open(); dbconn.sqlComm.CommandTimeout = 0; dbconn.sqlComm.Parameters.Clear(); dbconn.sqlComm.Parameters.AddWithValue("@activationcode", activationcode); dbconn.sqlComm.Parameters.AddWithValue("@inboxID", inboxID); SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = dbconn.sqlComm; da.Fill(dtResult); dbconn.sqlConn.Close(); return(dtResult); } catch (Exception ex) { throw ex; } finally { dbconn.sqlConn.Close(); dbconn.sqlConn.Dispose(); SqlConnection.ClearPool(dbconn.sqlConn); } }
public DataSet SMSGatewayOutboxSave(string dbSource, string SMSContent, string Keyword, string Sender, string Status, string InboxID) { try { DataSet dtResult = new DataSet(); dbconn = new DatabaseConnection(dbSource); dbconn.DatabaseConn("SMSGatewayOutboxSave"); if (dbconn.sqlConn.State == ConnectionState.Open) { dbconn.sqlConn.Close(); } dbconn.sqlConn.Open(); dbconn.sqlComm.CommandTimeout = 0; dbconn.sqlComm.Parameters.Clear(); dbconn.sqlComm.Parameters.AddWithValue("@SMSContent", SMSContent); dbconn.sqlComm.Parameters.AddWithValue("@Keyword", Keyword); dbconn.sqlComm.Parameters.AddWithValue("@MobileNumber", Sender); dbconn.sqlComm.Parameters.AddWithValue("@Status", Status); dbconn.sqlComm.Parameters.AddWithValue("@InboxID", InboxID); dbconn.sqlComm.ExecuteNonQuery(); dbconn.sqlConn.Close(); return(dtResult); } catch (Exception ex) { throw ex; } finally { dbconn.sqlConn.Close(); dbconn.sqlConn.Dispose(); SqlConnection.ClearPool(dbconn.sqlConn); } }