public Int16 Insert(ParkingRateDetails Details)
{
try
{
Details.CreatedByName = Details.ParkingRateID == 0 ? Details.CreatedByName : Details.LastUpdatedByName;
Save(Details);
string SQL = "SELECT LAST_INSERT_ID();";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
System.Data.DataTable dt = new System.Data.DataTable("LAST_INSERT_ID");
base.MySqlDataAdapterFill(cmd, dt);
Int16 iID = 0;
foreach (System.Data.DataRow dr in dt.Rows)
{
iID = Int16.Parse(dr[0].ToString());
}
return iID;
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public Int32 Save(ParkingRateDetails Details)
{
try
{
string SQL = "CALL procSaveParkingRates(@ParkingRateID, @ProductID, @DayOfWeek, @StartTime, @Endtime, @NoOfUnitPerMin, @PerUnitPrice, @MinimumStayInMin, " +
"@MinimumStayPrice, @CreatedByName, @LastUpdatedByName, @CreatedOn, @LastModified);";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
cmd.Parameters.AddWithValue("ParkingRateID", Details.ParkingRateID);
cmd.Parameters.AddWithValue("ProductID", Details.ProductID);
cmd.Parameters.AddWithValue("DayOfWeek", Details.DayOfWeek);
cmd.Parameters.AddWithValue("StartTime", Details.StartTime);
cmd.Parameters.AddWithValue("EndTime", Details.EndTime);
cmd.Parameters.AddWithValue("NoOfUnitperMin", Details.NoOfUnitperMin);
cmd.Parameters.AddWithValue("PerUnitPrice", Details.PerUnitPrice);
cmd.Parameters.AddWithValue("MinimumStayInMin", Details.MinimumStayInMin);
cmd.Parameters.AddWithValue("MinimumStayPrice", Details.MinimumStayPrice);
cmd.Parameters.AddWithValue("CreatedByName", Details.CreatedByName);
cmd.Parameters.AddWithValue("LastUpdatedByName", Details.LastUpdatedByName);
cmd.Parameters.AddWithValue("CreatedOn", Details.CreatedOn == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : Details.CreatedOn);
cmd.Parameters.AddWithValue("LastModified", Details.LastModified == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : Details.LastModified);
return base.ExecuteNonQuery(cmd);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public Int32 Save(ParkingRateDetails Details)
{
try
{
string SQL = "CALL procSaveParkingRates(@ParkingRateID, @ProductID, @DayOfWeek, @StartTime, @Endtime, @NoOfUnitPerMin, @PerUnitPrice, @MinimumStayInMin, " +
"@MinimumStayPrice, @CreatedByName, @LastUpdatedByName, @CreatedOn, @LastModified);";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
cmd.Parameters.AddWithValue("ParkingRateID", Details.ParkingRateID);
cmd.Parameters.AddWithValue("ProductID", Details.ProductID);
cmd.Parameters.AddWithValue("DayOfWeek", Details.DayOfWeek);
cmd.Parameters.AddWithValue("StartTime", Details.StartTime);
cmd.Parameters.AddWithValue("EndTime", Details.EndTime);
cmd.Parameters.AddWithValue("NoOfUnitperMin", Details.NoOfUnitperMin);
cmd.Parameters.AddWithValue("PerUnitPrice", Details.PerUnitPrice);
cmd.Parameters.AddWithValue("MinimumStayInMin", Details.MinimumStayInMin);
cmd.Parameters.AddWithValue("MinimumStayPrice", Details.MinimumStayPrice);
cmd.Parameters.AddWithValue("CreatedByName", Details.CreatedByName);
cmd.Parameters.AddWithValue("LastUpdatedByName", Details.LastUpdatedByName);
cmd.Parameters.AddWithValue("CreatedOn", Details.CreatedOn == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : Details.CreatedOn);
cmd.Parameters.AddWithValue("LastModified", Details.LastModified == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : Details.LastModified);
return(base.ExecuteNonQuery(cmd));
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public Int16 Insert(ParkingRateDetails Details)
{
try
{
Details.CreatedByName = Details.ParkingRateID == 0 ? Details.CreatedByName : Details.LastUpdatedByName;
Save(Details);
string SQL = "SELECT LAST_INSERT_ID();";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
System.Data.DataTable dt = new System.Data.DataTable("LAST_INSERT_ID");
base.MySqlDataAdapterFill(cmd, dt);
Int16 iID = 0;
foreach (System.Data.DataRow dr in dt.Rows)
{
iID = Int16.Parse(dr[0].ToString());
}
return(iID);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public ParkingRateDetails Details(Int64 ProductID, string DayOfWeek)
{
try
{
ParkingRateDetails Details = setDetails(ListAsDataTable(0, ProductID, DayOfWeek));
return(Details);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public ParkingRateDetails Details(Int64 ParkingRateID)
{
try
{
ParkingRateDetails Details = setDetails(ListAsDataTable(ParkingRateID, 0, null));
return(Details);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
private ParkingRateDetails setDetails(System.Data.DataTable dt)
{
ParkingRateDetails Details = new ParkingRateDetails();
foreach (System.Data.DataRow dr in dt.Rows)
{
Details.ParkingRateID = Int64.Parse(dr["ParkingRateID"].ToString());
Details.ProductID = Int64.Parse(dr["ProductID"].ToString());
Details.DayOfWeek = "" + dr["DayOfWeek"].ToString();
Details.StartTime = "" + dr["StartTime"].ToString();
Details.EndTime = "" + dr["EndTime"].ToString();
Details.NoOfUnitperMin = Int32.Parse(dr["NoOfUnitperMin"].ToString());
Details.PerUnitPrice = decimal.Parse(dr["PerUnitPrice"].ToString());
Details.MinimumStayInMin = Int32.Parse(dr["MinimumStayInMin"].ToString());
Details.MinimumStayPrice = decimal.Parse(dr["MinimumStayPrice"].ToString());
Details.CreatedByName = "" + dr["CreatedByName"].ToString();
Details.LastUpdatedByName = "" + dr["LastUpdatedByName"].ToString();
Details.CreatedOn = DateTime.Parse(dr["CreatedOn"].ToString());
Details.LastModified = DateTime.Parse(dr["LastModified"].ToString());
}
return(Details);
}
private ParkingRateDetails setDetails(System.Data.DataTable dt)
{
ParkingRateDetails Details = new ParkingRateDetails();
foreach (System.Data.DataRow dr in dt.Rows)
{
Details.ParkingRateID = Int64.Parse(dr["ParkingRateID"].ToString());
Details.ProductID = Int64.Parse(dr["ProductID"].ToString());
Details.DayOfWeek = "" + dr["DayOfWeek"].ToString();
Details.StartTime = "" + dr["StartTime"].ToString();
Details.EndTime = "" + dr["EndTime"].ToString();
Details.NoOfUnitperMin = Int32.Parse(dr["NoOfUnitperMin"].ToString());
Details.PerUnitPrice = decimal.Parse(dr["PerUnitPrice"].ToString());
Details.MinimumStayInMin = Int32.Parse(dr["MinimumStayInMin"].ToString());
Details.MinimumStayPrice = decimal.Parse(dr["MinimumStayPrice"].ToString());
Details.CreatedByName = "" + dr["CreatedByName"].ToString();
Details.LastUpdatedByName = "" + dr["LastUpdatedByName"].ToString();
Details.CreatedOn = DateTime.Parse(dr["CreatedOn"].ToString());
Details.LastModified = DateTime.Parse(dr["LastModified"].ToString());
}
return Details;
}
