public static void updateAllCarParkStatus(String ahuzotUser, String ahuzotPassword, String fWSPwd)
{
ahuzot.parkinfo.CP ahuzotApi = new ahuzot.parkinfo.CP();
String refStr = "";
ahuzot.parkinfo.CarParkDynamicDetails[] data = ahuzotApi.GetAllCarParkStatus(ahuzotUser, ahuzotPassword, ref refStr, fWSPwd);
try
{
log.Info("Updating all Ahuzot Hof parkings status.");
using (SqlConnection con = new SqlConnection(conStr))
{
con.Open();
using (SqlCommand updateCmd = new SqlCommand())
{
updateCmd.CommandTimeout = 600;
foreach (ahuzot.parkinfo.CarParkDynamicDetails parking in data)
{
int parkingStatus = stateToNum(parking.InformationToShow);
int externalId = parking.AhuzotCode;
String updateSql = String.Format(
@"UPDATE [citypark].[dbo].[Parking] SET Current_Pnuyot = {1} ,[Editdate] = CURRENT_TIMESTAMP WHERE externalid = {0}"
, externalId, parkingStatus);
updateCmd.Connection = con;
updateCmd.CommandText = updateSql;
updateCmd.ExecuteNonQuery();
}
}
}
}
catch (Exception ex)
{
log.Error(ex.Message);
return;
}
log.Info("Finished updating ahuzot hof status.");
using (SqlConnection con = new SqlConnection(conStr))
{
using (SqlCommand insertCmd = new SqlCommand())
{
insertCmd.CommandTimeout = 200;
String updateSql = String.Format(
@"INSERT INTO [CITYPARK].[dbo].[ServiceProviderLog]
([ServiceProvider]
,[API]
,[AccessDate])
VALUES
('{0}'
,'{1}'
,CURRENT_TIMESTAMP)", ServiceProvider, "GetAllCarParkStatus");
insertCmd.Connection = con;
insertCmd.CommandText = updateSql;
con.Open();
insertCmd.ExecuteNonQuery();
}
}
}
public static void updateAllCarParkStatus(String ahuzotUser, String ahuzotPassword, String fWSPwd)
{
ahuzot.parkinfo.CP ahuzotApi = new ahuzot.parkinfo.CP();
String refStr = "";
ahuzot.parkinfo.CarParkDynamicDetails[] data = ahuzotApi.GetAllCarParkStatus(ahuzotUser, ahuzotPassword, ref refStr, fWSPwd);
try
{
log.Info("Updating all Ahuzot Hof parkings status.");
using (SqlConnection con = new SqlConnection(conStr))
{
con.Open();
using (SqlCommand updateCmd = new SqlCommand())
{
updateCmd.CommandTimeout = 600;
foreach (ahuzot.parkinfo.CarParkDynamicDetails parking in data)
{
int parkingStatus = stateToNum(parking.InformationToShow);
int externalId = parking.AhuzotCode;
String updateSql = String.Format(
@"UPDATE [citypark].[dbo].[Parking] SET Current_Pnuyot = {1} ,[Editdate] = CURRENT_TIMESTAMP WHERE externalid = {0}"
, externalId, parkingStatus);
updateCmd.Connection = con;
updateCmd.CommandText = updateSql;
updateCmd.ExecuteNonQuery();
}
}
}
}
catch (Exception ex)
{
log.Error(ex.Message);
return;
}
log.Info("Finished updating ahuzot hof status.");
using (SqlConnection con = new SqlConnection(conStr))
{
using (SqlCommand insertCmd = new SqlCommand())
{
insertCmd.CommandTimeout = 200;
String updateSql = String.Format(
@"INSERT INTO [CITYPARK].[dbo].[ServiceProviderLog]
([ServiceProvider]
,[API]
,[AccessDate])
VALUES
('{0}'
,'{1}'
,CURRENT_TIMESTAMP)", ServiceProvider, "GetAllCarParkStatus");
insertCmd.Connection = con;
insertCmd.CommandText = updateSql;
con.Open();
insertCmd.ExecuteNonQuery();
}
}
}
public static void getAllCarParkDetails(String ahuzotUser, String ahuzotPassword, String fWSPwd)
{
ahuzot.parkinfo.CP ahuzotApi = new ahuzot.parkinfo.CP();
String refStr = "";
ahuzot.parkinfo.CarParkStaticDetails[] data = ahuzotApi.GetAllCarParkDetails(ahuzotUser, ahuzotPassword, ref refStr, fWSPwd);
foreach (ahuzot.parkinfo.CarParkStaticDetails parking in data)
{
log.Info("----------------------------------------");
log.Info(parking + "~Address:" + parking.Address + "~AhuzotCode:" + parking.AhuzotCode + "~ControllerID:" + parking.ControllerID +
"~DailyFee:" + parking.DailyFee + "~DailyFeeWindow:" + parking.DailyFeeWindow + "~DaytimeFee:" + parking.DaytimeFee +
"~DaytimeFeeWindow:" + parking.DaytimeFeeWindow + "~Extra01:" + parking.Extra01 + "~Extra02:" + parking.Extra02 +
"~Extra03:" + parking.Extra03 + "~Extra04:" + parking.Extra04 +
"~Extra05:" + parking.Extra05 + "~FeeComments:" + parking.FeeComments +
"~Latitude:" + parking.GPSLattitude + "~Longitude:" + parking.GPSLongitude +
"~MaximumPublicOccupancy:" + "" + parking.MaximumPublicOccupancy + "~MaximumSubscriberOccupancy:" + parking.MaximumSubscriberOccupancy
+ "~MonthFeeForDailySubscriber:" + parking.MonthFeeForDailySubscriber +
"~MonthFeeForDailySubscriberWindow:" + parking.MonthFeeForDailySubscriberWindow + "~MonthFeeForNightlySubscriber:" + parking.MonthFeeForNightlySubscriber +
"~MonthFeeForNightlySubscriberWindow:" + parking.MonthFeeForNightlySubscriberWindow + "~Name:" + parking.Name +
"~NighttimeFee:" + parking.NighttimeFee + "~NighttimeFeeWindow:" + parking.NighttimeFeeWindow + "~OpenWindow:" + parking.OpenWindow);
}
/* using (SqlConnection con = new SqlConnection(conStr))
* {
* using (SqlCommand cmd = new SqlCommand())
* {
*
* String sql = String.Format(
* @"SELECT COUNT(*)
* FROM CITYPARK.[dbo].[StreetParking] where Date > dateadd(hh, {0}, getdate())", 2);
* cmd.Connection = con;
* cmd.CommandType = CommandType.Text;
* cmd.CommandText = sql;
* con.Open();
*
* }
* }*/
}
public static void getAllCarParkDetails(String ahuzotUser, String ahuzotPassword, String fWSPwd)
{
ahuzot.parkinfo.CP ahuzotApi = new ahuzot.parkinfo.CP();
String refStr = "";
ahuzot.parkinfo.CarParkStaticDetails[] data = ahuzotApi.GetAllCarParkDetails(ahuzotUser, ahuzotPassword, ref refStr, fWSPwd);
foreach (ahuzot.parkinfo.CarParkStaticDetails parking in data)
{
log.Info("----------------------------------------");
log.Info(parking +"~Address:"+parking.Address +"~AhuzotCode:"+parking.AhuzotCode +"~ControllerID:"+parking.ControllerID +
"~DailyFee:"+parking.DailyFee +"~DailyFeeWindow:"+parking.DailyFeeWindow +"~DaytimeFee:"+parking.DaytimeFee +
"~DaytimeFeeWindow:" + parking.DaytimeFeeWindow + "~Extra01:" + parking.Extra01 + "~Extra02:" + parking.Extra02 +
"~Extra03:" + parking.Extra03 + "~Extra04:" + parking.Extra04 +
"~Extra05:" + parking.Extra05 + "~FeeComments:" + parking.FeeComments +
"~Latitude:" + parking.GPSLattitude + "~Longitude:" + parking.GPSLongitude +
"~MaximumPublicOccupancy:" + "" + parking.MaximumPublicOccupancy + "~MaximumSubscriberOccupancy:" + parking.MaximumSubscriberOccupancy
+ "~MonthFeeForDailySubscriber:" + parking.MonthFeeForDailySubscriber +
"~MonthFeeForDailySubscriberWindow:" + parking.MonthFeeForDailySubscriberWindow + "~MonthFeeForNightlySubscriber:" + parking.MonthFeeForNightlySubscriber +
"~MonthFeeForNightlySubscriberWindow:" + parking.MonthFeeForNightlySubscriberWindow + "~Name:" + parking.Name +
"~NighttimeFee:" + parking.NighttimeFee + "~NighttimeFeeWindow:" + parking.NighttimeFeeWindow + "~OpenWindow:" + parking.OpenWindow );
}
/* using (SqlConnection con = new SqlConnection(conStr))
{
using (SqlCommand cmd = new SqlCommand())
{
String sql = String.Format(
@"SELECT COUNT(*)
FROM CITYPARK.[dbo].[StreetParking] where Date > dateadd(hh, {0}, getdate())", 2);
cmd.Connection = con;
cmd.CommandType = CommandType.Text;
cmd.CommandText = sql;
con.Open();
}
}*/
}
