public IList<MultisiteInfo> GetMultiSitePostingsByCariD(int carID)
{
//Decalaring MakesInfo division object collection
IList<MultisiteInfo> MakesInfoIList = new List<MultisiteInfo>();
string spNameString = string.Empty;
//Setting Connection
//Global.INSTANCE_NAME = strCurrentConn;
IDataReader MakesInfoDataReader = null;
//Connect to the database
Database dbDatabase = DatabaseFactory.CreateDatabase(Global.INSTANCE_NAME);
//Assign stored procedure name
spNameString = "USP_GetMultiSitePostingURLsByCarID";
DbCommand dbCommand = null;
try
{
//Set stored procedure to the command object
dbCommand = dbDatabase.GetStoredProcCommand(spNameString);
dbDatabase.AddInParameter(dbCommand, "@carid", DbType.Int64, carID);
//Executing stored procedure
MakesInfoDataReader = dbDatabase.ExecuteReader(dbCommand);
while (MakesInfoDataReader.Read())
{
//Assign values to the MakesInfo object list
MultisiteInfo ObjMakesInfo_Info = new MultisiteInfo();
AssignMultiSiteInfoList(MakesInfoDataReader, ObjMakesInfo_Info);
MakesInfoIList.Add(ObjMakesInfo_Info);
}
}
catch (Exception ex)
{
}
finally
{
MakesInfoDataReader.Close();
}
return MakesInfoIList;
}
public List<CarsInfo.MultisiteInfo> GetMultisiteListingsByCarID(string CarID, string AuthenticationID, string CustomerID, string SessionID,string UID)
{
List<CarsInfo.MultisiteInfo> obj = new List<CarsInfo.MultisiteInfo>();
MobileBL objMobileBL = new MobileBL();
MultisiteInfo objCarInfo = new MultisiteInfo();
if (CustomerID.Trim() != "")
{
DataSet dsSaveCustInfo = objMobileBL.SaveMobileCustomerInfo("GetMultisiteListingsByCarID", CustomerID, AuthenticationID,CarID);
}
try
{
bool bnew = objMobileBL.CheckMobileAuthorizeUSer(SessionID, Convert.ToInt32(UID));
if (bnew)
{
int carIDnew = CarID == "" ? 0 : Convert.ToInt32(CarID);
obj = (List<CarsInfo.MultisiteInfo>)objMobileBL.GetMultiSitePostingsByCariD(carIDnew);
if (obj.Count <=0)
{
objCarInfo.AASuccess = "Failure";
obj.Add(objCarInfo);
}
}
else
{
objCarInfo.AASuccess = "Session timed out";
obj.Add(objCarInfo);
}
}
catch (Exception ex)
{
}
return obj;
}
private void AssignMultiSiteInfoList(IDataReader MakesInfoDataReader, MultisiteInfo ObjMakesInfo_Info)
{
try
{
ObjMakesInfo_Info.AASuccess = "Success";
ObjMakesInfo_Info.MultiSiteName = MakesInfoDataReader["SiteName"].ToString();
ObjMakesInfo_Info.MultisitesURL = MakesInfoDataReader["URL"].ToString();
ObjMakesInfo_Info.PostedDate = MakesInfoDataReader["UrlPostDate"].ToString();
ObjMakesInfo_Info.ValidDays = MakesInfoDataReader["ValidDays"].ToString();
}
catch (Exception ex)
{
}
}