public DataSet USP_SaveVehicleInformation(CarsInfo.CarsInfo objCarsInfo)
{
try
{
DataSet dsCars = new DataSet();
string spNameString = string.Empty;
Database dbDatabase = DatabaseFactory.CreateDatabase(Global.INSTANCE_NAME);
spNameString = "USP_SaveVehicleInformation";
DbCommand dbCommand = null;
dbCommand = dbDatabase.GetStoredProcCommand(spNameString);
dbDatabase.AddInParameter(dbCommand, "@Price", System.Data.DbType.String, objCarsInfo.Price);
dbDatabase.AddInParameter(dbCommand, "@Mileage", System.Data.DbType.String, objCarsInfo.Mileage);
dbDatabase.AddInParameter(dbCommand, "@ExteriorColor", System.Data.DbType.String, objCarsInfo.ExteriorColor);
dbDatabase.AddInParameter(dbCommand, "@CarID", System.Data.DbType.Int32, objCarsInfo.CarID);
dbDatabase.AddInParameter(dbCommand, "@Transmission", System.Data.DbType.String, objCarsInfo.Transmission);
dbDatabase.AddInParameter(dbCommand, "@InteriorColor", System.Data.DbType.String, objCarsInfo.InteriorColor);
dbDatabase.AddInParameter(dbCommand, "@NumberOfDoors", System.Data.DbType.String, objCarsInfo.NumberOfDoors);
dbDatabase.AddInParameter(dbCommand, "@VIN", System.Data.DbType.String, objCarsInfo.VIN);
dbDatabase.AddInParameter(dbCommand, "@NumberOfCylinder", System.Data.DbType.String, objCarsInfo.NumberOfCylinder);
dbDatabase.AddInParameter(dbCommand, "@FuelTypeID", System.Data.DbType.Int32, objCarsInfo.FuelTypeID);
dbDatabase.AddInParameter(dbCommand, "@Zipcode", System.Data.DbType.String, objCarsInfo.Zipcode);
dbDatabase.AddInParameter(dbCommand, "@City", System.Data.DbType.String, objCarsInfo.City);
dbDatabase.AddInParameter(dbCommand, "@StateID", System.Data.DbType.Int32, objCarsInfo.StateID);
dsCars = dbDatabase.ExecuteDataSet(dbCommand);
return(dsCars);
}
catch (Exception ex)
{
throw ex;
}
}
public IList <CarsInfo.CarsInfo> GetCarsearch(string Carid)
{
//Decalaring CarsInfo division object collection
IList <CarsInfo.CarsInfo> CarsInfoIList = new List <CarsInfo.CarsInfo>();
string spNameString = string.Empty;
//Setting Connection
//Global.INSTANCE_NAME = strCurrentConn;
IDataReader CarsInfoDataReader = null;
//Connect to the database
Database dbDatabase = DatabaseFactory.CreateDatabase(Global.INSTANCE_NAME);
//Assign stored procedure name
spNameString = "[USP_SearchCars]";
DbCommand dbCommand = null;
try
{
//Set stored procedure to the command object
dbCommand = dbDatabase.GetStoredProcCommand(spNameString);
dbDatabase.AddInParameter(dbCommand, "@makeID", DbType.Int64, Carid);
//Executing stored procedure
CarsInfoDataReader = dbDatabase.ExecuteReader(dbCommand);
while (CarsInfoDataReader.Read())
{
//Assign values to the CarsInfo object list
CarsInfo.CarsInfo ObjCarsInfo_Info = new CarsInfo.CarsInfo();
AssignCarsInfoList(CarsInfoDataReader, ObjCarsInfo_Info);
CarsInfoIList.Add(ObjCarsInfo_Info);
}
}
catch (Exception ex)
{
bool rethrow = ExceptionPolicy.HandleException(ex, Global.EXCEPTION_POLICY);
if (rethrow)
{
throw;
}
}
finally
{
CarsInfoDataReader.Close();
}
return(CarsInfoIList);
}
public DataSet SaveCarAndSellerInfo(CarsInfo.CarsInfo objCarsInfo, string Description, string ConditionDescription, string Title, int TranBy,
UsedCarsInfo objUsedCarsInfo, int UID, int PackageID, int PaymentID, int UserPackID, int PostingID, string Ip)
{
try
{
DataSet dsCars = new DataSet();
string spNameString = string.Empty;
Database dbDatabase = DatabaseFactory.CreateDatabase(Global.INSTANCE_NAME);
spNameString = "USP_SaveCarAndSellerInfo";
DbCommand dbCommand = null;
dbCommand = dbDatabase.GetStoredProcCommand(spNameString);
dbDatabase.AddInParameter(dbCommand, "@YearOfMake", System.Data.DbType.Int32, objCarsInfo.YearOfMake);
dbDatabase.AddInParameter(dbCommand, "@MakeModelID", System.Data.DbType.Int32, objCarsInfo.MakeModelID);
dbDatabase.AddInParameter(dbCommand, "@BodyTypeID", System.Data.DbType.Int32, objCarsInfo.BodyTypeID);
dbDatabase.AddInParameter(dbCommand, "@VehicleConditionID", System.Data.DbType.Int32, objCarsInfo.VehicleConditionID);
dbDatabase.AddInParameter(dbCommand, "@CarID", System.Data.DbType.Int32, objCarsInfo.CarID);
dbDatabase.AddInParameter(dbCommand, "@Price", System.Data.DbType.String, objCarsInfo.Price);
dbDatabase.AddInParameter(dbCommand, "@Mileage", System.Data.DbType.String, objCarsInfo.Mileage);
dbDatabase.AddInParameter(dbCommand, "@ExteriorColor", System.Data.DbType.String, objCarsInfo.ExteriorColor);
dbDatabase.AddInParameter(dbCommand, "@Transmission", System.Data.DbType.String, objCarsInfo.Transmission);
dbDatabase.AddInParameter(dbCommand, "@InteriorColor", System.Data.DbType.String, objCarsInfo.InteriorColor);
dbDatabase.AddInParameter(dbCommand, "@NumberOfDoors", System.Data.DbType.String, objCarsInfo.NumberOfDoors);
dbDatabase.AddInParameter(dbCommand, "@VIN", System.Data.DbType.String, objCarsInfo.VIN);
dbDatabase.AddInParameter(dbCommand, "@NumberOfCylinder", System.Data.DbType.String, objCarsInfo.NumberOfCylinder);
dbDatabase.AddInParameter(dbCommand, "@FuelTypeID", System.Data.DbType.Int32, objCarsInfo.FuelTypeID);
dbDatabase.AddInParameter(dbCommand, "@Zipcode", System.Data.DbType.String, objCarsInfo.Zipcode);
dbDatabase.AddInParameter(dbCommand, "@City", System.Data.DbType.String, objCarsInfo.City);
dbDatabase.AddInParameter(dbCommand, "@StateID", System.Data.DbType.Int32, objCarsInfo.StateID);
dbDatabase.AddInParameter(dbCommand, "@Description", System.Data.DbType.String, Description);
dbDatabase.AddInParameter(dbCommand, "@ConditionDescription", System.Data.DbType.String, ConditionDescription);
dbDatabase.AddInParameter(dbCommand, "@DriveTrain", System.Data.DbType.String, objCarsInfo.DriveTrain);
dbDatabase.AddInParameter(dbCommand, "@Title", System.Data.DbType.String, Title);
dbDatabase.AddInParameter(dbCommand, "@TranBy", System.Data.DbType.Int32, TranBy);
dbDatabase.AddInParameter(dbCommand, "@sellerID", System.Data.DbType.Int32, objUsedCarsInfo.SellerID);
dbDatabase.AddInParameter(dbCommand, "@sellerName", System.Data.DbType.String, objUsedCarsInfo.SellerName);
dbDatabase.AddInParameter(dbCommand, "@address1", System.Data.DbType.String, objUsedCarsInfo.Address1);
dbDatabase.AddInParameter(dbCommand, "@state", System.Data.DbType.String, objUsedCarsInfo.State);
dbDatabase.AddInParameter(dbCommand, "@Zip", System.Data.DbType.String, objUsedCarsInfo.Zip);
dbDatabase.AddInParameter(dbCommand, "@Phone", System.Data.DbType.String, objUsedCarsInfo.Phone);
dbDatabase.AddInParameter(dbCommand, "@email", System.Data.DbType.String, objUsedCarsInfo.Email);
dbDatabase.AddInParameter(dbCommand, "@UID", System.Data.DbType.Int32, UID);
dbDatabase.AddInParameter(dbCommand, "@PackageID", System.Data.DbType.Int32, PackageID);
dbDatabase.AddInParameter(dbCommand, "@PaymentID", System.Data.DbType.Int32, PaymentID);
dbDatabase.AddInParameter(dbCommand, "@UserPackID", System.Data.DbType.Int32, UserPackID);
dbDatabase.AddInParameter(dbCommand, "@PostingID", System.Data.DbType.Int32, PostingID);
dbDatabase.AddInParameter(dbCommand, "@Ip", System.Data.DbType.String, Ip);
dsCars = dbDatabase.ExecuteDataSet(dbCommand);
return(dsCars);
}
catch (Exception ex)
{
throw ex;
}
}
public IList<CarsInfo.CarsInfo> GetCarsearch(string Carid)
{
//Decalaring CarsInfo division object collection
IList<CarsInfo.CarsInfo> CarsInfoIList = new List<CarsInfo.CarsInfo>();
string spNameString = string.Empty;
//Setting Connection
//Global.INSTANCE_NAME = strCurrentConn;
IDataReader CarsInfoDataReader = null;
//Connect to the database
Database dbDatabase = DatabaseFactory.CreateDatabase(Global.INSTANCE_NAME);
//Assign stored procedure name
spNameString = "[USP_SearchCars]";
DbCommand dbCommand = null;
try
{
//Set stored procedure to the command object
dbCommand = dbDatabase.GetStoredProcCommand(spNameString);
dbDatabase.AddInParameter( dbCommand, "@makeID", DbType.Int64, Carid);
//Executing stored procedure
CarsInfoDataReader = dbDatabase.ExecuteReader(dbCommand);
while (CarsInfoDataReader.Read())
{
//Assign values to the CarsInfo object list
CarsInfo.CarsInfo ObjCarsInfo_Info = new CarsInfo.CarsInfo();
AssignCarsInfoList(CarsInfoDataReader, ObjCarsInfo_Info);
CarsInfoIList.Add(ObjCarsInfo_Info);
}
}
catch (Exception ex)
{
bool rethrow = ExceptionPolicy.HandleException(ex, Global.EXCEPTION_POLICY);
if (rethrow)
throw;
}
finally
{
CarsInfoDataReader.Close();
}
return CarsInfoIList;
}
private void AssignCarsInfoList(IDataReader CarsInfoDataReader, CarsInfo.CarsInfo objCarsInfo)
{
try
{
objCarsInfo.CarID = int.Parse(CarsInfoDataReader["makeID"].ToString());
objCarsInfo.YearOfMake = int.Parse(CarsInfoDataReader["yearOfMake"].ToString());
objCarsInfo.MakeModelID = int.Parse(CarsInfoDataReader["makeModelID"].ToString());
objCarsInfo.MakeModel = CarsInfoDataReader["MakeModel"].ToString();
objCarsInfo.Make = CarsInfoDataReader["Make"].ToString();
objCarsInfo.Mileage = CarsInfoDataReader["mileage"].ToString();
objCarsInfo.Zipcode = CarsInfoDataReader["zipcode"].ToString();
objCarsInfo.VehicleConditionID = CarsInfoDataReader["vehicleConditionID"].ToString();
objCarsInfo.VehicleCondition = CarsInfoDataReader["VehicleCondition"].ToString();
objCarsInfo.Description = CarsInfoDataReader["description"].ToString();
objCarsInfo.Price = CarsInfoDataReader["price"].ToString();
objCarsInfo.Pic1 = CarsInfoDataReader["pic1"].ToString();
objCarsInfo.Pic2 = CarsInfoDataReader["pic2"].ToString();
objCarsInfo.Pic3 = CarsInfoDataReader["pic3"].ToString();
objCarsInfo.Pic4 = CarsInfoDataReader["pic4"].ToString();
objCarsInfo.Pic5 = CarsInfoDataReader["pic5"].ToString();
objCarsInfo.Pic6 = CarsInfoDataReader["pic6"].ToString();
objCarsInfo.Pic7 = CarsInfoDataReader["pic7"].ToString();
objCarsInfo.Pic8 = CarsInfoDataReader["pic8"].ToString();
objCarsInfo.Pic9 = CarsInfoDataReader["pic9"].ToString();
objCarsInfo.Pic10 = CarsInfoDataReader["pic10"].ToString();
objCarsInfo.BodyTypeID = int.Parse(CarsInfoDataReader["bodyTypeID"].ToString());
objCarsInfo.BodyType = CarsInfoDataReader["BodyType"].ToString();
objCarsInfo.Miles_per_gallon = CarsInfoDataReader["Miles_per_gallon"].ToString();
objCarsInfo.FuelTypeID = int.Parse(CarsInfoDataReader["fuelTypeID"].ToString());
objCarsInfo.FuelType = int.Parse(CarsInfoDataReader["FuelType"].ToString());
objCarsInfo.UserFeedback = CarsInfoDataReader["userFeedback"].ToString();
objCarsInfo.ExteriorColor = CarsInfoDataReader["exteriorColor"].ToString();
objCarsInfo.InteriorColor = CarsInfoDataReader["interiorColor"].ToString();
objCarsInfo.NumberOfCylinder = CarsInfoDataReader["numberOfCylinder"].ToString();
objCarsInfo.Transmission = CarsInfoDataReader["makeModelID"].ToString();
objCarsInfo.NumberOfDoors = CarsInfoDataReader["numberOfDoors"].ToString();
objCarsInfo.NumberOfSeats = CarsInfoDataReader["numberOfSeats"].ToString();
objCarsInfo.VIN = CarsInfoDataReader["VIN"].ToString();
}
catch (Exception ex)
{
bool rethrow = ExceptionPolicy.HandleException(ex, Global.EXCEPTION_POLICY);
}
}
public bool USP_UpdatePicturesById(CarsInfo.CarsInfo objCarsInfo, int TranBy)
{
try
{
bool bnew = false;
string spNameString = string.Empty;
Database dbDatabase = DatabaseFactory.CreateDatabase(Global.INSTANCE_NAME);
spNameString = "USP_UpdatePicturesById";
DbCommand dbCommand = null;
dbCommand = dbDatabase.GetStoredProcCommand(spNameString);
dbDatabase.AddInParameter(dbCommand, "@pic1", System.Data.DbType.String, objCarsInfo.Pic1);
dbDatabase.AddInParameter(dbCommand, "@pic2", System.Data.DbType.String, objCarsInfo.Pic2);
dbDatabase.AddInParameter(dbCommand, "@pic3", System.Data.DbType.String, objCarsInfo.Pic3);
dbDatabase.AddInParameter(dbCommand, "@pic4", System.Data.DbType.String, objCarsInfo.Pic4);
dbDatabase.AddInParameter(dbCommand, "@pic5", System.Data.DbType.String, objCarsInfo.Pic5);
dbDatabase.AddInParameter(dbCommand, "@pic6", System.Data.DbType.String, objCarsInfo.Pic6);
dbDatabase.AddInParameter(dbCommand, "@pic7", System.Data.DbType.String, objCarsInfo.Pic7);
dbDatabase.AddInParameter(dbCommand, "@pic8", System.Data.DbType.String, objCarsInfo.Pic8);
dbDatabase.AddInParameter(dbCommand, "@pic9", System.Data.DbType.String, objCarsInfo.Pic9);
dbDatabase.AddInParameter(dbCommand, "@pic10", System.Data.DbType.String, objCarsInfo.Pic10);
dbDatabase.AddInParameter(dbCommand, "@Pic11", System.Data.DbType.String, objCarsInfo.Pic11);
dbDatabase.AddInParameter(dbCommand, "@pic12", System.Data.DbType.String, objCarsInfo.Pic12);
dbDatabase.AddInParameter(dbCommand, "@pic13", System.Data.DbType.String, objCarsInfo.Pic13);
dbDatabase.AddInParameter(dbCommand, "@pic14", System.Data.DbType.String, objCarsInfo.Pic14);
dbDatabase.AddInParameter(dbCommand, "@pic15", System.Data.DbType.String, objCarsInfo.Pic15);
dbDatabase.AddInParameter(dbCommand, "@pic16", System.Data.DbType.String, objCarsInfo.Pic16);
dbDatabase.AddInParameter(dbCommand, "@pic17", System.Data.DbType.String, objCarsInfo.Pic17);
dbDatabase.AddInParameter(dbCommand, "@pic18", System.Data.DbType.String, objCarsInfo.Pic18);
dbDatabase.AddInParameter(dbCommand, "@pic19", System.Data.DbType.String, objCarsInfo.Pic19);
dbDatabase.AddInParameter(dbCommand, "@pic20", System.Data.DbType.String, objCarsInfo.Pic20);
dbDatabase.AddInParameter(dbCommand, "@Pic0", System.Data.DbType.String, objCarsInfo.Pic0);
dbDatabase.AddInParameter(dbCommand, "@CarID", System.Data.DbType.Int32, objCarsInfo.CarID);
dbDatabase.AddInParameter(dbCommand, "@TranBy", System.Data.DbType.Int32, TranBy);
dbDatabase.ExecuteDataSet(dbCommand);
bnew = true;
return(bnew);
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet USP_SaveCarDetails(CarsInfo.CarsInfo objCarsInfo, string Description, string ConditionDescription, string Title, int TranBy)
{
try
{
DataSet dsCars = new DataSet();
string spNameString = string.Empty;
Database dbDatabase = DatabaseFactory.CreateDatabase(Global.INSTANCE_NAME);
spNameString = "[USP_MobileSaveCarDetails]";
DbCommand dbCommand = null;
dbCommand = dbDatabase.GetStoredProcCommand(spNameString);
dbDatabase.AddInParameter(dbCommand, "@YearOfMake", System.Data.DbType.Int32, objCarsInfo.YearOfMake);
dbDatabase.AddInParameter(dbCommand, "@MakeModelID", System.Data.DbType.Int32, objCarsInfo.MakeModelID);
dbDatabase.AddInParameter(dbCommand, "@BodyTypeID", System.Data.DbType.Int32, objCarsInfo.BodyTypeID);
dbDatabase.AddInParameter(dbCommand, "@VehicleConditionID", System.Data.DbType.Int32, objCarsInfo.VehicleConditionID);
dbDatabase.AddInParameter(dbCommand, "@CarID", System.Data.DbType.Int32, objCarsInfo.CarID);
dbDatabase.AddInParameter(dbCommand, "@Price", System.Data.DbType.String, objCarsInfo.Price);
dbDatabase.AddInParameter(dbCommand, "@Mileage", System.Data.DbType.String, objCarsInfo.Mileage);
dbDatabase.AddInParameter(dbCommand, "@ExteriorColor", System.Data.DbType.String, objCarsInfo.ExteriorColor);
dbDatabase.AddInParameter(dbCommand, "@Transmission", System.Data.DbType.String, objCarsInfo.Transmission);
dbDatabase.AddInParameter(dbCommand, "@InteriorColor", System.Data.DbType.String, objCarsInfo.InteriorColor);
dbDatabase.AddInParameter(dbCommand, "@NumberOfDoors", System.Data.DbType.String, objCarsInfo.NumberOfDoors);
dbDatabase.AddInParameter(dbCommand, "@VIN", System.Data.DbType.String, objCarsInfo.VIN);
dbDatabase.AddInParameter(dbCommand, "@NumberOfCylinder", System.Data.DbType.String, objCarsInfo.NumberOfCylinder);
dbDatabase.AddInParameter(dbCommand, "@FuelTypeID", System.Data.DbType.Int32, objCarsInfo.FuelTypeID);
dbDatabase.AddInParameter(dbCommand, "@Zipcode", System.Data.DbType.String, objCarsInfo.Zipcode);
dbDatabase.AddInParameter(dbCommand, "@City", System.Data.DbType.String, objCarsInfo.City);
dbDatabase.AddInParameter(dbCommand, "@StateID", System.Data.DbType.Int32, objCarsInfo.StateID);
dbDatabase.AddInParameter(dbCommand, "@Description", System.Data.DbType.String, Description);
dbDatabase.AddInParameter(dbCommand, "@ConditionDescription", System.Data.DbType.String, ConditionDescription);
dbDatabase.AddInParameter(dbCommand, "@DriveTrain", System.Data.DbType.String, objCarsInfo.DriveTrain);
dbDatabase.AddInParameter(dbCommand, "@Title", System.Data.DbType.String, Title);
dbDatabase.AddInParameter(dbCommand, "@TranBy", System.Data.DbType.Int32, TranBy);
dsCars = dbDatabase.ExecuteDataSet(dbCommand);
return(dsCars);
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet USP_SaveVehicleType(CarsInfo.CarsInfo objCarsInfo)
{
try
{
DataSet dsCars = new DataSet();
string spNameString = string.Empty;
Database dbDatabase = DatabaseFactory.CreateDatabase(Global.INSTANCE_NAME);
spNameString = "USP_SaveVehicleType";
DbCommand dbCommand = null;
dbCommand = dbDatabase.GetStoredProcCommand(spNameString);
dbDatabase.AddInParameter(dbCommand, "@YearOfMake", System.Data.DbType.Int32, objCarsInfo.YearOfMake);
dbDatabase.AddInParameter(dbCommand, "@MakeModelID", System.Data.DbType.Int32, objCarsInfo.MakeModelID);
dbDatabase.AddInParameter(dbCommand, "@BodyTypeID", System.Data.DbType.Int32, objCarsInfo.BodyTypeID);
dbDatabase.AddInParameter(dbCommand, "@CarID", System.Data.DbType.Int32, objCarsInfo.CarID);
dsCars = dbDatabase.ExecuteDataSet(dbCommand);
return(dsCars);
}
catch (Exception ex)
{
throw ex;
}
}
public string UpdateCarDetails(string UID, string Year, string ExteriorColor, string InteriorColor, string Transmission, string DriveTrain, string NumberOfDoors, string MakeModelID,
string BodyTypeID, string CarID, string Price, string Mileage, string VIN, string NumberOfCylinder, string FueltypeID, string zip,
string City, string Description, string VehicleCondition, string Title, string StateID, string AuthenticationID, string CustomerID, string SessionID)
{
string returnCarID = "Failed";
DropdownBL objdropdownBL = new DropdownBL();
CarsInfo.CarsInfo objcarsInfo = new CarsInfo.CarsInfo();
MobileBL objMobileBL = new MobileBL();
if (CustomerID.Trim() != "")
{
DataSet dsSaveCustInfo = objMobileBL.SaveMobileCustomerInfo("UpdateCarDetails", CustomerID, AuthenticationID,CarID);
}
bool bnew = objMobileBL.CheckMobileAuthorizeUSer(SessionID, Convert.ToInt32(UID));
if (bnew)
{
try
{
if (AuthenticationID == ConfigurationManager.AppSettings["AppleID"].ToString())
{
int Uid = Convert.ToInt32(UID);
objcarsInfo.YearOfMake = Convert.ToInt32(Year);
objcarsInfo.MakeModelID = Convert.ToInt32(MakeModelID);
objcarsInfo.BodyTypeID = Convert.ToInt32(BodyTypeID);
objcarsInfo.CarID = Convert.ToInt32(CarID);
//Check for same make,model year of car
DataSet dsCarID = objMobileBL.CheckMobileCarDetailsByCarID(Convert.ToInt32(CarID), objcarsInfo.MakeModelID, objcarsInfo.YearOfMake);
if (dsCarID.Tables.Count > 0)
{
if (dsCarID.Tables[0].Rows.Count > 0)
{
if (Price == "")
{
objcarsInfo.Price = "0";
}
else
{
objcarsInfo.Price = Price;
}
if (Mileage == "")
{
objcarsInfo.Mileage = "0";
}
else
{
objcarsInfo.Mileage = Mileage;
}
objcarsInfo.ExteriorColor = ExteriorColor;
objcarsInfo.InteriorColor = InteriorColor;
objcarsInfo.Transmission = Transmission;
objcarsInfo.DriveTrain = DriveTrain;
objcarsInfo.NumberOfDoors = NumberOfDoors;
objcarsInfo.VIN = VIN;
objcarsInfo.NumberOfCylinder = NumberOfCylinder;
objcarsInfo.FuelTypeID = Convert.ToInt32(FueltypeID);
if (zip.Length == 4)
{
objcarsInfo.Zipcode = "0" + zip;
}
else
{
objcarsInfo.Zipcode = zip;
}
objcarsInfo.City = GeneralFunc.ToProper(City);
objcarsInfo.StateID = Convert.ToInt32(StateID);
string Condition = GeneralFunc.ToProper(Description);
DataSet dsCarsDetails = objdropdownBL.USP_SaveCarDetails(objcarsInfo, Condition, VehicleCondition, Title, Uid);
if (dsCarsDetails.Tables.Count > 0)
{
if (dsCarsDetails.Tables[0].Rows.Count > 0)
{
returnCarID = "Success";
}
else
{
returnCarID = "Failed";
}
}
else
{
returnCarID = "Failed";
}
}
else
{
returnCarID = "Sorry we are not able to change year,make and model of your car";
}
}
else
{
returnCarID = "Sorry we are not able to change year,make and model of your car";
}
}
}
catch (Exception ex)
{
}
}
else
{
returnCarID = "Session timed out";
}
return returnCarID;
}
protected void btnDelete4_Click(object sender, EventArgs e)
{
try
{
int CarID = Convert.ToInt32(Session["ViewCarID"].ToString());
DataSet dsImagesData = objdropdownBL.GetPicIDsByCarID(CarID);
string picID1 = dsImagesData.Tables[0].Rows[0]["pic1"].ToString();
string picID2 = dsImagesData.Tables[0].Rows[0]["pic2"].ToString();
string picID3 = dsImagesData.Tables[0].Rows[0]["pic3"].ToString();
string picID4 = dsImagesData.Tables[0].Rows[0]["pic4"].ToString();
string picID5 = dsImagesData.Tables[0].Rows[0]["pic5"].ToString();
string picID6 = dsImagesData.Tables[0].Rows[0]["pic6"].ToString();
string picID7 = dsImagesData.Tables[0].Rows[0]["pic7"].ToString();
string picID8 = dsImagesData.Tables[0].Rows[0]["pic8"].ToString();
string picID9 = dsImagesData.Tables[0].Rows[0]["pic9"].ToString();
string picID10 = dsImagesData.Tables[0].Rows[0]["pic10"].ToString();
string picID11 = dsImagesData.Tables[0].Rows[0]["pic11"].ToString();
string picID12 = dsImagesData.Tables[0].Rows[0]["pic12"].ToString();
string picID13 = dsImagesData.Tables[0].Rows[0]["pic13"].ToString();
string picID14 = dsImagesData.Tables[0].Rows[0]["pic14"].ToString();
string picID15 = dsImagesData.Tables[0].Rows[0]["pic15"].ToString();
string picID16 = dsImagesData.Tables[0].Rows[0]["pic16"].ToString();
string picID17 = dsImagesData.Tables[0].Rows[0]["pic17"].ToString();
string picID18 = dsImagesData.Tables[0].Rows[0]["pic18"].ToString();
string picID19 = dsImagesData.Tables[0].Rows[0]["pic19"].ToString();
string picID20 = dsImagesData.Tables[0].Rows[0]["pic20"].ToString();
CarsInfo.CarsInfo objCarsInfo = new CarsInfo.CarsInfo();
objCarsInfo.CarID = CarID;
objCarsInfo.Pic1 = picID1;
objCarsInfo.Pic2 = picID2;
objCarsInfo.Pic3 = picID3;
objCarsInfo.Pic4 = picID5;
objCarsInfo.Pic5 = picID6;
objCarsInfo.Pic6 = picID7;
objCarsInfo.Pic7 = picID8;
objCarsInfo.Pic8 = picID9;
objCarsInfo.Pic9 = picID10;
objCarsInfo.Pic10 = picID11;
objCarsInfo.Pic11 = picID12;
objCarsInfo.Pic12 = picID13;
objCarsInfo.Pic13 = picID14;
objCarsInfo.Pic14 = picID15;
objCarsInfo.Pic15 = picID16;
objCarsInfo.Pic16 = picID17;
objCarsInfo.Pic17 = picID18;
objCarsInfo.Pic18 = picID19;
objCarsInfo.Pic19 = picID20;
objCarsInfo.Pic20 = null;
int UID = Convert.ToInt32(Session[Constants.USER_ID].ToString());
bool bnew = objdropdownBL.UpdatePicturesByIdForSmartz(objCarsInfo, UID);
Response.Redirect("CustomerView.aspx");
}
catch (Exception ex)
{
throw ex;
}
}
