public DataTable SaveHourBasePricing(HourBase c)
{
DataTable dt = new DataTable();
LogTraceWriter traceWriter = new LogTraceWriter();
SqlConnection conn = new SqlConnection();
StringBuilder str = new StringBuilder();
try
{
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "SaveHourBasePricing....");
str.Append("CountryId:" + c.CountryId + ",");
str.Append("VehicleGroupId:" + c.VehicleGroupId + ",");
str.Append("Hours:" + c.Hours + ",");
str.Append("price:" + c.price + ",");
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "Input sent...." + str.ToString());
conn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["btposdb"].ToString();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "PSInsUpdDelHourBasePricing";
cmd.Connection = conn;
SqlParameter insupddelflag = new SqlParameter("@insupddelflag", SqlDbType.VarChar, 10);
insupddelflag.Value = c.insupddelflag;
cmd.Parameters.Add(insupddelflag);
SqlParameter q = new SqlParameter("@Id", SqlDbType.Int);
q.Value = c.Id;
cmd.Parameters.Add(q);
SqlParameter q1 = new SqlParameter("@VehicleTypeId", SqlDbType.Int);
q1.Value = c.VehicleTypeId;
cmd.Parameters.Add(q1);
SqlParameter e = new SqlParameter("@FromTime", SqlDbType.DateTime);
e.Value = c.FromTime;
cmd.Parameters.Add(e);
SqlParameter t = new SqlParameter("@ToTime", SqlDbType.DateTime);
t.Value = c.ToTime;
cmd.Parameters.Add(t);
SqlParameter c1 = new SqlParameter("@PricingType", SqlDbType.Int);
c1.Value = c.PricingType;
cmd.Parameters.Add(c1);
SqlParameter ft = new SqlParameter("@FromDate", SqlDbType.DateTime);
ft.Value = c.FromDate;
cmd.Parameters.Add(ft);
SqlParameter tf = new SqlParameter("@ToDate", SqlDbType.DateTime);
tf.Value = c.ToDate;
cmd.Parameters.Add(tf);
SqlParameter cd = new SqlParameter("@Createdby", SqlDbType.Int);
cd.Value = c.CreatedBy;
cmd.Parameters.Add(cd);
SqlParameter up = new SqlParameter("@Hours", SqlDbType.Int);
up.Value = c.Hours;
cmd.Parameters.Add(up);
SqlParameter cc = new SqlParameter("@CountryId", SqlDbType.Int);
cc.Value = c.CountryId;
cmd.Parameters.Add(cc);
SqlParameter vc = new SqlParameter("@VehicleGroupId", SqlDbType.Int);
vc.Value = c.VehicleGroupId;
cmd.Parameters.Add(vc);
SqlParameter uo = new SqlParameter("@price", SqlDbType.Decimal);
uo.Value = c.price;
cmd.Parameters.Add(uo);
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "SaveHourBasePricing successful....");
}
catch (Exception ex)
{
traceWriter.Trace(Request, "0", TraceLevel.Error, "{0}", "SaveHourBasePricing...." + ex.Message.ToString());
//throw new HttpResponseException(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex.Message));
dt.Columns.Add("Code");
dt.Columns.Add("description");
DataRow dr = dt.NewRow();
dr[0] = "ERR001";
dr[1] = ex.Message;
dt.Rows.Add(dr);
}
finally
{
conn.Close();
conn.Dispose();
SqlConnection.ClearPool(conn);
}
return(dt);
}
public DataTable SaveHourBasePricing(HourBase c)
{
SqlConnection conn = new SqlConnection();
conn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["btposdb"].ToString();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "PSInsUpdDelHourBasePricing";
cmd.Connection = conn;
SqlParameter insupddelflag = new SqlParameter("@insupddelflag", SqlDbType.VarChar, 10);
insupddelflag.Value = c.insupddelflag;
cmd.Parameters.Add(insupddelflag);
SqlParameter q = new SqlParameter("@Id", SqlDbType.Int);
q.Value = c.Id;
cmd.Parameters.Add(q);
SqlParameter q1 = new SqlParameter("@VehicleTypeId", SqlDbType.Int);
q1.Value = c.VehicleTypeId;
cmd.Parameters.Add(q1);
SqlParameter e = new SqlParameter("@FromTime", SqlDbType.DateTime);
e.Value = c.FromTime;
cmd.Parameters.Add(e);
SqlParameter t = new SqlParameter("@ToTime", SqlDbType.DateTime);
t.Value = c.ToTime;
cmd.Parameters.Add(t);
SqlParameter c1 = new SqlParameter("@PricingType", SqlDbType.Int);
c1.Value = c.PricingType;
cmd.Parameters.Add(c1);
SqlParameter ft = new SqlParameter("@FromDate", SqlDbType.DateTime);
ft.Value = c.FromDate;
cmd.Parameters.Add(ft);
SqlParameter tf = new SqlParameter("@ToDate", SqlDbType.DateTime);
tf.Value = c.ToDate;
cmd.Parameters.Add(tf);
SqlParameter cd = new SqlParameter("@Createdby", SqlDbType.Int);
cd.Value = c.CreatedBy;
cmd.Parameters.Add(cd);
SqlParameter up = new SqlParameter("@Hours", SqlDbType.Int);
up.Value = c.Hours;
cmd.Parameters.Add(up);
SqlParameter cc = new SqlParameter("@CountryId", SqlDbType.Int);
cc.Value = c.CountryId;
cmd.Parameters.Add(cc);
SqlParameter vc = new SqlParameter("@VehicleGroupId", SqlDbType.Int);
vc.Value = c.VehicleGroupId;
cmd.Parameters.Add(vc);
SqlParameter uo = new SqlParameter("@price", SqlDbType.Decimal);
uo.Value = c.price;
cmd.Parameters.Add(uo);
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
return(dt);
}