public List <ApartmentForAdvartisement> GetApartmentImages(string landloadId, int apartmentId, int propertyId)
{
List <ApartmentForAdvartisement> objApartmentForAdvartisementsList = new List <ApartmentForAdvartisement>();
objDataAccess = DataAccess.NewDataAccess();
objDbCommand = objDataAccess.GetCommand(true, IsolationLevel.ReadCommitted);
DbDataReader objDbDataReader = null;
ApartmentForAdvartisement objApartmentForAdvartisement = null;
objDbCommand.AddInParameter("LandloadId", landloadId);
objDbCommand.AddInParameter("ApartmentId", apartmentId);
objDbCommand.AddInParameter("PropertyId ", propertyId);
try
{
objDbDataReader = objDataAccess.ExecuteReader(objDbCommand, "ams.uspGetApartmentImages",
CommandType.StoredProcedure);
if (objDbDataReader.HasRows)
{
//DocumentBiz.GetApplicantDocuments(applicantId);
while (objDbDataReader.Read())
{
objApartmentForAdvartisement = new ApartmentForAdvartisement();
BuildModel(objDbDataReader, objApartmentForAdvartisement);
objApartmentForAdvartisementsList.Add(objApartmentForAdvartisement);
}
}
}
catch (Exception ex)
{
throw new Exception("Error : " + ex.Message);
}
finally
{
if (objDbDataReader != null)
{
objDbDataReader.Close();
}
objDataAccess.Dispose(objDbCommand);
}
return(objApartmentForAdvartisementsList);
}
//public static List<StaticListItem> GetPropertyFacilityType()
//{
// try
// {
// return CommonBiz.GetCheckBoxList("ams.uspGetPropertyFacilityType");
// }
// catch (Exception ex)
// {
// throw new Exception(ex.Message);
// }
//}
public List <ApartmentForAdvartisement> GetApartmentForAdvartisement()
{
List <ApartmentForAdvartisement> objApartmentForAdvartisementsList = new List <ApartmentForAdvartisement>();
objDataAccess = DataAccess.NewDataAccess();
objDbCommand = objDataAccess.GetCommand(true, IsolationLevel.ReadCommitted);
DbDataReader objDbDataReader = null;
ApartmentForAdvartisement objApartmentForAdvartisement = null;
//objDbCommand.AddInParameter("EmailAsUserID", objUser.Email);
//objDbCommand.AddInParameter("MobileNoAsUserID", objUser.MobileNo);
try
{
objDbDataReader = objDataAccess.ExecuteReader(objDbCommand, "ams.uspGetApartmentForAdvartisement",
CommandType.StoredProcedure);
if (objDbDataReader.HasRows)
{
//DocumentBiz.GetApplicantDocuments(applicantId);
while (objDbDataReader.Read())
{
objApartmentForAdvartisement = new ApartmentForAdvartisement();
BuildModel(objDbDataReader, objApartmentForAdvartisement);
objApartmentForAdvartisementsList.Add(objApartmentForAdvartisement);
}
}
}
catch (Exception ex)
{
throw new Exception("Error : " + ex.Message);
}
finally
{
if (objDbDataReader != null)
{
objDbDataReader.Close();
}
objDataAccess.Dispose(objDbCommand);
}
return(objApartmentForAdvartisementsList);
}
private void BuildModel(DbDataReader objDataReader, ApartmentForAdvartisement objApartmentForAdvartisement)
{
var objDataTable = objDataReader.GetSchemaTable();
foreach (DataRow dr in objDataTable.Rows)
{
var column = dr.ItemArray[0].ToString();
switch (column)
{
case "ApartmentId":
if (!Convert.IsDBNull(objDataReader["ApartmentId"]))
{
objApartmentForAdvartisement.ApartmentId = Convert.ToInt32(objDataReader["ApartmentId"].ToString());
}
break;
case "PropertyId":
if (!Convert.IsDBNull(objDataReader["PropertyId"]))
{
objApartmentForAdvartisement.PropertyId = Convert.ToInt32(objDataReader["PropertyId"].ToString());
}
break;
case "LandloadId":
if (!Convert.IsDBNull(objDataReader["LandloadId"]))
{
objApartmentForAdvartisement.LandloadId = objDataReader["LandloadId"].ToString();
}
break;
case "FloorType":
if (!Convert.IsDBNull(objDataReader["FloorType"]))
{
objApartmentForAdvartisement.FloorType = objDataReader["FloorType"].ToString();
}
break;
case "FullName":
if (!Convert.IsDBNull(objDataReader["FullName"]))
{
objApartmentForAdvartisement.FullName = objDataReader["FullName"].ToString();
}
break;
case "MobileNo":
if (!Convert.IsDBNull(objDataReader["MobileNo"]))
{
objApartmentForAdvartisement.MobileNo = objDataReader["MobileNo"].ToString();
}
break;
case "FloorNo":
if (!Convert.IsDBNull(objDataReader["FloorNo"]))
{
objApartmentForAdvartisement.FloorNo = Convert.ToInt32(objDataReader["FloorNo"].ToString());
}
break;
case "ApartmentSpace":
if (!Convert.IsDBNull(objDataReader["ApartmentSpace"]))
{
objApartmentForAdvartisement.ApartmentSpace = Convert.ToInt32(objDataReader["ApartmentSpace"].ToString());
}
break;
case "Beds":
if (!Convert.IsDBNull(objDataReader["Beds"]))
{
objApartmentForAdvartisement.Beds = Convert.ToInt32(objDataReader["Beds"].ToString());
}
break;
case "AttachBatch":
if (!Convert.IsDBNull(objDataReader["AttachBatch"]))
{
objApartmentForAdvartisement.AttachBatch = Convert.ToInt32(objDataReader["AttachBatch"].ToString());
}
break;
case "CommonBath":
if (!Convert.IsDBNull(objDataReader["CommonBath"]))
{
objApartmentForAdvartisement.CommonBath = Convert.ToInt32(objDataReader["CommonBath"].ToString());
}
break;
case "DiningPosition":
if (!Convert.IsDBNull(objDataReader["DiningPosition"]))
{
objApartmentForAdvartisement.DiningPosition = objDataReader["DiningPosition"].ToString();
}
break;
case "StaffRoom":
if (!Convert.IsDBNull(objDataReader["StaffRoom"]))
{
objApartmentForAdvartisement.StaffRoom = Convert.ToInt32(objDataReader["StaffRoom"].ToString());
}
break;
case "StaffToilet":
if (!Convert.IsDBNull(objDataReader["StaffToilet"]))
{
objApartmentForAdvartisement.StaffToilet = Convert.ToInt32(objDataReader["StaffToilet"].ToString());
}
break;
case "Balconies":
if (!Convert.IsDBNull(objDataReader["Balconies"]))
{
objApartmentForAdvartisement.Balconies = Convert.ToInt32(objDataReader["Balconies"].ToString());
}
break;
case "FloorTypeId":
if (!Convert.IsDBNull(objDataReader["FloorTypeId"]))
{
objApartmentForAdvartisement.FloorTypeId = Convert.ToInt32(objDataReader["FloorTypeId"].ToString());
}
break;
case "Rent":
if (!Convert.IsDBNull(objDataReader["Rent"]))
{
objApartmentForAdvartisement.Rent = Convert.ToInt32(objDataReader["Rent"].ToString());
}
break;
case "Advance":
if (!Convert.IsDBNull(objDataReader["Advance"]))
{
objApartmentForAdvartisement.Advance = Convert.ToInt32(objDataReader["Advance"].ToString());
}
break;
case "SecurityAmount":
if (!Convert.IsDBNull(objDataReader["SecurityAmount"]))
{
objApartmentForAdvartisement.SecurityAmount = Convert.ToInt32(objDataReader["SecurityAmount"].ToString());
}
break;
case "ServiceCharge":
if (!Convert.IsDBNull(objDataReader["ServiceCharge"]))
{
objApartmentForAdvartisement.ServiceCharge = Convert.ToInt32(objDataReader["ServiceCharge"].ToString());
}
break;
case "GasBill":
if (!Convert.IsDBNull(objDataReader["GasBill"]))
{
objApartmentForAdvartisement.GasBill = Convert.ToDecimal(objDataReader["GasBill"].ToString());
}
break;
case "CableTvBill":
if (!Convert.IsDBNull(objDataReader["CableTvBill"]))
{
objApartmentForAdvartisement.CableTvBill = Convert.ToDecimal(objDataReader["CableTvBill"].ToString());
}
break;
case "InternetBill":
if (!Convert.IsDBNull(objDataReader["InternetBill"]))
{
objApartmentForAdvartisement.InternetBill = Convert.ToDecimal(objDataReader["InternetBill"].ToString());
}
break;
case "VacancyStatusId":
if (!Convert.IsDBNull(objDataReader["VacancyStatusId"]))
{
objApartmentForAdvartisement.VacancyStatusId = Convert.ToInt32(objDataReader["VacancyStatusId"].ToString());
}
break;
case "Description":
if (!Convert.IsDBNull(objDataReader["Description"]))
{
objApartmentForAdvartisement.Description = objDataReader["Description"].ToString();
}
break;
case "ApartmentStatus":
if (!Convert.IsDBNull(objDataReader["ApartmentStatus"]))
{
objApartmentForAdvartisement.ApartmentStatus = objDataReader["ApartmentStatus"].ToString();
}
break;
case "PropertyTypeName":
if (!Convert.IsDBNull(objDataReader["PropertyTypeName"]))
{
objApartmentForAdvartisement.PropertyTypeName = objDataReader["PropertyTypeName"].ToString();
}
break;
case "PhotoName":
if (!Convert.IsDBNull(objDataReader["PhotoName"]))
{
objApartmentForAdvartisement.PhotoName = objDataReader["PhotoName"].ToString();
}
break;
case "PhotoUrl":
if (!Convert.IsDBNull(objDataReader["PhotoUrl"]))
{
objApartmentForAdvartisement.PhotoUrl = objDataReader["PhotoUrl"].ToString();
}
break;
case "ApartmentPhotoId":
if (!Convert.IsDBNull(objDataReader["ApartmentPhotoId"]))
{
objApartmentForAdvartisement.ApartmentPhotoId = Convert.ToInt32(objDataReader["ApartmentPhotoId"].ToString());
}
break;
case "Status":
if (!Convert.IsDBNull(objDataReader["Status"]))
{
objApartmentForAdvartisement.Status = Convert.ToBoolean(objDataReader["Status"]);
}
break;
case "EntryDate":
if (!Convert.IsDBNull(objDataReader["EntryDate"]))
{
objApartmentForAdvartisement.EntryDate = Convert.ToDateTime(objDataReader["EntryDate"]);
}
break;
case "EntryBy":
if (!Convert.IsDBNull(objDataReader["EntryBy"]))
{
objApartmentForAdvartisement.EntryBy = objDataReader["EntryBy"].ToString();
}
break;
case "UpdateDate":
if (!Convert.IsDBNull(objDataReader["UpdateDate"]))
{
objApartmentForAdvartisement.UpdateDate = Convert.ToDateTime(objDataReader["UpdateDate"]);
}
break;
case "UpdateBy":
if (!Convert.IsDBNull(objDataReader["UpdateBy"]))
{
objApartmentForAdvartisement.UpdateBy = objDataReader["UpdateBy"].ToString();
}
break;
default:
break;
}
}
objApartmentForAdvartisement.IsNew = false;
objApartmentForAdvartisement.IsDirty = true;
objApartmentForAdvartisement.IsDelete = false;
}
