// save Maker info For Company
private void AddOrUpdateMakerInfoForCompany(AutoMaxContext database, Models.DataModel.MakeMappingViewModel viewModel)
{
MakerMapping mm = database.MakerMapping.FirstOrDefault(x => x.MakerId == viewModel.ID);
if (mm == default(MakerMapping))
{
mm = new MakerMapping();
mm.CreatedBy = mm.UpdatedBy = 1;
mm.CreatedDate = mm.UpdatedDate = DateTime.Now;
mm.MakerId = viewModel.ID;
}
else
{
mm.UpdatedDate = DateTime.Now;
}
if (viewModel.CompanyName.Equals(AutoMax.Common.Enums.PostingSites.HARAJ.ToString()))
{
mm.HarajName = viewModel.EntityNameForCompany;
}
else if (viewModel.CompanyName.Equals(AutoMax.Common.Enums.PostingSites.OPENSOUQ.ToString()))
{
mm.OpensooqName = viewModel.EntityNameForCompany;
}
// add new if not exist
if (mm.MakerMappingID == 0)
{
database.MakerMapping.Add(mm);
}
}
// save AutoModel info For Company
private void AddOrUpdateAutoModelForCompany(AutoMaxContext database, Models.DataModel.MakeMappingViewModel viewModel, Models.DataModel.MappingIDName item)
{
AutoModelMapping amm = database.AutoModelMapping.FirstOrDefault(x => x.AutoModelID == item.MappingID);
if (amm == default(AutoModelMapping))
{
amm = new AutoModelMapping();
amm.CreatedBy = amm.UpdatedBy = 1;
amm.CreatedDate = amm.UpdatedDate = DateTime.Now;
amm.AutoModelID = item.MappingID;
}
else
{
amm.UpdatedDate = DateTime.Now;
}
if (viewModel.CompanyName.Equals(AutoMax.Common.Enums.PostingSites.HARAJ.ToString()))
{
amm.HarajName = item.MappingNameForCompany;
}
else if (viewModel.CompanyName.Equals(AutoMax.Common.Enums.PostingSites.OPENSOUQ.ToString()))
{
amm.OpensooqName = item.MappingNameForCompany;
}
// add new if not exist
if (amm.AutoModelMappingID == 0)
{
database.AutoModelMapping.Add(amm);
}
}
public static string GetPostingConfiguration(string name, string defaultvalue = null)
{
AutoMaxContext db = new AutoMaxContext();
var postingConfiguration = db.PostingConfiguration.FirstOrDefault(p => p.Name == name);
if (postingConfiguration == null)
{
return(defaultvalue);
}
else
{
return(postingConfiguration.Value);
}
}
public UserRepository()
{
_db = new AutoMaxContext();
}
/// <summary>
/// Initializes a new instance of the <see cref="GenericRepository{TEntity}"/> class.
/// </summary>
/// <param name="context">The context.</param>
public GenericRepository(AutoMaxContext context)
{
this.context = context;
this.dbSet = context.Set <TEntity>();
}
public void Initialize(AutoMaxContext db, int vehicleId, string postingWebsite)
{
this.db = db;
this.vehicleId = vehicleId;
this.postingWebsite = postingWebsite;
}
public static string GetFullName(string emil)
{
AutoMaxContext db = new AutoMaxContext();
return(db.Users.Where(d => d.Email == emil).Select(d => new { FullName = d.FirstName + " " + d.LastName }).FirstOrDefault().FullName);
}
public static string GetUserRole(this string email)
{
AutoMaxContext db = new AutoMaxContext();
return(db.Users.Where(d => d.Email == email).Select(d => d.UserRole.Role).FirstOrDefault());
}
void executePosting()
{
string methodName = "executePosting";
Library.WriteLog(methodName, "Entered");
try
{
AutoMaxContext db = new AutoMaxContext();
Library.WriteLog(methodName, "Fetching posting with status 1 (Pending)");
var postingDetails = db.PostingDetail
.Include("PostingSite")
.Include("VehicleWizard")
.Include("VehicleWizard.VehicleType")
.Include("VehicleWizard.Maker")
.Include("VehicleWizard.AutoModel")
.Include("VehicleWizard.SubModel")
.Include("VehicleWizard.Year")
.Include("VehicleWizard.VehclieTitle")
.Include("VehicleWizard.AutoCondition")
.Include("VehicleWizard.AutoBodyStyle")
.Include("VehicleWizard.AutoAirBag")
.Include("VehicleWizard.AutoInteriorColor")
.Include("VehicleWizard.AutoDoor")
.Include("VehicleWizard.AutoExteriorColor")
.Include("VehicleWizard.AutoEngine")
.Include("VehicleWizard.EngineCapacity")
.Include("VehicleWizard.DriveType")
.Include("VehicleWizard.FuelType")
.Include("VehicleWizard.AutoTransmission")
.Include("VehicleWizard.MediaPlayer")
.Include("VehicleWizard.RoofType")
.Include("VehicleWizard.Upholstery")
.Where(p => p.PostingStatus.StatusName != "Posted" && p.RetryCount < p.Retries).ToList();
Library.WriteLog(methodName, string.Format("Fetch count {0}", postingDetails.Count), postingDetails.Count > 0 ? LogLevel.Information : LogLevel.Debug);
foreach (PostingDetail pd in postingDetails)
{
WebsiteBot bot = WebsiteBotFactory.Instance.GetWebsiteBot(pd.PostingSite.PostingSiteName);
bot.SetContext(db);
bot.SetPostingDetails(pd);
if (bot.PostAd())
{
Library.WriteLog(methodName, "Posting successfull", LogLevel.Information);
pd.PostingStatus = db.PostingStatus.FirstOrDefault(p => p.StatusName == "Posted");
pd.UpdatedDate = DateTime.Now;
pd.PostingSiteUser = bot.PostingSiteUser;
pd.RetryCount++;
pd.PostingError = "Success";
db.SaveChanges();
}
else
{
Library.WriteLog(methodName, "Posting failed", LogLevel.Information);
pd.PostingStatus = db.PostingStatus.FirstOrDefault(p => p.StatusName == "Failed");
pd.UpdatedDate = DateTime.Now;
pd.RetryCount++;
pd.PostingError = bot.Error;
db.SaveChanges();
}
}
Library.WriteLog(methodName, "Loop completed");
}
catch (Exception ex)
{
Library.WriteLog(methodName, ex.ToString());
}
}
