public DataSet SaveCarDetailsToUCE(DealerSiteCarInfo objCarInfo, string UID)
{
DataSet ds = new DataSet();
string spNameString = string.Empty;
//objUsedCars.Connect to the database
Database dbDatabase = DatabaseFactory.CreateDatabase(Global.CarsConnTest);
spNameString = "[USP_SaveCarDataFromDealerSite]";
DbCommand dbCommand = null;
try
{
//objUsedCars.Set stored procedure to the command object
dbCommand = dbDatabase.GetStoredProcCommand(spNameString);
dbCommand.CommandTimeout = 10000;
dbDatabase.AddInParameter(dbCommand, "@CarID", DbType.Int64, objCarInfo.CarID);
dbDatabase.AddInParameter(dbCommand, "@YearOfMake", DbType.Int32, objCarInfo.MakeModelYear);
dbDatabase.AddInParameter(dbCommand, "@Make", DbType.String, objCarInfo.Make);
dbDatabase.AddInParameter(dbCommand, "@Model", DbType.String, objCarInfo.Model);
dbDatabase.AddInParameter(dbCommand, "@BodyType", DbType.String, objCarInfo.BodyType);
dbDatabase.AddInParameter(dbCommand, "@VehicleCondition", DbType.String, objCarInfo.VehicleCondition);
dbDatabase.AddInParameter(dbCommand, "@DriveTrain", DbType.String, objCarInfo.DriveTrain);
dbDatabase.AddInParameter(dbCommand, "@Price", DbType.String, objCarInfo.SellingPrice);
dbDatabase.AddInParameter(dbCommand, "@Mileage", DbType.Int32, objCarInfo.Mileage);
dbDatabase.AddInParameter(dbCommand, "@ExteriorColor", DbType.String, objCarInfo.ExtColor);
dbDatabase.AddInParameter(dbCommand, "@InteriorColor", DbType.String, objCarInfo.IntColor);
dbDatabase.AddInParameter(dbCommand, "@Transmission", DbType.String, objCarInfo.Transmission);
dbDatabase.AddInParameter(dbCommand, "@NumberOfDoors", DbType.String, objCarInfo.Doors);
dbDatabase.AddInParameter(dbCommand, "@VIN", DbType.String, objCarInfo.VIN);
dbDatabase.AddInParameter(dbCommand, "@NumberOfCylinder", DbType.String, objCarInfo.Cylinders);
dbDatabase.AddInParameter(dbCommand, "@FuelType", DbType.String, objCarInfo.FuelType);
dbDatabase.AddInParameter(dbCommand, "@Description", DbType.String, objCarInfo.Description);
dbDatabase.AddInParameter(dbCommand, "@Title", DbType.String, objCarInfo.Title);
dbDatabase.AddInParameter(dbCommand, "@CarStatus", DbType.String, objCarInfo.CarStatus);
dbDatabase.AddInParameter(dbCommand, "@SellerName", DbType.String, objCarInfo.SellerName);
dbDatabase.AddInParameter(dbCommand, "@City", DbType.String, objCarInfo.SellerCity);
dbDatabase.AddInParameter(dbCommand, "@State", DbType.String, objCarInfo.SellerState);
dbDatabase.AddInParameter(dbCommand, "@Email", DbType.String, objCarInfo.SellerEmail);
dbDatabase.AddInParameter(dbCommand, "@PhoneNum", DbType.String, objCarInfo.SellerPhone);
dbDatabase.AddInParameter(dbCommand, "@Zip", DbType.String, objCarInfo.Zip);
dbDatabase.AddInParameter(dbCommand, "@DealerCode", DbType.String, objCarInfo.DealerCode);
dbDatabase.AddInParameter(dbCommand, "@DealerInventoryID", DbType.String, objCarInfo.DealerInventoryID);
dbDatabase.AddInParameter(dbCommand, "@UID", DbType.Int32, UID);
//objUsedCars.Executing stored procedure
ds = dbDatabase.ExecuteDataSet(dbCommand);
// DataSet ds =dbDatabase.ExecuteDataSet(dbCommand);
}
catch (Exception ex)
{
}
finally
{
}
return ds;
}
public List<UCEDealerInfo> UploadCar(DealerSiteCarInfo objCarInfo)
{
var objList = new List<UCEDealerInfo>();
try
{
string DealerCode = objCarInfo.DealerCode.ToString().Trim();
string UserName = objCarInfo.DealerEmailID.ToString().Trim();
string Password = objCarInfo.DealerPwd.ToString().Trim();
string UID = string.Empty;
UCEDealerSiteBL objDealer = new UCEDealerSiteBL();
DataSet dsDealer = objDealer.PerformLoginIntoUCE(UserName, DealerCode, Password);
if (dsDealer.Tables.Count > 0)
{
if (dsDealer.Tables[0].Rows.Count > 0)
{
//CarsBL.Dealer.DealerActions objActions = new CarsBL.Dealer.DealerActions();
UID = dsDealer.Tables[0].Rows[0]["UID"].ToString();
DealerCode = dsDealer.Tables[0].Rows[0]["DealerCode"].ToString();
DataSet dsCheckUser = objDealer.DealerCheckUniqueID(objCarInfo.DealerInventoryID, DealerCode);
if (dsCheckUser.Tables[0].Rows.Count > 0)
{
UCEDealerInfo objInfo = new UCEDealerInfo();
objInfo.AASuccess = "8002:DealerInventory ID is existed";
objInfo.DealerCode = DealerCode;
objInfo.UID = Convert.ToInt32(UID);
objList.Add(objInfo);
}
else
{
DataSet ds = objDealer.SaveCarDetailsToUCE(objCarInfo, UID);
if (ds.Tables.Count > 0)
{
if (ds.Tables[0].Rows.Count > 0)
{
UCEDealerInfo objDealerCarInfo = new UCEDealerInfo();
objDealerCarInfo.AASuccess = "8000:Car details updated successfully";
objDealerCarInfo.CarID = Convert.ToInt32(ds.Tables[0].Rows[0]["carID"].ToString());
objDealerCarInfo.CarUniqueID = Convert.ToInt64(ds.Tables[0].Rows[0]["CarUniqueID"].ToString());
objDealerCarInfo.DealerCode = ds.Tables[0].Rows[0]["DealerCode"].ToString();
objDealerCarInfo.DealerInventoryID = ds.Tables[0].Rows[0]["DealerUniqueID"].ToString();
objDealerCarInfo.CarStatus = ds.Tables[0].Rows[0]["Adstatus"].ToString();
objDealerCarInfo.UID = Convert.ToInt32(UID);
objList.Add(objDealerCarInfo);
}
else
{
UCEDealerInfo objDealerCarInfo = new UCEDealerInfo();
objDealerCarInfo.AASuccess = "8003:Car details not updated successfully";
objDealerCarInfo.DealerCode = DealerCode;
objDealerCarInfo.UID = Convert.ToInt32(UID);
objList.Add(objDealerCarInfo);
}
}
else
{
UCEDealerInfo objDealerCarInfo = new UCEDealerInfo();
objDealerCarInfo.AASuccess = "8003:Car details not updated successfully";
objDealerCarInfo.DealerCode = DealerCode;
objDealerCarInfo.UID = Convert.ToInt32(UID);
objList.Add(objDealerCarInfo);
}
}
}
else
{
UCEDealerInfo objInfo = new UCEDealerInfo();
objInfo.AASuccess = "8001:DealerCode,Username,password not existed";
objInfo.DealerCode = DealerCode;
objList.Add(objInfo);
}
}
else
{
UCEDealerInfo objInfo = new UCEDealerInfo();
objInfo.AASuccess = "8001:DealerCode,Username,password not existed";
objInfo.DealerCode = DealerCode;
objList.Add(objInfo);
}
}
catch (Exception ex)
{
}
return objList;
}