public List <IP_Info> GetIPInfo()
{
DataTable dt = new DataTable();
List <IP_Info> lstIPInfo = null;
EncryptionLibrary.Encryption ec = new EncryptionLibrary.Encryption();
DBOperation.sConnectionString = ec.Decrypt("37xtqIiIGXiQkQc622OS1AysWTE2NxFWWDrkzVjnSqYRs0iRV5OWMGtRX4lgGMKBje7bNqW7dVO4ndtD+yt8rANeuuGjGou5522ObtIx78K3zkSOVIF5gvWn96hy9OW0");
string sQuery = "SELECT * FROM IP_Info";
DBOperation.ExecuteDBOperation(sQuery, DBOperation.OperationType.SELECT, null, ref dt);
lstIPInfo = (from DataRow dr in dt.Rows
select new IP_Info()
{
SerialNo = Convert.ToInt32(dr["SerialNo"]),
IPv4 = Convert.ToString(dr["IPv4"]),
Proxy = Convert.ToString(dr["Proxy"]),
Proxy_Port = Convert.ToString(dr["Proxy_Port"]),
IPv4_Address = Convert.ToString(dr["IPv4_Address"]),
IPv4_City = Convert.ToString(dr["IPv4_City"]),
IPv4_State = Convert.ToString(dr["IPv4_State"]),
IPv4_Country = Convert.ToString(dr["IPv4_Country"]),
IPv4_Category = Convert.ToString(dr["IPv4_Category"]),
IPv4_Speed = Convert.ToString(dr["IPv4_Speed"]),
ASNUM = Convert.ToString(dr["ASNUM"]),
ORG_NAME = Convert.ToString(dr["ORG_NAME"]),
POSTAL_CODE = Convert.ToString(dr["POSTAL_CODE"]),
LATITUDE = Convert.ToString(dr["LATITUDE"]),
LONGITUDE = Convert.ToString(dr["LONGITUDE"]),
TZ = Convert.ToString(dr["TZ"])
}).ToList();
//try
//{
// lstIPInfo = objIP_Info.;
//}
//catch
//{
// lstIPInfo = null;
//}
return(lstIPInfo);
}
public HttpResponseMessage OfferConsignment(ConsignmentDetail objConsignmentDetail)
{
#region declaration
DataTable dt = new DataTable();
string sQuery = "";
DBOperation.StructDBOperation[] objParam = new DBOperation.StructDBOperation[10];
int iParamCount = 0;
#endregion
DBOperation.sConnectionString = ec.Decrypt(GlobalClass.sConnectionString);
objParam[iParamCount].sParamName = "@vQueryType";
objParam[iParamCount].sParamType = SqlDbType.VarChar;
objParam[iParamCount].sParamValue = "OFFERALOAD";
iParamCount++;
objParam[iParamCount].sParamName = "@iUserId";
objParam[iParamCount].sParamType = SqlDbType.Int;
objParam[iParamCount].sParamValue = Convert.ToString(objConsignmentDetail.UserID);
iParamCount++;
objParam[iParamCount].sParamName = "@vDepartureCity";
objParam[iParamCount].sParamType = SqlDbType.VarChar;
objParam[iParamCount].sParamValue = objConsignmentDetail.DepartureCity;
iParamCount++;
objParam[iParamCount].sParamName = "@vDestinationCity";
objParam[iParamCount].sParamType = SqlDbType.VarChar;
objParam[iParamCount].sParamValue = objConsignmentDetail.DestinationCity;
iParamCount++;
objParam[iParamCount].sParamName = "@dStartDate";
objParam[iParamCount].sParamType = SqlDbType.DateTime;
objParam[iParamCount].sParamValue = objConsignmentDetail.CStartDate.ToString("MM-dd-yyyy hh:mm:ss");
iParamCount++;
objParam[iParamCount].sParamName = "@vMaterial";
objParam[iParamCount].sParamType = SqlDbType.VarChar;
objParam[iParamCount].sParamValue = objConsignmentDetail.Cmaterial;
iParamCount++;
objParam[iParamCount].sParamName = "@fApproximateWeight";
objParam[iParamCount].sParamType = SqlDbType.Float;
objParam[iParamCount].sParamValue = Convert.ToString(objConsignmentDetail.ApproximateWeight);
iParamCount++;
objParam[iParamCount].sParamName = "@dApproximateBudget";
objParam[iParamCount].sParamType = SqlDbType.Float;
objParam[iParamCount].sParamValue = Convert.ToString(objConsignmentDetail.ApproximateBudget);
iParamCount++;
objParam[iParamCount].sParamName = "@bLoading";
objParam[iParamCount].sParamType = SqlDbType.Bit;
objParam[iParamCount].sParamValue = objConsignmentDetail.Loading ? "1" : "0";
iParamCount++;
objParam[iParamCount].sParamName = "@bUnLoading";
objParam[iParamCount].sParamType = SqlDbType.Bit;
objParam[iParamCount].sParamValue = objConsignmentDetail.UnLoading ? "1" : "0";
iParamCount++;
sQuery = "ProcOfferConsignment";
sRetVal = DBOperation.ExecuteDBOperation(sQuery, DBOperation.OperationType.STOREDPROC_UPDATE, objParam, ref dt);
if (sRetVal == "SUCCESS")
{
return(Request.CreateResponse(HttpStatusCode.OK, "Consignment Placed Successfully"));
}
else
{
return(Request.CreateResponse(HttpStatusCode.ExpectationFailed, "Please Contact Administrator with below mentioned error " + sRetVal));
}
}
//***************************************** Place Bid **************************************************
// PlaceBid : Place the bid for a specific consignment *
// GetBidDetail : Get the bid detail on the basis of different filter Crieteria *
// UpdateBid : Update Bid Details. Only Bid amount can modify *
// DeleteBid : Delete bid on the basis of bid ID *
//
//*******************************************************************************************************
/// Function Name : Place Bid
/// Parameter Details
/// 1. BidDetail DTO
///
/// Functionality
/// This function accept Bid details DTO and store into DB
/// Value of Load ID, User ID, Amount is mandatory
public HttpResponseMessage PlaceBid(BidDetail objBidDetail)
{
#region declaration
DataTable dt = new DataTable();
string sQuery = "";
Random r = new Random();
DBOperation.StructDBOperation[] objParam = new DBOperation.StructDBOperation[9];
int iParamCount = 0;
#endregion
DBOperation.sConnectionString = ec.Decrypt(GlobalClass.sConnectionString);
objParam[iParamCount].sParamName = "@vQueryType";
objParam[iParamCount].sParamType = SqlDbType.VarChar;
objParam[iParamCount].sParamValue = "PLACEBID";
iParamCount++;
objParam[iParamCount].sParamName = "@bid";
objParam[iParamCount].sParamType = SqlDbType.VarChar;
objParam[iParamCount].sParamValue = "0";
iParamCount++;
objParam[iParamCount].sParamName = "@cid";
objParam[iParamCount].sParamType = SqlDbType.VarChar;
objParam[iParamCount].sParamValue = Convert.ToString(objBidDetail.CId);
iParamCount++;
objParam[iParamCount].sParamName = "@bidamount";
objParam[iParamCount].sParamType = SqlDbType.VarChar;
objParam[iParamCount].sParamValue = Convert.ToString(objBidDetail.BidAmount);
iParamCount++;
objParam[iParamCount].sParamName = "@userid";
objParam[iParamCount].sParamType = SqlDbType.VarChar;
objParam[iParamCount].sParamValue = Convert.ToString(objBidDetail.UserID);
iParamCount++;
objParam[iParamCount].sParamName = "@viewed";
objParam[iParamCount].sParamType = SqlDbType.VarChar;
objParam[iParamCount].sParamValue = objBidDetail.Viewed;
iParamCount++;
objParam[iParamCount].sParamName = "@status";
objParam[iParamCount].sParamType = SqlDbType.VarChar;
objParam[iParamCount].sParamValue = Convert.ToString(objBidDetail.Status);
iParamCount++;
objParam[iParamCount].sParamName = "@creationdatetime";
objParam[iParamCount].sParamType = SqlDbType.VarChar;
objParam[iParamCount].sParamValue = Convert.ToString(objBidDetail.CreationDateTime.ToString("dd-MM-yyyy"));
iParamCount++;
objParam[iParamCount].sParamName = "@BidUpdateDateTime";
objParam[iParamCount].sParamType = SqlDbType.VarChar;
objParam[iParamCount].sParamValue = Convert.ToString(objBidDetail.BidUpdateDateTime.ToString("dd-MM-yyyy"));;
iParamCount++;
sQuery = "ProcBidOperation";
sRetVal = DBOperation.ExecuteDBOperation(sQuery, DBOperation.OperationType.STOREDPROC_UPDATE, objParam, ref dt);
if (sRetVal == "SUCCESS")
{
return(Request.CreateResponse(HttpStatusCode.OK, "Bid Placed Successfully"));
}
else
{
return(Request.CreateResponse(HttpStatusCode.ExpectationFailed, "Please Contact Administrator with below mentioned error " + sRetVal));
}
}
//***************************************** User Login **************************************************
// UserLogin : Login/Signup user with mobile number *
// ValidateOTP : Validate register mobile number with OTP *
// UpdateUserPreference : Update user preference of user i.e. Company Owner/ Fleet Owner *
// *
//*******************************************************************************************************
public HttpResponseMessage UserLogin(UserLogin objUserLogin)
{
try
{
#region declaration
DataTable dt = new DataTable();
string sQuery = "";
Random r = new Random();
DBOperation.sConnectionString = ec.Decrypt(GlobalClass.sConnectionString);
DBOperation.StructDBOperation[] objParam = new DBOperation.StructDBOperation[3];
int iParamCount = 0;
string sMobile_OTP = "";
#endregion
#region validation
if (long.Equals(objUserLogin.lMobileNo, null) || objUserLogin.lMobileNo.Equals(""))
{
return(Request.CreateResponse(HttpStatusCode.ExpectationFailed, "Mobile Number can't be blank"));
}
#endregion
#region DataBase Entry and Response
if ((objUserLogin.lMobileNo != 0))
{
r = new Random();
sMobile_OTP = r.Next().ToString();
sMobile_OTP = sMobile_OTP.PadLeft(6, '0');
sMobile_OTP = sMobile_OTP.Substring(0, 6);
sendSMS(objUserLogin.lMobileNo, "Your OTP for " + GlobalClass.sCompanyName + " is " + sMobile_OTP);
}
objParam[iParamCount].sParamName = "@vQueryType";
objParam[iParamCount].sParamType = SqlDbType.VarChar;
objParam[iParamCount].sParamValue = "USERLOGIN";
iParamCount++;
objParam[iParamCount].sParamName = "@iMobileNo";
objParam[iParamCount].sParamType = SqlDbType.BigInt;
objParam[iParamCount].sParamValue = Convert.ToString(objUserLogin.lMobileNo);
iParamCount++;
objParam[iParamCount].sParamName = "@iMobileOTP";
objParam[iParamCount].sParamType = SqlDbType.Int;
objParam[iParamCount].sParamValue = sMobile_OTP;
iParamCount++;
sQuery = "ProcUserLogin";
sRetVal = DBOperation.ExecuteDBOperation(sQuery, DBOperation.OperationType.STOREDPROC_UPDATE, objParam, ref dt);
if (sRetVal == "SUCCESS")
{
return(Request.CreateResponse(HttpStatusCode.OK, "SUCCESS"));
}
else
{
return(Request.CreateResponse(HttpStatusCode.ExpectationFailed, "Please Contact Administrator with below mentioned error " + sRetVal));
}
#endregion
}
catch (Exception e1)
{
return(Request.CreateResponse(HttpStatusCode.ExpectationFailed, "Please Contact Administrator with below mentioned error " + e1.Message));
}
}
