public DataSet GetDetails(string clubID)
{
try
{
DataSet dtResult = new DataSet();
dbconn = new MAVC_IntegrationV2.DatabaseConnection("web");
dbconn.DatabaseConn("ClubSearchByKey");
if (dbconn.sqlConn.State == ConnectionState.Open)
{
dbconn.sqlConn.Close();
}
dbconn.sqlConn.Open();
dbconn.sqlComm.CommandTimeout = 0;
dbconn.sqlComm.Parameters.Clear();
dbconn.sqlComm.Parameters.AddWithValue("@UserID", -1);
dbconn.sqlComm.Parameters.AddWithValue("@ClubID", clubID);
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = dbconn.sqlComm;
da.Fill(dtResult);
dbconn.sqlConn.Close();
return(dtResult);
}
catch (Exception ex)
{
throw ex;
}
}
public void SaveDetails(DataTable dt, string action)
{
try
{
DataSet dtResult = new DataSet();
dbconn = new MAVC_IntegrationV2.DatabaseConnection("local");
dbconn.DatabaseConn("Integrate_BandNumber");
if (dbconn.sqlConn.State == ConnectionState.Open)
{
dbconn.sqlConn.Close();
}
dbconn.sqlConn.Open();
dbconn.sqlComm.CommandTimeout = 0;
dbconn.sqlComm.Parameters.Clear();
dbconn.sqlComm.Parameters.AddWithValue("@BandID", dt.Rows[0]["BandID"].ToString());
dbconn.sqlComm.Parameters.AddWithValue("@ClubID", dt.Rows[0]["ClubID"].ToString());
dbconn.sqlComm.Parameters.AddWithValue("@MemberID", dt.Rows[0]["MemberID"].ToString());
dbconn.sqlComm.Parameters.AddWithValue("@BandNumber", dt.Rows[0]["BandNumber"].ToString());
dbconn.sqlComm.Parameters.AddWithValue("@Action", action);
dbconn.sqlComm.ExecuteNonQuery();
dbconn.sqlConn.Close();
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet GetFileNote()
{
try
{
DataSet dtResult = new DataSet();
dbconn = new DatabaseConnection("local");
dbconn.DatabaseConn("FileNotesGetAll");
if (dbconn.sqlConn.State == ConnectionState.Open)
{
dbconn.sqlConn.Close();
}
dbconn.sqlConn.Open();
dbconn.sqlComm.CommandTimeout = 0;
dbconn.sqlComm.Parameters.Clear();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = dbconn.sqlComm;
da.Fill(dtResult);
dbconn.sqlConn.Close();
return(dtResult);
}
catch (Exception ex)
{
throw ex;
}
}
public void SaveDetails(DataTable dt, string action)
{
try
{
DataSet dtResult = new DataSet();
dbconn = new MAVC_IntegrationV2.DatabaseConnection("local");
dbconn.DatabaseConn("Integrate_Club");
if (dbconn.sqlConn.State == ConnectionState.Open)
{
dbconn.sqlConn.Close();
}
dbconn.sqlConn.Open();
dbconn.sqlComm.CommandTimeout = 0;
dbconn.sqlComm.Parameters.Clear();
dbconn.sqlComm.Parameters.AddWithValue("@ClubID", dt.Rows[0]["ClubID"].ToString());
dbconn.sqlComm.Parameters.AddWithValue("@ClubAbbreviation", dt.Rows[0]["ClubAbbreviation"].ToString());
dbconn.sqlComm.Parameters.AddWithValue("@ClubName", dt.Rows[0]["ClubName"].ToString());
dbconn.sqlComm.Parameters.AddWithValue("@DateFounded", dt.Rows[0]["DateFounded"].ToString());
dbconn.sqlComm.Parameters.AddWithValue("@DistanceLatDegree", dt.Rows[0]["DistanceLatDegree"].ToString());
dbconn.sqlComm.Parameters.AddWithValue("@DistanceLatMinutes", dt.Rows[0]["DistanceLatMinutes"].ToString());
dbconn.sqlComm.Parameters.AddWithValue("@DistanceLatSecond", dt.Rows[0]["DistanceLatSecond"].ToString());
dbconn.sqlComm.Parameters.AddWithValue("@DistanceLatSign", dt.Rows[0]["DistanceLatSign"].ToString());
dbconn.sqlComm.Parameters.AddWithValue("@DistanceLongDegree", dt.Rows[0]["DistanceLongDegree"].ToString());
dbconn.sqlComm.Parameters.AddWithValue("@DistanceLongMinutes", dt.Rows[0]["DistanceLongMinutes"].ToString());
dbconn.sqlComm.Parameters.AddWithValue("@DistanceLongSecond", dt.Rows[0]["DistanceLongSecond"].ToString());
dbconn.sqlComm.Parameters.AddWithValue("@DistanceLongSign", dt.Rows[0]["DistanceLongSign"].ToString());
dbconn.sqlComm.Parameters.AddWithValue("@IsActive", dt.Rows[0]["IsActive"].ToString());
dbconn.sqlComm.Parameters.AddWithValue("@Version", dt.Rows[0]["Version"].ToString());
dbconn.sqlComm.Parameters.AddWithValue("@DateTimeSource", dt.Rows[0]["DateTimeSource"].ToString());
dbconn.sqlComm.Parameters.AddWithValue("@IsBackup", dt.Rows[0]["IsBackup"].ToString());
dbconn.sqlComm.Parameters.AddWithValue("@IsMAVCStickerUsed", dt.Rows[0]["IsMAVCStickerUsed"].ToString());
dbconn.sqlComm.Parameters.AddWithValue("@LastSubcription", dt.Rows[0]["LastSubcription"].ToString());
dbconn.sqlComm.Parameters.AddWithValue("@SubcriptionDate", dt.Rows[0]["SubcriptionDate"].ToString());
dbconn.sqlComm.Parameters.AddWithValue("@Action", action);
dbconn.sqlComm.ExecuteNonQuery();
dbconn.sqlConn.Close();
}
catch (Exception ex)
{
throw ex;
}
}
public void DeleteAccount(string accountid)
{
try
{
DataSet dtResult = new DataSet();
dbconn = new MAVC_IntegrationV2.DatabaseConnection("local");
dbconn.DatabaseConn("Integrate_ClubDelete");
if (dbconn.sqlConn.State == ConnectionState.Open)
{
dbconn.sqlConn.Close();
}
dbconn.sqlConn.Open();
dbconn.sqlComm.CommandTimeout = 0;
dbconn.sqlComm.Parameters.Clear();
dbconn.sqlComm.Parameters.AddWithValue("@ClubID", accountid);
dbconn.sqlComm.ExecuteNonQuery();
dbconn.sqlConn.Close();
}
catch (Exception ex)
{
throw ex;
}
}
public void UpdateFileNotes(string fileNoteID)
{
try
{
DataSet dtResult = new DataSet();
dbconn = new MAVC_IntegrationV2.DatabaseConnection("web");
dbconn.DatabaseConn("UpdateFileNotes");
if (dbconn.sqlConn.State == ConnectionState.Open)
{
dbconn.sqlConn.Close();
}
dbconn.sqlConn.Open();
dbconn.sqlComm.CommandTimeout = 0;
dbconn.sqlComm.Parameters.Clear();
dbconn.sqlComm.Parameters.AddWithValue("@FileNoteID", fileNoteID);
dbconn.sqlComm.ExecuteNonQuery();
dbconn.sqlConn.Close();
}
catch (Exception ex)
{
throw ex;
}
}
