public HttpResponseMessage saveroledetails(roledetails b)
{
LogTraceWriter traceWriter = new LogTraceWriter();
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "saveroledetails credentials....");
//connect to database
SqlConnection conn = new SqlConnection();
try
{
//connetionString="Data Source=ServerName;Initial Catalog=DatabaseName;User ID=UserName;Password=Password"
conn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["btposdb"].ToString();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "InsUpdDelRoledetails";
cmd.Connection = conn;
conn.Open();
SqlParameter Aid = new SqlParameter();
Aid.ParameterName = "@Id";
Aid.SqlDbType = SqlDbType.Int;
Aid.Value = Convert.ToString(b.Id);
cmd.Parameters.Add(Aid);
SqlParameter ss = new SqlParameter();
ss.ParameterName = "@ObjectName";
ss.SqlDbType = SqlDbType.VarChar;
ss.Value = b.ObjectName;
cmd.Parameters.Add(ss);
SqlParameter ssd = new SqlParameter();
ssd.ParameterName = "@Path";
ssd.SqlDbType = SqlDbType.VarChar;
ssd.Value = b.Path;
cmd.Parameters.Add(ssd);
//DataSet ds = new DataSet();
//SqlDataAdapter db = new SqlDataAdapter(cmd);
//db.Fill(ds);
// Tbl = Tables[0];
cmd.ExecuteScalar();
conn.Close();
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "saveroledetails Credentials completed.");
return(new HttpResponseMessage(HttpStatusCode.OK));
}
catch (Exception ex)
{
if (conn != null && conn.State == ConnectionState.Open)
{
conn.Close();
}
string str = ex.Message;
traceWriter.Trace(Request, "1", TraceLevel.Info, "{0}", "Error in saveroledetails:" + ex.Message);
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, ex));
}
}
public DataTable GetRoles(int allroles)
{
DataTable Tbl = new DataTable();
LogTraceWriter traceWriter = new LogTraceWriter();
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "GetRoles credentials....");
//connect to database
SqlConnection conn = new SqlConnection();
//connetionString="Data Source=ServerName;Initial Catalog=DatabaseName;User ID=UserName;Password=Password"
conn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["btposdb"].ToString();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "GetRoles";
SqlParameter rolesFlag = new SqlParameter();
rolesFlag.ParameterName = "@allroles";
rolesFlag.SqlDbType = SqlDbType.Int;
rolesFlag.Value = allroles;
cmd.Parameters.Add(rolesFlag);
cmd.Connection = conn;
SqlDataAdapter db = new SqlDataAdapter(cmd);
db.Fill(Tbl);
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "GetRoles Credentials completed.");
return(Tbl);
}
public DataTable GetUserDetails(int UId)//Main Method
{
DataTable Tbl = new DataTable();
LogTraceWriter traceWriter = new LogTraceWriter();
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "GetUsers ....");
//connect to database
SqlConnection conn = new SqlConnection();
conn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["btposdb"].ToString();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;//Stored Procedure
cmd.CommandText = "getUserdetails";
cmd.Connection = conn;
SqlParameter cmpid = new SqlParameter("@UId", SqlDbType.Int);
cmpid.Value = UId;
cmd.Parameters.Add(cmpid);
//SqlParameter empid= new SqlParameter("@EmpNo", SqlDbType.Int);
//cmpid.Value = empid;
//cmd.Parameters.Add(empid);
SqlDataAdapter db = new SqlDataAdapter(cmd);
db.Fill(Tbl);
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "GetUsers completed.");
return(Tbl);
}
public DataTable GetHistoryTasks()
{
DataTable Tbl = new DataTable();
LogTraceWriter traceWriter = new LogTraceWriter();
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "GetEditHistory credentials....");
//connect to database
SqlConnection conn = new SqlConnection();
//connetionString="Data Source=ServerName;Initial Catalog=DatabaseName;User ID=UserName;Password=Password"
conn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["btposdb"].ToString();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "GetEditHistoryTasks";
cmd.Connection = conn;
DataSet ds = new DataSet();
SqlDataAdapter db = new SqlDataAdapter(cmd);
db.Fill(ds);
Tbl = ds.Tables[0];
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "GetEditHistory Credentials completed.");
// int found = 0;
return(Tbl);
}
public DataTable GetCountry(int active)
{
DataTable Tbl = new DataTable();
LogTraceWriter traceWriter = new LogTraceWriter();
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "GetCountry ...");
//connect to database
SqlConnection conn = new SqlConnection();
//connetionString="Data Source=ServerName;Initial Catalog=DatabaseName;User ID=UserName;Password=Password"
conn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["btposdb"].ToString();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "GetCountries";
cmd.Connection = conn;
SqlParameter a = new SqlParameter("@active", SqlDbType.Int);
a.Value = active;
cmd.Parameters.Add(a);
DataSet ds = new DataSet();
SqlDataAdapter db = new SqlDataAdapter(cmd);
db.Fill(ds);
Tbl = ds.Tables[0];
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "GetCountry completed.");
// int found = 0;
return(Tbl);
}
public DataTable GetFleetOwnerRouteAssigned(int fleetownerId)
{
DataTable Tbl = new DataTable();
LogTraceWriter traceWriter = new LogTraceWriter();
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "GetFleetOwnerRouteAssigned credentials....");
//connect to database
SqlConnection conn = new SqlConnection();
//connetionString="Data Source=ServerName;Initial Catalog=DatabaseName;User ID=UserName;Password=Password"
conn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["btposdb"].ToString();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "GetFleetOwnerRouteAssigned";
cmd.Connection = conn;
SqlParameter foid = new SqlParameter();
foid.ParameterName = "@fleetownerId";
foid.SqlDbType = SqlDbType.Int;
foid.Value = fleetownerId;
cmd.Parameters.Add(foid);
DataSet ds = new DataSet();
SqlDataAdapter db = new SqlDataAdapter(cmd);
db.Fill(ds);
Tbl = ds.Tables[0];
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "GetFleetOwnerRouteAssigned Credentials completed.");
// int found = 0;
return(Tbl);
}
public DataTable GetUserRoles(int cmpId)
{
DataTable tbl = new DataTable();
LogTraceWriter traceWriter = new LogTraceWriter();
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "GetUserRoles ....");
SqlConnection conn = new SqlConnection();
conn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["btposdb"].ToString();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;//Stored Procedure
cmd.CommandText = "GetUserRoles";
cmd.Connection = conn;
SqlParameter UUserType = new SqlParameter("@companyId", SqlDbType.Int);
UUserType.Value = cmpId;
cmd.Parameters.Add(UUserType);
DataSet ds = new DataSet();
SqlDataAdapter db = new SqlDataAdapter(cmd);
db.Fill(tbl);
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "GetUserRoles completed.");
return(tbl);
}
public DataTable GetMandUserDocs(int ctryId, int utId, int vgrpId)
{
DataTable Tbl = new DataTable();
LogTraceWriter traceWriter = new LogTraceWriter();
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "GetMandatoryUserDocs ....");
//connect to database
SqlConnection conn = new SqlConnection();
//connetionString="Data Source=ServerName;Initial Catalog=DatabaseName;User ID=UserName;Password=Password"
conn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["btposdb"].ToString();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "GetMandatoryUserDocs";
cmd.Parameters.Add("@countryid", SqlDbType.Int).Value = ctryId;
cmd.Parameters.Add("@utId", SqlDbType.Int).Value = utId;
cmd.Parameters.Add("@vgId", SqlDbType.Int).Value = vgrpId;
cmd.Connection = conn;
//DataSet ds = new DataSet();
SqlDataAdapter db = new SqlDataAdapter(cmd);
db.Fill(Tbl);
//Tbl = ds.Tables[0];
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "GetMandatoryUserDocs completed.");
// int found = 0;
return(Tbl);
}
public DataSet getroutedetails(int routeid)
{
// DataTable Tbl = new DataTable();
LogTraceWriter traceWriter = new LogTraceWriter();
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "getroutedetails credentials....");
//connect to database
SqlConnection conn = new SqlConnection();
//connetionString="Data Source=ServerName;Initial Catalog=DatabaseName;User ID=UserName;Password=Password"
conn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["btposdb"].ToString();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "getRouteDetails";
cmd.Connection = conn;
SqlParameter cid = new SqlParameter();
cid.ParameterName = "@routeid";
cid.SqlDbType = SqlDbType.Int;
cid.Value = routeid;
cmd.Parameters.Add(cid);
DataSet ds = new DataSet();
SqlDataAdapter db = new SqlDataAdapter(cmd);
db.Fill(ds);
// Tbl = ds.Tables[0];
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "getroutedetails Credentials completed.");
// int found = 0;
return(ds);
}
public DataTable ValidateDriverCredentials(DriverLogin b)
{
LogTraceWriter traceWriter = new LogTraceWriter();
SqlConnection conn = new SqlConnection();
DataTable dt = new DataTable();
try
{
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "ValidateDriverCredentials....");
StringBuilder str = new StringBuilder();
str.Append("@DriverNo" + b.Mobilenumber + ",");
str.Append("@Password" + b.Password + ",");
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "ValidateDriverCredentials Input sent...." + str.ToString());
conn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["btposdb"].ToString();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "drivercredentials";
cmd.Connection = conn;
SqlParameter ss = new SqlParameter();
ss.ParameterName = "@DriverNo";
ss.SqlDbType = SqlDbType.VarChar;
ss.Value = b.Mobilenumber;
cmd.Parameters.Add(ss);
SqlParameter dd = new SqlParameter();
dd.ParameterName = "@Password";
dd.SqlDbType = SqlDbType.VarChar;
dd.Value = b.Password;
cmd.Parameters.Add(dd);
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "ValidateDriverCredentials successful....");
}
catch (Exception ex)
{
traceWriter.Trace(Request, "0", TraceLevel.Error, "{0}", "ValidateDriverCredentials...." + 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 HttpResponseMessage SaveFleetOwnerRouteDetails(IEnumerable <RouteDetails> routestops)
{
LogTraceWriter traceWriter = new LogTraceWriter();
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "SaveFleetOwnerRouteDetails credentials....");
SqlConnection conn = new SqlConnection();
try
{
//connect to database
//connetionString="Data Source=ServerName;Initial Catalog=DatabaseName;User ID=UserName;Password=Password"
conn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["btposdb"].ToString();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "InsUpdDelFleetOwnerRouteStops";
cmd.Connection = conn;
conn.Open();
foreach (RouteDetails s in routestops)
{
SqlParameter ba = new SqlParameter("@RouteId", SqlDbType.Int);
ba.Value = s.RouteId;
cmd.Parameters.Add(ba);
SqlParameter bb = new SqlParameter("@StopId", SqlDbType.Int);
bb.Value = s.stopId;
cmd.Parameters.Add(bb);
SqlParameter fo = new SqlParameter("@FleetOwnerId", SqlDbType.Int);
fo.Value = s.FleetOwnerId;
cmd.Parameters.Add(fo);
SqlParameter insupdflag = new SqlParameter("@insupddelflag", SqlDbType.VarChar, 1);
insupdflag.Value = s.insupddelflag;
cmd.Parameters.Add(insupdflag);
cmd.ExecuteScalar();
cmd.Parameters.Clear();
}
conn.Close();
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "SaveFleetOwnerRouteDetails Credentials completed.");
return(new HttpResponseMessage(HttpStatusCode.OK));
}
catch (Exception ex)
{
if (conn != null && conn.State == ConnectionState.Open)
{
conn.Close();
}
string str = ex.Message;
traceWriter.Trace(Request, "1", TraceLevel.Info, "{0}", "Error in SaveFleetOwnerRouteDetails:" + ex.Message);
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, ex));
}
}
public DataTable GetBookingHistory(string PhoneNo)
{
LogTraceWriter traceWriter = new LogTraceWriter();
SqlConnection conn = new SqlConnection();
DataTable dt = new DataTable();
try
{
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "GetBookingHistory....");
conn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["btposdb"].ToString();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "HVGetBookingHistory";
cmd.Parameters.Add("@PhoneNo", SqlDbType.VarChar, 50).Value = PhoneNo;
//cmd.Parameters.Add("@EmailId", SqlDbType.VarChar, 50).Value = EmailId;
cmd.Connection = conn;
DataSet ds = new DataSet();
SqlDataAdapter db = new SqlDataAdapter(cmd);
db.Fill(ds);
dt = ds.Tables[0];
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "GetBookingHistory successful....");
StringBuilder str = new StringBuilder();
str.Append("@PhoneNo" + PhoneNo + ",");
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "GetBookedHistory Input sent...." + str.ToString());
if (dt.Rows.Count > 0)
{
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "GetBookedHistory Output...." + dt.Rows[0].ToString());
}
else
{
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "GetBookedHistory Output....BookedHistory ");
}
}
catch (Exception ex)
{
traceWriter.Trace(Request, "0", TraceLevel.Error, "{0}", "GetBookingHistory...." + 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 SaveUserRoles(userroles U)
{
LogTraceWriter traceWriter = new LogTraceWriter();
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "SaveUserRoles ....");
DataTable Tbl = new DataTable();
SqlConnection conn = new SqlConnection();
try
{
//connetionString="Data Source=ServerName;Initial Catalog=DatabaseName;User ID=UserName;Password=Password"
conn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["btposdb"].ToString();
//conn.ConnectionString = "Data Source=localhost;Initial Catalog=MyAlerts;integrated security=sspi;";
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "InsUpdDelUserRoles";
cmd.Connection = conn;
conn.Open();
SqlParameter UId = new SqlParameter("@Id", SqlDbType.Int);
UId.Value = U.Id;
cmd.Parameters.Add(UId);
SqlParameter URole = new SqlParameter("@UserId", SqlDbType.Int);
URole.Value = U.UserId;
cmd.Parameters.Add(URole);
SqlParameter UUser = new SqlParameter("@roleid", SqlDbType.Int);
UUser.Value = U.RoleId;
cmd.Parameters.Add(UUser);
SqlParameter UCmp = new SqlParameter("@CompanyId", SqlDbType.Int);
UCmp.Value = U.CompanyId;
cmd.Parameters.Add(UCmp);
SqlParameter insupdflag = new SqlParameter("@insupdflag", SqlDbType.VarChar, 10);
insupdflag.Value = U.insupdflag;
cmd.Parameters.Add(insupdflag);
cmd.ExecuteScalar();
conn.Close();
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "SaveUserRoles completed.");
}
catch (Exception ex)
{
conn.Close();
string str = ex.Message;
traceWriter.Trace(Request, "1", TraceLevel.Info, "{0}", "Error in SaveUserRoles:" + ex.Message);
}
// int found = 0;
return(Tbl);
}
public DataTable GetTripPayments(int id)
{
DataTable Tbl = new DataTable();
SqlConnection conn = new SqlConnection();
LogTraceWriter traceWriter = new LogTraceWriter();
try
{
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "GetTripPayments credentials....");
StringBuilder str = new StringBuilder();
str.Append("@id" + id + ",");
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "GetTripPayments Input sent...." + str.ToString());
if (Tbl.Rows.Count > 0)
{
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "GetTripPayments Output...." + Tbl.Rows[0].ToString());
}
else
{
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "GetTripPayments Output....BookedHistory ");
}
conn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["btposdb"].ToString();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "PSGetTripPayments";
cmd.Parameters.Add("@id", SqlDbType.Int).Value = id;
cmd.Connection = conn;
DataSet ds = new DataSet();
SqlDataAdapter db = new SqlDataAdapter(cmd);
db.Fill(ds);
Tbl = ds.Tables[0];
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "GetTripPayments Credentials completed.");
}
catch (Exception ex)
{
traceWriter.Trace(Request, "0", TraceLevel.Error, "{0}", "GetTripPayments...." + ex.Message.ToString());
Tbl.Columns.Add("Code");
Tbl.Columns.Add("description");
DataRow dr = Tbl.NewRow();
dr[0] = "ERR001";
dr[1] = ex.Message;
Tbl.Rows.Add(dr);
}
finally
{
conn.Close();
conn.Dispose();
SqlConnection.ClearPool(conn);
}
// int found = 0;
return(Tbl);
}
public DataTable GetBookedHistory(string emailid = "", string MobileNo = "")
{
LogTraceWriter traceWriter = new LogTraceWriter();
SqlConnection conn = new SqlConnection();
DataTable dt = new DataTable();
try
{
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "GetBookedHistory....");
//connetionString="Data Source=ServerName;Initial Catalog=DatabaseName;User ID=UserName;Password=Password"
conn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["btposdb"].ToString();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "PSGetBookedHistory";
cmd.Parameters.Add("@emailAddress", SqlDbType.VarChar, 50).Value = (emailid == null) ? "-1" : emailid;
// cmd.Parameters.Add("@emailAddress", SqlDbType.VarChar,50).Value = emailid;
cmd.Parameters.Add("@mobileno", SqlDbType.VarChar, 15).Value = MobileNo;
cmd.Connection = conn;
SqlDataAdapter db = new SqlDataAdapter(cmd);
db.Fill(dt);
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "GetBookedHistory successful....");
StringBuilder str = new StringBuilder();
str.Append("@emailAddress:" + emailid + ",");
str.Append("@mobileno" + MobileNo + ",");
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "GetBookedHistory Input sent...." + str.ToString());
if (dt.Rows.Count > 0)
{
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "GetBookedHistory Output...." + dt.Rows[0].ToString());
}
else
{
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "GetBookedHistory Output....BookedHistory ");
}
}
catch (Exception ex)
{
traceWriter.Trace(Request, "0", TraceLevel.Error, "{0}", "GetBookedHistory....failed" + 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 DataSet TypesPaging(int groupid, int curpage, int maxrows)
{
//DataTable Tbl = new DataTable();
LogTraceWriter traceWriter = new LogTraceWriter();
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "GetTypesByGroupId credentials....");
//connect to database
SqlConnection conn = new SqlConnection();
//connetionString="Data Source=ServerName;Initial Catalog=DatabaseName;User ID=UserName;Password=Password"
conn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["btposdb"].ToString();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "GetTypesByPaging";
cmd.Connection = conn;
SqlParameter Gid = new SqlParameter();
Gid.ParameterName = "@typegrpid";
Gid.SqlDbType = SqlDbType.Int;
Gid.Value = groupid;
cmd.Parameters.Add(Gid);
SqlParameter cpage = new SqlParameter();
cpage.ParameterName = "@curpage";
cpage.SqlDbType = SqlDbType.Int;
cpage.Value = curpage;
cmd.Parameters.Add(cpage);
SqlParameter mrows = new SqlParameter();
mrows.ParameterName = "@maxrows";
mrows.SqlDbType = SqlDbType.Int;
mrows.Value = maxrows;
cmd.Parameters.Add(mrows);
DataSet ds = new DataSet();
SqlDataAdapter db = new SqlDataAdapter(cmd);
db.Fill(ds);
//Tbl = ds.Tables[0];
//prepare a file
StringBuilder str = new StringBuilder();
str.Append(string.Format("test\n{0}", groupid.ToString()));
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "GetTypesByGroupId Credentials completed.");
// int found = 0;
return(ds);
}
public DataTable GetUserById1(string UserAccountNo)
{
DataTable dt = new DataTable();
DataSet ds = new DataSet();
LogTraceWriter traceWriter = new LogTraceWriter();
SqlConnection conn = new SqlConnection(); try
{
conn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["btposdb"].ToString();
SqlCommand cmd = new SqlCommand();
SqlParameter UId = new SqlParameter("@UserAccountNo", SqlDbType.VarChar, 20);
UId.Value = UserAccountNo;
cmd.Parameters.Add(UId);
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "PSGetAppUserdetails";
SqlDataAdapter sda = new SqlDataAdapter(cmd);
sda.Fill(ds);
dt = ds.Tables[0];
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "AppUserDetails successful....");
StringBuilder str = new StringBuilder();
str.Append("@id:" + UserAccountNo + ",");
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "AppUserDetails Input sent...." + str.ToString());
if (dt.Rows.Count > 0)
{
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "AppUserDetails Output...." + dt.Rows[0].ToString());
}
else
{
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "AppUserDetails Output....App User ");
}
}
catch (Exception ex)
{
traceWriter.Trace(Request, "0", TraceLevel.Error, "{0}", "AppUserDetails failed...." + 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 MOTPverification(VehicleBooking ocr)
{
DataTable dt = new DataTable();
LogTraceWriter traceWriter = new LogTraceWriter();
SqlConnection conn = new SqlConnection();
StringBuilder str = new StringBuilder();
try
{
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "MOTPverification....");
str.Append("PhoneNo:" + ocr.PhoneNo + ",");
str.Append("Mobileotp:" + ocr.Mobileotp + ",");
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 = "HVMOTPverification";
cmd.Connection = conn;
SqlParameter q1 = new SqlParameter("@PhoneNo", SqlDbType.VarChar, 50);
q1.Value = ocr.PhoneNo;
cmd.Parameters.Add(q1);
SqlParameter e = new SqlParameter("@Mobileotp", SqlDbType.VarChar, 10);
e.Value = ocr.Mobileotp;
cmd.Parameters.Add(e);
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "MOTPverification successful....");
}
catch (Exception ex)
{
traceWriter.Trace(Request, "0", TraceLevel.Error, "{0}", "MOTPverification...." + 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);
}
//Verify mobile otp
return(dt);
}
public DataTable Getallocatedriver(int VID)
{
LogTraceWriter traceWriter = new LogTraceWriter();
SqlConnection conn = new SqlConnection();
DataTable dt = new DataTable();
try
{
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "Getallocatedriver....");
conn.ConnectionString = ConfigurationManager.ConnectionStrings["btposdb"].ToString();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "HVGetallocatedriver";
cmd.Connection = conn;
cmd.Parameters.Add("@VID", SqlDbType.Int).Value = VID;
SqlDataAdapter db = new SqlDataAdapter(cmd);
db.Fill(dt);
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "Getallocatedriver successful....");
StringBuilder str = new StringBuilder();
str.Append("@VID:" + VID + ",");
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "Getallocatedriver Input sent...." + str.ToString());
if (dt.Rows.Count > 0)
{
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "Getallocatedriver Output...." + dt.Rows[0].ToString());
}
else
{
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "Getallocatedriver Output....Assign Driver Details");
}
}
catch (Exception ex)
{
traceWriter.Trace(Request, "0", TraceLevel.Error, "{0}", "Getallocatedriver...." + ex.Message.ToString());
//throw ex;
//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 int TripRating(VehicleBooking b)
{
int status = 1;
LogTraceWriter traceWriter = new LogTraceWriter();
SqlConnection conn = new SqlConnection();
StringBuilder str = new StringBuilder();
try
{
traceWriter.Trace(Request, "0", System.Diagnostics.TraceLevel.Info, "{0}", "TripRating....");
str.Append("BookingId:" + b.BookingId + ",");
str.Append("Rating:" + b.Rating + ",");
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "Input sent...." + str.ToString());
conn.ConnectionString = ConfigurationManager.ConnectionStrings["btposdb"].ToString();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "PSTrackVehicleHistory";
cmd.Connection = conn;
conn.Open();
SqlParameter bb = new SqlParameter("@BookingId", SqlDbType.VarChar, 50);
bb.Value = b.BookingId;
cmd.Parameters.Add(bb);
SqlParameter sr = new SqlParameter("@Rating", SqlDbType.Int);
sr.Value = b.Rating;
cmd.Parameters.Add(sr);
SqlParameter sb = new SqlParameter("@RatedBy", SqlDbType.VarChar, 50);
sb.Value = b.RatedBy;
cmd.Parameters.Add(sb);
SqlParameter sc = new SqlParameter("@Comments", SqlDbType.VarChar, 50);
sc.Value = b.Comments;
cmd.Parameters.Add(sc);
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "TripRating successful....");
}
catch (Exception ex)
{
traceWriter.Trace(Request, "0", TraceLevel.Error, "{0}", "TripRating...." + ex.Message.ToString());
throw new HttpResponseException(Request.CreateErrorResponse(HttpStatusCode.OK, ex.Message));
}
finally
{
conn.Close();
conn.Dispose();
SqlConnection.ClearPool(conn);
}
return(status);
}
public DataTable GetAvailableServices(int srcId, int destId)
{
DataTable Tbl = new DataTable();
LogTraceWriter traceWriter = new LogTraceWriter();
SqlConnection conn = new SqlConnection();
StringBuilder str = new StringBuilder();
try
{
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "GetAvailableServices....");
str.Append("srcId:" + srcId + ",");
str.Append("destId:" + destId + ",");
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "Input sent...." + str.ToString());
//connetionString="Data Source=ServerName;Initial Catalog=DatabaseName;User ID=UserName;Password=Password"
conn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["btposdb"].ToString();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "PSGetAvailableServices";
cmd.Parameters.Add("@srcId", SqlDbType.Int).Value = srcId;
cmd.Parameters.Add("@destId", SqlDbType.Int).Value = destId;
cmd.Connection = conn;
DataSet ds = new DataSet();
SqlDataAdapter db = new SqlDataAdapter(cmd);
db.Fill(ds);
Tbl = ds.Tables[0];
int a = Tbl.Rows.Count;
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "GetAvailableServices successful....");
}
catch (Exception ex)
{
traceWriter.Trace(Request, "0", TraceLevel.Error, "{0}", "GetAvailableServices...." + ex.Message.ToString());
//throw new HttpResponseException(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex.Message));
Tbl.Columns.Add("Code");
Tbl.Columns.Add("description");
DataRow dr = Tbl.NewRow();
dr[0] = "ERR001";
dr[1] = ex.Message;
Tbl.Rows.Add(dr);
}
finally
{
conn.Close();
conn.Dispose();
SqlConnection.ClearPool(conn);
}
return(Tbl);
}
public HttpResponseMessage SaveCountries(IEnumerable <Country> countries)
{
LogTraceWriter traceWriter = new LogTraceWriter();
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "SaveCountries ....");
SqlConnection conn = new SqlConnection();
try
{
//connect to database
//connetionString="Data Source=ServerName;Initial Catalog=DatabaseName;User ID=UserName;Password=Password"
conn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["btposdb"].ToString();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "InsUpdCountry";
cmd.Connection = conn;
conn.Open();
foreach (Country c in countries)
{
SqlParameter rid = new SqlParameter();
rid.ParameterName = "@Id";
rid.SqlDbType = SqlDbType.Int;
rid.Value = c.Id;
cmd.Parameters.Add(rid);
SqlParameter cmpid = new SqlParameter();
cmpid.ParameterName = "@HasOperations";
cmpid.SqlDbType = SqlDbType.Int;
cmpid.Value = c.HasOperations;
cmd.Parameters.Add(cmpid);
cmd.ExecuteScalar();
cmd.Parameters.Clear();
}
conn.Close();
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "SaveCountries completed.");
return(new HttpResponseMessage(HttpStatusCode.OK));
}
catch (Exception ex)
{
if (conn != null && conn.State == ConnectionState.Open)
{
conn.Close();
}
string str = ex.Message;
traceWriter.Trace(Request, "1", TraceLevel.Info, "{0}", "Error in SaveCountries:" + ex.Message);
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, ex));
}
}
public DataTable GetBusinessappusersuser(string acct)
{
DataTable dt = new DataTable();
LogTraceWriter traceWriter = new LogTraceWriter();
SqlConnection conn = new SqlConnection();
StringBuilder str = new StringBuilder();
try
{
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "Get Business App User....");
str.Append("UserAccountNo:" + acct + ",");
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 = "GetEwalletStatus";
cmd.Connection = conn;
SqlParameter uaccno = new SqlParameter("@UserAccountNo", SqlDbType.VarChar, 15);
uaccno.Value = acct;
cmd.Parameters.Add(uaccno);
//DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
//dt = ds.Tables[0];
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "successful Get Business App User");
}
catch (Exception ex)
{
traceWriter.Trace(Request, "0", TraceLevel.Error, "{0}", "Get Business App User...." + 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 DataSet GetVehicleDetails(int VID)
{
LogTraceWriter traceWriter = new LogTraceWriter();
SqlConnection conn = new SqlConnection();
StringBuilder str = new StringBuilder();
DataSet dt = new DataSet();
try
{
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "GetVehicleDetails....");
str.Append("VID:" + VID + ",");
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 = "PSgetvehicleDetails";
cmd.Parameters.Add("@VID", SqlDbType.Int).Value = VID;
cmd.Connection = conn;
SqlDataAdapter db = new SqlDataAdapter(cmd);
db.Fill(dt);
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "GetVehicleDetails successful....");
}
catch (Exception ex)
{
traceWriter.Trace(Request, "0", TraceLevel.Error, "{0}", "GetVehicleDetails...." + ex.Message.ToString());
//throw ex;
//throw new HttpResponseException(Request.CreateErrorResponse(HttpStatusCode.OK, ex.Message));
DataTable dt1 = new DataTable();
dt1.Columns.Add("Code");
dt1.Columns.Add("description");
DataRow dr = dt1.NewRow();
dr[0] = "ERR001";
dr[1] = ex.Message;
dt1.Rows.Add(dr);
dt.Tables.Add(dt1);
}
finally
{
conn.Close();
conn.Dispose();
SqlConnection.ClearPool(conn);
}
return(dt);
}
public DataTable DriverGetcurrentbalance(string mobileno)
{
DataTable dt = new DataTable();
LogTraceWriter traceWriter = new LogTraceWriter();
SqlConnection conn = new SqlConnection();
StringBuilder str = new StringBuilder();
try
{
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "Getcurrentbalance....");
str.Append("Mobilenumber:" + mobileno + ",");
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "Input sent...." + str.ToString());
conn.ConnectionString = ConfigurationManager.ConnectionStrings["btposdb"].ToString();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "DriverGetCurrentBalance";
cmd.Connection = conn;
SqlParameter cmpid = new SqlParameter("@Mobilenumber", SqlDbType.VarChar, 20);
cmpid.Value = mobileno;
cmd.Parameters.Add(cmpid);
SqlDataAdapter db = new SqlDataAdapter(cmd);
db.Fill(dt);
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "Getcurrentbalance successful....");
}
catch (Exception ex)
{
traceWriter.Trace(Request, "0", TraceLevel.Error, "{0}", "Getcurrentbalance...." + ex.Message.ToString());
//throw ex;
// 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 WalletBalance(Appusers A)
{
SqlCommand cmd = new SqlCommand();
LogTraceWriter traceWriter = new LogTraceWriter();
SqlConnection conn = new SqlConnection();
DataTable dt = new DataTable();
try
{
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "WalletBalance....");
conn.ConnectionString = ConfigurationManager.ConnectionStrings["btposdb"].ToString();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "PSInsUpdBalance";
cmd.Connection = conn;
SqlParameter f = new SqlParameter("@flag", SqlDbType.VarChar);
f.Value = A.flag;
cmd.Parameters.Add(f);
SqlParameter mn = new SqlParameter("@Mobilenumber", SqlDbType.VarChar, 20);
mn.Value = A.Mobilenumber;
cmd.Parameters.Add(mn);
SqlParameter em = new SqlParameter("@Amount", SqlDbType.Decimal);
em.Value = A.Amount;
cmd.Parameters.Add(em);
SqlParameter St = new SqlParameter("@StatusId", SqlDbType.Int);
St.Value = A.Status;
cmd.Parameters.Add(St);
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "WalletBalance successful....");
}
catch (Exception ex)
{
traceWriter.Trace(Request, "0", TraceLevel.Error, "{0}", "WalletBalance...." + ex.Message.ToString());
throw ex;
}
finally
{
conn.Close();
conn.Dispose();
SqlConnection.ClearPool(conn);
}
return(dt);
}
public DataSet getdashboard(int userid, int roleid, int ctryId)
{
DataTable Ds = new DataTable();
LogTraceWriter traceWriter = new LogTraceWriter();
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "getdashboard credentials....");
//connect to database
SqlConnection conn = new SqlConnection();
//connetionString="Data Source=ServerName;Initial Catalog=DatabaseName;User ID=UserName;Password=Password"
conn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["btposdb"].ToString();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "GetDashboardDetails";
SqlParameter uid = new SqlParameter();
uid.ParameterName = "@userid";
uid.SqlDbType = SqlDbType.Int;
uid.Value = userid;
cmd.Parameters.Add(uid);
SqlParameter rid = new SqlParameter();
rid.ParameterName = "@roleid";
rid.SqlDbType = SqlDbType.Int;
rid.Value = roleid;
cmd.Parameters.Add(rid);
SqlParameter ctrId = new SqlParameter();
ctrId.ParameterName = "@CountryId";
ctrId.SqlDbType = SqlDbType.Int;
ctrId.Value = ctryId;
cmd.Parameters.Add(ctrId);
cmd.Connection = conn;
DataSet ds = new DataSet();
SqlDataAdapter db = new SqlDataAdapter(cmd);
db.Fill(ds);
// Tbl = ds.Tables[0];
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "getdashboard Credentials completed.");
// int found = 0;
return(ds);
}
public DataTable bookingdetails(string PartyName)
{
DataTable dt = new DataTable();
LogTraceWriter traceWriter = new LogTraceWriter();
SqlConnection conn = new SqlConnection();
StringBuilder str = new StringBuilder();
try
{
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "bookingdetails....");
str.Append("PartyName:" + PartyName + ",");
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 = "HVprebookingdetails";
cmd.Parameters.Add("@PartyName", SqlDbType.VarChar, 255).Value = PartyName;
cmd.Connection = conn;
DataSet ds = new DataSet();
SqlDataAdapter db = new SqlDataAdapter(cmd);
db.Fill(ds);
dt = ds.Tables[0];
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "bookingdetails successful....");
}
catch (Exception ex)
{
traceWriter.Trace(Request, "0", TraceLevel.Error, "{0}", "bookingdetails...." + 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 TaxiPrice(int SrcId, int DestId)
{
DataTable dt = new DataTable();
LogTraceWriter traceWriter = new LogTraceWriter();
SqlConnection conn = new SqlConnection();
SqlCommand cmd = new SqlCommand();
StringBuilder str = new StringBuilder();
try
{
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "TaxiPrice....");
str.Append("SrcId:" + SrcId + ",");
str.Append("DestId:" + DestId + ",");
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "Input sent...." + str.ToString());
conn.ConnectionString = ConfigurationManager.ConnectionStrings["btposdb"].ToString();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "PSGetTaxiprice";
cmd.Connection = conn;
cmd.Parameters.Add("@SrcId", SqlDbType.Int).Value = SrcId;
cmd.Parameters.Add("@DestId", SqlDbType.Int).Value = DestId;
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "TaxiPrice successful....");
}
catch (Exception ex)
{
traceWriter.Trace(Request, "0", TraceLevel.Error, "{0}", "TaxiPrice...." + 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 Gettemplates(int Usertypeid)
{
DataTable Tbl = new DataTable();
LogTraceWriter traceWriter = new LogTraceWriter();
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "Gettemplates credentials....");
StringBuilder str = new StringBuilder();
str.Append("@usertypeid" + Usertypeid + ",");
//connect to database
SqlConnection conn = new SqlConnection();
try
{
//connetionString="Data Source=ServerName;Initial Catalog=DatabaseName;User ID=UserName;Password=Password"
conn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["btposdb"].ToString();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "GetSostemplates";
cmd.Connection = conn;
cmd.Parameters.Add("@usertypeid", SqlDbType.Int).Value = Usertypeid;
SqlDataAdapter db = new SqlDataAdapter(cmd);
db.Fill(Tbl);
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "Gettemplates Credentials completed.");
}
catch (Exception ex)
{
traceWriter.Trace(Request, "0", TraceLevel.Error, "{0}", "Gettemplates...." + ex.Message.ToString());
//throw new HttpResponseException(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex.Message));
Tbl.Columns.Add("Code");
Tbl.Columns.Add("description");
DataRow dr = Tbl.NewRow();
dr[0] = "ERR001";
dr[1] = ex.Message;
Tbl.Rows.Add(dr);
}
finally
{
conn.Close();
conn.Dispose();
SqlConnection.ClearPool(conn);
}
// int found = 0;
return(Tbl);
}
