private void ProcessDetails(string Index, string Action, DataRow rows = null)
{
try
{
//DataSet dtResult = new DataSet();
dbconn = new DatabaseConnection();
dbconn.DatabaseConn(import_Process, "");
if (dbconn.sqlConn.State == ConnectionState.Open)
{
dbconn.sqlConn.Close();
}
dbconn.sqlConn.Open();
dbconn.sqlComm.CommandTimeout = 0;
dbconn.sqlComm.Parameters.Clear();
dbconn.sqlComm.Parameters.AddWithValue("@Index", Index);
dbconn.sqlComm.Parameters.AddWithValue("@Action", Action);
if (Action != "Delete")
{
dbconn.sqlComm.Parameters.AddWithValue("@BandID ,", rows["BandID ,"]);
dbconn.sqlComm.Parameters.AddWithValue("@ClubID ,", rows["ClubID ,"]);
dbconn.sqlComm.Parameters.AddWithValue("@MemberID ,", rows["MemberID ,"]);
dbconn.sqlComm.Parameters.AddWithValue("@BandNumber ,", rows["BandNumber ,"]);
dbconn.sqlComm.Parameters.AddWithValue("@ExternalID", rows["ExternalID"]);
}
dbconn.sqlComm.ExecuteNonQuery();
dbconn.sqlConn.Close();
}
catch (Exception ex)
{
throw ex;
}
}
private DataSet GetDetails(string Index)
{
try
{
DataSet dtResult = new DataSet();
dbconn = new DatabaseConnection();
dbconn.DatabaseConn(import_Get, "_web");
if (dbconn.sqlConn.State == ConnectionState.Open)
{
dbconn.sqlConn.Close();
}
dbconn.sqlConn.Open();
dbconn.sqlComm.CommandTimeout = 0;
dbconn.sqlComm.Parameters.Clear();
SqlDataAdapter da = new SqlDataAdapter();
dbconn.sqlComm.Parameters.AddWithValue("@Index", Index);
da.SelectCommand = dbconn.sqlComm;
da.Fill(dtResult);
dbconn.sqlConn.Close();
return(dtResult);
}
catch (Exception ex)
{
throw ex;
}
}
private void ProcessDetails(string Index, string Action, DataRow rows = null)
{
try
{
//DataSet dtResult = new DataSet();
dbconn = new DatabaseConnection();
dbconn.DatabaseConn(import_Process, "");
if (dbconn.sqlConn.State == ConnectionState.Open)
{
dbconn.sqlConn.Close();
}
dbconn.sqlConn.Open();
dbconn.sqlComm.CommandTimeout = 0;
dbconn.sqlComm.Parameters.Clear();
dbconn.sqlComm.Parameters.AddWithValue("@Index", Index);
dbconn.sqlComm.Parameters.AddWithValue("@Action", Action);
if (Action != "Delete")
{
dbconn.sqlComm.Parameters.AddWithValue("@ClubID", rows["ClubID"]);
dbconn.sqlComm.Parameters.AddWithValue("@RaceCategoryGroupID", rows["RaceCategoryGroupID"]);
dbconn.sqlComm.Parameters.AddWithValue("@RaceCategoryGroupName", rows["RaceCategoryGroupName"]);
dbconn.sqlComm.Parameters.AddWithValue("@CreatedBy", rows["CreatedBy"]);
dbconn.sqlComm.Parameters.AddWithValue("@DateCreadted", rows["DateCreadted"]);
dbconn.sqlComm.Parameters.AddWithValue("@IsActive", rows["IsActive"]);
dbconn.sqlComm.Parameters.AddWithValue("@ExternalID", rows["ExternalID"]);
}
dbconn.sqlComm.ExecuteNonQuery();
dbconn.sqlConn.Close();
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet GetFileNotesForImport()
{
try
{
DataSet dtResult = new DataSet();
dbconn = new DatabaseConnection();
dbconn.DatabaseConn("GetFileNotesForImport", "_web");
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;
}
}
private void ProcessDetails(string Index, string Action, DataRow rows = null)
{
try
{
//DataSet dtResult = new DataSet();
dbconn = new DatabaseConnection();
dbconn.DatabaseConn(import_Process, "");
if (dbconn.sqlConn.State == ConnectionState.Open)
{
dbconn.sqlConn.Close();
}
dbconn.sqlConn.Open();
dbconn.sqlComm.CommandTimeout = 0;
dbconn.sqlComm.Parameters.Clear();
dbconn.sqlComm.Parameters.AddWithValue("@Index", Index);
dbconn.sqlComm.Parameters.AddWithValue("@Action", Action);
if (Action != "Delete")
{
dbconn.sqlComm.Parameters.AddWithValue("@ClubID", rows["ClubID"]);
dbconn.sqlComm.Parameters.AddWithValue("@MemberID", rows["MemberID"]);
dbconn.sqlComm.Parameters.AddWithValue("@MemberIDNo", rows["MemberIDNo"]);
dbconn.sqlComm.Parameters.AddWithValue("@LastName", rows["LastName"]);
dbconn.sqlComm.Parameters.AddWithValue("@FirstName", rows["FirstName"]);
dbconn.sqlComm.Parameters.AddWithValue("@MiddleName", rows["MiddleName"]);
dbconn.sqlComm.Parameters.AddWithValue("@ExtensionName", rows["ExtensionName"]);
dbconn.sqlComm.Parameters.AddWithValue("@LoftName", rows["LoftName"]);
dbconn.sqlComm.Parameters.AddWithValue("@Address", rows["Address"]);
dbconn.sqlComm.Parameters.AddWithValue("@DateofBirth", rows["DateofBirth"]);
dbconn.sqlComm.Parameters.AddWithValue("@DistanceLatDegree", rows["DistanceLatDegree"]);
dbconn.sqlComm.Parameters.AddWithValue("@DistanceLatMinutes", rows["DistanceLatMinutes"]);
dbconn.sqlComm.Parameters.AddWithValue("@DistanceLatSeconds", rows["DistanceLatSeconds"]);
dbconn.sqlComm.Parameters.AddWithValue("@DistanceLatSign", rows["DistanceLatSign"]);
dbconn.sqlComm.Parameters.AddWithValue("@DistanceLongDegree", rows["DistanceLongDegree"]);
dbconn.sqlComm.Parameters.AddWithValue("@DistanceLongMinutes", rows["DistanceLongMinutes"]);
dbconn.sqlComm.Parameters.AddWithValue("@DistanceLongSeconds", rows["DistanceLongSeconds"]);
dbconn.sqlComm.Parameters.AddWithValue("@DistanceLongSign", rows["DistanceLongSign"]);
dbconn.sqlComm.Parameters.AddWithValue("@DateofMembership", rows["DateofMembership"]);
dbconn.sqlComm.Parameters.AddWithValue("@LastRenewalDate", rows["LastRenewalDate"]);
dbconn.sqlComm.Parameters.AddWithValue("@DateofExpiration", rows["DateofExpiration"]);
dbconn.sqlComm.Parameters.AddWithValue("@IsActive", rows["IsActive"]);
dbconn.sqlComm.Parameters.AddWithValue("@CreatedBy", rows["CreatedBy"]);
dbconn.sqlComm.Parameters.AddWithValue("@DateCreated", rows["DateCreated"]);
dbconn.sqlComm.Parameters.AddWithValue("@LastDateUpdated", rows["LastDateUpdated"]);
dbconn.sqlComm.Parameters.AddWithValue("@Updatedby", rows["Updatedby"]);
dbconn.sqlComm.Parameters.AddWithValue("@ExternalID", rows["ExternalID"]);
dbconn.sqlComm.Parameters.AddWithValue("@LatDegreeSimplified", rows["LatDegreeSimplified"]);
dbconn.sqlComm.Parameters.AddWithValue("@LongDegreeSimplified", rows["LongDegreeSimplified"]);
}
dbconn.sqlComm.ExecuteNonQuery();
dbconn.sqlConn.Close();
}
catch (Exception ex)
{
throw ex;
}
}
private void ProcessDetails(string Index, string Action, DataRow rows = null)
{
try
{
//DataSet dtResult = new DataSet();
dbconn = new DatabaseConnection();
dbconn.DatabaseConn(import_Process, "");
if (dbconn.sqlConn.State == ConnectionState.Open)
{
dbconn.sqlConn.Close();
}
dbconn.sqlConn.Open();
dbconn.sqlComm.CommandTimeout = 0;
dbconn.sqlComm.Parameters.Clear();
dbconn.sqlComm.Parameters.AddWithValue("@Index", Index);
dbconn.sqlComm.Parameters.AddWithValue("@Action", Action);
if (Action != "Delete")
{
dbconn.sqlComm.Parameters.AddWithValue("@ClubID ,", rows["ClubID ,"]);
dbconn.sqlComm.Parameters.AddWithValue("@ClubAbbreviation ,", rows["ClubAbbreviation ,"]);
dbconn.sqlComm.Parameters.AddWithValue("@ClubName ,", rows["ClubName ,"]);
dbconn.sqlComm.Parameters.AddWithValue("@DateFounded ,", rows["DateFounded ,"]);
dbconn.sqlComm.Parameters.AddWithValue("@DistanceLatDegree ,", rows["DistanceLatDegree ,"]);
dbconn.sqlComm.Parameters.AddWithValue("@DistanceLatMinutes ,", rows["DistanceLatMinutes ,"]);
dbconn.sqlComm.Parameters.AddWithValue("@DistanceLatSecond ,", rows["DistanceLatSecond ,"]);
dbconn.sqlComm.Parameters.AddWithValue("@DistanceLatSign ,", rows["DistanceLatSign ,"]);
dbconn.sqlComm.Parameters.AddWithValue("@DistanceLongDegree ,", rows["DistanceLongDegree ,"]);
dbconn.sqlComm.Parameters.AddWithValue("@DistanceLongMinutes ,", rows["DistanceLongMinutes ,"]);
dbconn.sqlComm.Parameters.AddWithValue("@DistanceLongSecond ,", rows["DistanceLongSecond ,"]);
dbconn.sqlComm.Parameters.AddWithValue("@DistanceLongSign ,", rows["DistanceLongSign ,"]);
dbconn.sqlComm.Parameters.AddWithValue("@IsActive ,", rows["IsActive ,"]);
dbconn.sqlComm.Parameters.AddWithValue("@Createby ,", rows["Createby ,"]);
dbconn.sqlComm.Parameters.AddWithValue("@DateCreated ,", rows["DateCreated ,"]);
dbconn.sqlComm.Parameters.AddWithValue("@Updatedby ,", rows["Updatedby ,"]);
dbconn.sqlComm.Parameters.AddWithValue("@DateUpdated ,", rows["DateUpdated ,"]);
dbconn.sqlComm.Parameters.AddWithValue("@Version ,", rows["Version ,"]);
dbconn.sqlComm.Parameters.AddWithValue("@DateTimeSource ,", rows["DateTimeSource ,"]);
dbconn.sqlComm.Parameters.AddWithValue("@IsBackup ,", rows["IsBackup ,"]);
dbconn.sqlComm.Parameters.AddWithValue("@IsMAVCStickerUsed ,", rows["IsMAVCStickerUsed ,"]);
dbconn.sqlComm.Parameters.AddWithValue("@ExternalID ,", rows["ExternalID ,"]);
dbconn.sqlComm.Parameters.AddWithValue("@LastSubcription ,", rows["LastSubcription ,"]);
dbconn.sqlComm.Parameters.AddWithValue("@SubcriptionDate ,", rows["SubcriptionDate ,"]);
dbconn.sqlComm.Parameters.AddWithValue("@IsTrial ,", rows["IsTrial ,"]);
dbconn.sqlComm.Parameters.AddWithValue("@TimeZoneDiff ,", rows["TimeZoneDiff ,"]);
dbconn.sqlComm.Parameters.AddWithValue("@SERVER ,", rows["SERVER ,"]);
dbconn.sqlComm.Parameters.AddWithValue("@AllowDoubleEntry", rows["AllowDoubleEntry"]);
}
dbconn.sqlComm.ExecuteNonQuery();
dbconn.sqlConn.Close();
}
catch (Exception ex)
{
throw ex;
}
}
private void ProcessDetails(string Index, string Action, DataRow rows = null)
{
try
{
//DataSet dtResult = new DataSet();
dbconn = new DatabaseConnection();
dbconn.DatabaseConn(import_Process, "");
if (dbconn.sqlConn.State == ConnectionState.Open)
{
dbconn.sqlConn.Close();
}
dbconn.sqlConn.Open();
dbconn.sqlComm.CommandTimeout = 0;
dbconn.sqlComm.Parameters.Clear();
dbconn.sqlComm.Parameters.AddWithValue("@Index", Index);
dbconn.sqlComm.Parameters.AddWithValue("@Action", Action);
if (Action != "Delete")
{
dbconn.sqlComm.Parameters.AddWithValue("@EntryID", rows["EntryID"]);
dbconn.sqlComm.Parameters.AddWithValue("@ClubID", rows["ClubID"]);
dbconn.sqlComm.Parameters.AddWithValue("@RaceReleasePointID", rows["RaceReleasePointID"]);
dbconn.sqlComm.Parameters.AddWithValue("@RaceCategoryID", rows["RaceCategoryID"]);
dbconn.sqlComm.Parameters.AddWithValue("@RaceCategoryGroupID", rows["RaceCategoryGroupID"]);
dbconn.sqlComm.Parameters.AddWithValue("@MemberID", rows["MemberID"]);
dbconn.sqlComm.Parameters.AddWithValue("@StickerCode", rows["StickerCode"]);
dbconn.sqlComm.Parameters.AddWithValue("@BandID", rows["BandID"]);
dbconn.sqlComm.Parameters.AddWithValue("@CreatedBy", rows["CreatedBy"]);
dbconn.sqlComm.Parameters.AddWithValue("@DateCreated", rows["DateCreated"]);
dbconn.sqlComm.Parameters.AddWithValue("@UpdatedBy", rows["UpdatedBy"]);
dbconn.sqlComm.Parameters.AddWithValue("@DateUpdatedBy", rows["DateUpdatedBy"]);
dbconn.sqlComm.Parameters.AddWithValue("@IsActive", rows["IsActive"]);
dbconn.sqlComm.Parameters.AddWithValue("@Remarks", rows["Remarks"]);
dbconn.sqlComm.Parameters.AddWithValue("@EntryBarcodeID", rows["EntryBarcodeID"]);
dbconn.sqlComm.Parameters.AddWithValue("@ExternalID", rows["ExternalID"]);
dbconn.sqlComm.Parameters.AddWithValue("@LatDegreeSimplified", rows["LatDegreeSimplified"]);
dbconn.sqlComm.Parameters.AddWithValue("@LongDegreeSimplified", rows["LongDegreeSimplified"]);
dbconn.sqlComm.Parameters.AddWithValue("@MemberName", rows["MemberName"]);
dbconn.sqlComm.Parameters.AddWithValue("@BandNumber", rows["BandNumber"]);
}
dbconn.sqlComm.ExecuteNonQuery();
dbconn.sqlConn.Close();
}
catch (Exception ex)
{
throw ex;
}
}
private void ProcessDetails(string Index, string Action, DataRow rows = null)
{
try
{
//DataSet dtResult = new DataSet();
dbconn = new DatabaseConnection();
dbconn.DatabaseConn(import_Process, "");
if (dbconn.sqlConn.State == ConnectionState.Open)
{
dbconn.sqlConn.Close();
}
dbconn.sqlConn.Open();
dbconn.sqlComm.CommandTimeout = 0;
dbconn.sqlComm.Parameters.Clear();
dbconn.sqlComm.Parameters.AddWithValue("@Index", Index);
dbconn.sqlComm.Parameters.AddWithValue("@Action", Action);
if (Action != "Delete")
{
dbconn.sqlComm.Parameters.AddWithValue("@ClubID ,", rows["ClubID ,"]);
dbconn.sqlComm.Parameters.AddWithValue("@LocationID ,", rows["LocationID ,"]);
dbconn.sqlComm.Parameters.AddWithValue("@RegionID ,", rows["RegionID ,"]);
dbconn.sqlComm.Parameters.AddWithValue("@LocationName ,", rows["LocationName ,"]);
dbconn.sqlComm.Parameters.AddWithValue("@DistanceLatDegree ,", rows["DistanceLatDegree ,"]);
dbconn.sqlComm.Parameters.AddWithValue("@DistanceLatMinutes ,", rows["DistanceLatMinutes ,"]);
dbconn.sqlComm.Parameters.AddWithValue("@DistanceLatSecond ,", rows["DistanceLatSecond ,"]);
dbconn.sqlComm.Parameters.AddWithValue("@DistanceLatSign ,", rows["DistanceLatSign ,"]);
dbconn.sqlComm.Parameters.AddWithValue("@DistanceLongDegree ,", rows["DistanceLongDegree ,"]);
dbconn.sqlComm.Parameters.AddWithValue("@DistanceLongMinutes ,", rows["DistanceLongMinutes ,"]);
dbconn.sqlComm.Parameters.AddWithValue("@DistanceLongSecond ,", rows["DistanceLongSecond ,"]);
dbconn.sqlComm.Parameters.AddWithValue("@DistanceLongSign ,", rows["DistanceLongSign ,"]);
dbconn.sqlComm.Parameters.AddWithValue("@IsActive ,", rows["IsActive ,"]);
dbconn.sqlComm.Parameters.AddWithValue("@Createdby ,", rows["Createdby ,"]);
dbconn.sqlComm.Parameters.AddWithValue("@DateCreated ,", rows["DateCreated ,"]);
dbconn.sqlComm.Parameters.AddWithValue("@UpdatedBy ,", rows["UpdatedBy ,"]);
dbconn.sqlComm.Parameters.AddWithValue("@DateUpdated ,", rows["DateUpdated ,"]);
dbconn.sqlComm.Parameters.AddWithValue("@ExternalID", rows["ExternalID"]);
}
dbconn.sqlComm.ExecuteNonQuery();
dbconn.sqlConn.Close();
}
catch (Exception ex)
{
throw ex;
}
}
private void ProcessDetails(string Index, string Action, DataRow rows = null)
{
try
{
//DataSet dtResult = new DataSet();
dbconn = new DatabaseConnection();
dbconn.DatabaseConn(import_Process, "");
if (dbconn.sqlConn.State == ConnectionState.Open)
{
dbconn.sqlConn.Close();
}
dbconn.sqlConn.Open();
dbconn.sqlComm.CommandTimeout = 0;
dbconn.sqlComm.Parameters.Clear();
dbconn.sqlComm.Parameters.AddWithValue("@Index", Index);
dbconn.sqlComm.Parameters.AddWithValue("@Action", Action);
if (Action != "Delete")
{
dbconn.sqlComm.Parameters.AddWithValue("@RaceScheduleDetailsID", rows["RaceScheduleDetailsID"]);
dbconn.sqlComm.Parameters.AddWithValue("@ClubID", rows["ClubID"]);
dbconn.sqlComm.Parameters.AddWithValue("@RaceScheduleID", rows["RaceScheduleID"]);
dbconn.sqlComm.Parameters.AddWithValue("@LocationID", rows["LocationID"]);
dbconn.sqlComm.Parameters.AddWithValue("@Loading", rows["Loading"]);
dbconn.sqlComm.Parameters.AddWithValue("@LoadingTimeFrom", rows["LoadingTimeFrom"]);
dbconn.sqlComm.Parameters.AddWithValue("@LoadingTimeTo", rows["LoadingTimeTo"]);
dbconn.sqlComm.Parameters.AddWithValue("@DateRelease", rows["DateRelease"]);
dbconn.sqlComm.Parameters.AddWithValue("@Createby", rows["Createby"]);
dbconn.sqlComm.Parameters.AddWithValue("@Datecreated", rows["Datecreated"]);
dbconn.sqlComm.Parameters.AddWithValue("@UpdatedBy", rows["UpdatedBy"]);
dbconn.sqlComm.Parameters.AddWithValue("@DateUpdated", rows["DateUpdated"]);
dbconn.sqlComm.Parameters.AddWithValue("@ExternalID", rows["ExternalID"]);
dbconn.sqlComm.Parameters.AddWithValue("@LocationName", rows["LocationName"]);
dbconn.sqlComm.Parameters.AddWithValue("@ScheduleName", rows["ScheduleName"]);
}
dbconn.sqlComm.ExecuteNonQuery();
dbconn.sqlConn.Close();
}
catch (Exception ex)
{
throw ex;
}
}
private void UpdateFilenotes(string fileNotesID)
{
try
{
dbconn = new DatabaseConnection();
dbconn.DatabaseConn("UpdateFileNotes", "_web");
if (dbconn.sqlConn.State == ConnectionState.Open)
{
dbconn.sqlConn.Close();
}
dbconn.sqlConn.Open();
dbconn.sqlComm.CommandTimeout = 0;
dbconn.sqlComm.Parameters.Clear();
dbconn.sqlComm.Parameters.AddWithValue("@FileNotesID", fileNotesID);
dbconn.sqlComm.ExecuteNonQuery();
dbconn.sqlConn.Close();
}
catch (Exception ex)
{
throw ex;
}
}
private void ProcessDetails(string Index, string Action, DataRow rows = null)
{
try
{
//DataSet dtResult = new DataSet();
dbconn = new DatabaseConnection();
dbconn.DatabaseConn(import_Process, "");
if (dbconn.sqlConn.State == ConnectionState.Open)
{
dbconn.sqlConn.Close();
}
dbconn.sqlConn.Open();
dbconn.sqlComm.CommandTimeout = 0;
dbconn.sqlComm.Parameters.Clear();
dbconn.sqlComm.Parameters.AddWithValue("@Index", Index);
dbconn.sqlComm.Parameters.AddWithValue("@Action", Action);
if (Action != "Delete")
{
dbconn.sqlComm.Parameters.AddWithValue("@ClubID ,", rows["ClubID ,"]);
dbconn.sqlComm.Parameters.AddWithValue("@RaceScheduleCategoryID ,", rows["RaceScheduleCategoryID ,"]);
dbconn.sqlComm.Parameters.AddWithValue("@RaceScheduleDetailsID ,", rows["RaceScheduleDetailsID ,"]);
dbconn.sqlComm.Parameters.AddWithValue("@RaceReleasePointID ,", rows["RaceReleasePointID ,"]);
dbconn.sqlComm.Parameters.AddWithValue("@ReleaseTime ,", rows["ReleaseTime ,"]);
dbconn.sqlComm.Parameters.AddWithValue("@Multiplier ,", rows["Multiplier ,"]);
dbconn.sqlComm.Parameters.AddWithValue("@LapNo ,", rows["LapNo ,"]);
dbconn.sqlComm.Parameters.AddWithValue("@MinSpeed ,", rows["MinSpeed ,"]);
dbconn.sqlComm.Parameters.AddWithValue("@IsStop ,", rows["IsStop ,"]);
dbconn.sqlComm.Parameters.AddWithValue("@StopFromDate ,", rows["StopFromDate ,"]);
dbconn.sqlComm.Parameters.AddWithValue("@StopFromTime ,", rows["StopFromTime ,"]);
dbconn.sqlComm.Parameters.AddWithValue("@StopToDate ,", rows["StopToDate ,"]);
dbconn.sqlComm.Parameters.AddWithValue("@StopToTime ,", rows["StopToTime ,"]);
dbconn.sqlComm.Parameters.AddWithValue("@StopTime ,", rows["StopTime ,"]);
dbconn.sqlComm.Parameters.AddWithValue("@Description ,", rows["Description ,"]);
dbconn.sqlComm.Parameters.AddWithValue("@IsActive ,", rows["IsActive ,"]);
dbconn.sqlComm.Parameters.AddWithValue("@Createdby ,", rows["Createdby ,"]);
dbconn.sqlComm.Parameters.AddWithValue("@DateCreated ,", rows["DateCreated ,"]);
dbconn.sqlComm.Parameters.AddWithValue("@UpdatedBy ,", rows["UpdatedBy ,"]);
dbconn.sqlComm.Parameters.AddWithValue("@DateUpdated ,", rows["DateUpdated ,"]);
dbconn.sqlComm.Parameters.AddWithValue("@ExternalID ,", rows["ExternalID ,"]);
dbconn.sqlComm.Parameters.AddWithValue("@DateRelease ,", rows["DateRelease ,"]);
dbconn.sqlComm.Parameters.AddWithValue("@LocationName ,", rows["LocationName ,"]);
dbconn.sqlComm.Parameters.AddWithValue("@LocationID ,", rows["LocationID ,"]);
dbconn.sqlComm.Parameters.AddWithValue("@RacescheduleID ,", rows["RacescheduleID ,"]);
dbconn.sqlComm.Parameters.AddWithValue("@RacescheduleName ,", rows["RacescheduleName ,"]);
dbconn.sqlComm.Parameters.AddWithValue("@LatDegree ,", rows["LatDegree ,"]);
dbconn.sqlComm.Parameters.AddWithValue("@LatMinutes ,", rows["LatMinutes ,"]);
dbconn.sqlComm.Parameters.AddWithValue("@LatSecond ,", rows["LatSecond ,"]);
dbconn.sqlComm.Parameters.AddWithValue("@LatSign ,", rows["LatSign ,"]);
dbconn.sqlComm.Parameters.AddWithValue("@LatDegreeSimplified ,", rows["LatDegreeSimplified ,"]);
dbconn.sqlComm.Parameters.AddWithValue("@LongDegree ,", rows["LongDegree ,"]);
dbconn.sqlComm.Parameters.AddWithValue("@LongMinutes ,", rows["LongMinutes ,"]);
dbconn.sqlComm.Parameters.AddWithValue("@LongSecond ,", rows["LongSecond ,"]);
dbconn.sqlComm.Parameters.AddWithValue("@LongSign ,", rows["LongSign ,"]);
dbconn.sqlComm.Parameters.AddWithValue("@LongDegreeSimplified", rows["LongDegreeSimplified"]);
}
dbconn.sqlComm.ExecuteNonQuery();
dbconn.sqlConn.Close();
}
catch (Exception ex)
{
throw ex;
}
}
