public IEnumerable BindSpecialityList(string lcid, string jobcategory) { try { using (var context = new SidejobEntities()) { switch (Convert.ToInt32(lcid)) { case 1: return (from c in context.Jobs where c.JobCategory == jobcategory && c.JobRank >= 1 && c.JobRank <= 13 select c).ToList(); case 2: return (from c in context.JobsFrs where c.JobCategory == jobcategory && c.JobRank >= 1 && c.JobRank <= 13 select c).ToList(); default: return (from c in context.Jobs where c.JobCategory == jobcategory && c.JobRank >= 1 && c.JobRank <= 13 select c).ToList(); } } } catch (Exception) { using (var context = new SidejobEntities()) { return (from c in context.Jobs where c.JobCategory == jobcategory && c.JobRank >= 1 && c.JobRank <= 13 select c).ToList(); } } }
protected void Page_Load(object sender, EventArgs e) { using (var context = new SidejobEntities()) { try { var CustomerContractID = 1; var customerID = 165; var customerContract = (from c in context.CustomerContracts where c.ContractID == CustomerContractID select c).FirstOrDefault(); var projectrequirement = (from pr in context.ProjectRequirements where pr.ProjectID == customerContract.ProjectID select pr).FirstOrDefault(); //LCID // Description have to be invoked by google translate //Only 5 photos max might be var s = from ph in context.ProjectPhotoes where ph.ProjectID == customerContract.ProjectID select ph; //var projectphoto = ( from ph in context.projects) } catch (Exception) { throw; } } }
public void AutomatedMessageProcessStart() { using (var context = new SidejobEntities()) { var message = (from c in context.AutomatedMessages select c).ToList(); if (message.Count == 0) return; foreach (var m in message) { try { SendEmail(m.EmailAddress, "http://www.my-side-job.com/Schedule/MySideJob/EmailTemplates/AutomatedMessage.aspx", m.Title, m.MessageID.ToString(CultureInfo.InvariantCulture)); // context.DeleteObject(m); context.SaveChanges(); } catch (Exception) { CatchMessage(context, m); } } } }
public void DeletePreviousBidderWin(SidejobEntities context, int projectId) { var previous = (from c in context.ClosedProjects where c.ProjectID == projectId select c.BidderID).FirstOrDefault(); if (previous != null) { var bids = (from c in context.Bids where c.ProjectID == projectId && c.BidderID == previous orderby c.AmountOffered descending select c).FirstOrDefault(); if (bids != null) { int previousbidid = bids.BidID; context.DeleteObject(bids); var previouswinnerbid = (from c in context.ProfessionalWinBids where c.ProID == previous && c.BidID == previousbidid select c).FirstOrDefault();; if (previouswinnerbid != null) { context.DeleteObject(previouswinnerbid); } } context.SaveChanges(); } }
protected void MessageProperties() { //GET THE PDTID FORM ARCHIVE REFUND const string singlespace = " "; const string startofBoldRed = "<span class='DarkRed'><strong>"; const string lastofBoldRed = "</strong></span>"; PDTID = Convert.ToInt32(Request.QueryString["pdtid"]); ProjectID = Convert.ToInt32(Request.QueryString["prid"]); CustomerID = Convert.ToInt32(Request.QueryString["cid"]); if (ProjectID == 0) return; ProjectNotification.Text = Resources.Resource.Project + singlespace + ProjectID + singlespace + Resources.Resource.Notification; ConfirmationEmail.Text = Resources.Resource.RefundEmailMessage1 + singlespace + startofBoldRed + ProjectID + lastofBoldRed + singlespace + Resources.Resource.RefundEmailMessage2; using (var context = new SidejobEntities()) { var archiveRefund = (from c in context.ArchivedRefundCustomerSuccessfulPDTs where c.PDTID == PDTID select c).FirstOrDefault(); if (archiveRefund == null) return; Amount.Text = archiveRefund.GrossTotal.ToString(CultureInfo.InvariantCulture) + singlespace + archiveRefund.CurrencyCode.ToString(CultureInfo.InvariantCulture) + singlespace; Transaction.Text = archiveRefund.TransactionId; NameLabel.Text = archiveRefund.FirstName + singlespace + archiveRefund.LastName; } }
public void ProjectPhoto(TopProject[] results) { using (var context = new SidejobEntities()) { for (var i = 0; i < 3; i++) { int projectID = results[i].ProjectID; var minimunPhotoRank = from ph in context.ProjectPhotoes where ph.PhotoRank != -1 && ph.ProjectID == projectID orderby ph.PhotoRank descending select ph; var photopath = from ph in context.ProjectPhotoes where ph.PhotoRank == -1 && ph.ProjectID == projectID select ph; if (minimunPhotoRank.Any()) { int rank = int.Parse(minimunPhotoRank.First().PhotoRank.ToString(CultureInfo.InvariantCulture)); photopath = from ph in context.ProjectPhotoes where ph.PhotoRank == rank && ph.ProjectID == projectID select ph; } var firstOrDefault = photopath.FirstOrDefault(); if (firstOrDefault != null) results[i].SetPath(firstOrDefault.PhotoPath.ToString(CultureInfo.InvariantCulture)); else { const string projectMissingPrimaryPicture = "http://www.haithem-araissia.com/WIP2/RightCleanSideJOB2008FromInetpub/CleanSIDEJOB2008/Images/NoWorkShopImage.jpg"; results[i].SetPath(projectMissingPrimaryPicture); } } } }
protected void Page_Load(object sender, EventArgs e) { using (var context = new SidejobEntities()) { var projects = (from pr in context.ClosedProjects select pr).ToList(); foreach (var p in projects) { var p1 = p; var newopportunity = (from cp in context.ProjectSecondChances where p1 != null && cp.ProjectID == p1.ProjectID select cp); if (newopportunity.Count() == 2) { ProjectID = p.ProjectID; //Save to ArchivedProjectSecondChance SavedToArchivedProjectSecondChance(context, newopportunity); //Delete Previous BidderWin and Bids DeletePreviousBidderWin(context, ProjectID); //Add Current BidderWin AddNewBidderWin(context, ProjectID); //update project Updateproject(context); } } } }
public IEnumerable BindIndusty(string lcid) { try { using (var context = new SidejobEntities()) { switch (Convert.ToInt32(lcid)) { case 1: return (from c in context.Categories select c).ToList(); case 2: return (from c in context.CategoriesFrs select c).ToList(); default: return (from c in context.Categories select c).ToList(); } } } catch (Exception) { using (var context = new SidejobEntities()) { return (from c in context.Categories select c).ToList(); } } }
public void EmailAutomation() { using (var context = new SidejobEntities()) { var message = (from c in context.AutomatedMessages select c).ToList(); if (message.Count != 0) { foreach (var e in message) { try { SendEmail(e.EmailAddress, e.Title, e.MessageID.ToString(CultureInfo.InvariantCulture), Server.MapPath("~/EmailTemplates/AutomatedMessage.aspx"), Message.Automated); } catch (Exception emailexception) { var emailProblem = new AutomationEmailProblem { MessageID = e.MessageID, EmailAddress = e.EmailAddress, Title = e.Title, Message = e.Message }; context.AddToAutomationEmailProblems(emailProblem); } } } context.DeleteObject(message); context.SaveChanges(); } }
protected void Page_Load(object sender, EventArgs e) { using (var context = new SidejobEntities()) { ProjectID = 20; CleanUpProjectReferences(context); } }
public CustomerGeneral GetCustomer() { using (var context = new SidejobEntities()) { return (from c in context.CustomerGenerals where c.CustomerID == CustomerID select c).FirstOrDefault(); } }
public Professional GetProfessional() { using (var context = new SidejobEntities()) { return (Professional)(from c in context.ProfessionalGeneral2 where c.ProID == NewProID select c); } }
//private void GetValue(SidejobEntities context) //{ // var projectsecondchance = (from c in context.ProjectSecondChances // where c.ProjectID == ProjectID // select c).ToList(); // if (projectsecondchance.Count != 0) // { // foreach (var psc in projectsecondchance) // { // context.DeleteObject(psc); // context.SaveChanges(); // } // } //} private void GetValue(SidejobEntities context, ICollection somelist) { if (somelist.Count <= 0) return; foreach (var item in somelist) { context.DeleteObject(item); context.SaveChanges(); } }
public ProfessionalGeneral2 GetProfessional() { using (var context = new SidejobEntities()) { return (from c in context.ProfessionalGeneral2 where c.ProID == ProfessionalID select c).FirstOrDefault(); } }
public CustomerGeneral2 GetCustomer(int customerid) { using (var context = new SidejobEntities()) { return (from c in context.CustomerGeneral2 where c.CustomerID == customerid select c).FirstOrDefault(); } }
public static string GetExperience(int experienceID, int lcid) { using (var context = new SidejobEntities()) { var result = from c in context.Experiences where c.ExperienceID == experienceID && c.LCID == lcid select c.ExperienceValue; return result.FirstOrDefault(); } }
public static string GetCurrency(int currencyID) { using (var context = new SidejobEntities()) { var result = from c in context.Currencies where c.CurrencyID == currencyID select c.CurrencyValue; return result.FirstOrDefault(); } }
public static string GetRelocation(int relocationID, int lcid) { using (var context = new SidejobEntities()) { var result = from c in context.Relocations where c.RelocationID == relocationID && c.LCID == lcid select c.RelocationValue; return result.FirstOrDefault(); } }
public static string GetFlagPath(int countryID) { using (var context = new SidejobEntities()) { var result = from c in context.CountriesUpdates where c.CountryId == countryID select c.Path; return result.FirstOrDefault(); } }
public static string GetLicensed(int licensedID, int lcid) { using (var context = new SidejobEntities()) { var result = from c in context.Licenseds where c.LicensedID == licensedID && c.LCID == lcid select c.LicensedValue; return result.FirstOrDefault(); } }
public static string GetCrewnumber(int crewnumberID, int lcid) { using (var context = new SidejobEntities()) { var result = from c in context.CrewNumbers where c.crewnumberID == crewnumberID && c.LCID == lcid select c.crewnumberValue; return result.FirstOrDefault(); } }
protected void GetTopProject() { var results = new TopProject[3]; using (var context = new SidejobEntities()) { var currenttimequery = from pr in context.ProjectRequirements join p in context.Projects on pr.ProjectID equals p.ProjectID where (p.StatusInt == 0) && (pr.EndDate >= DateTime.Now) orderby p.ProjectID descending select new { p.ProjectID, ProjectTitle = pr.ProjectTitle.Substring(0, 6) }; if (currenttimequery.Count() > 3) { var checkcurrentimequery = currenttimequery.ToList(); var queryresults = checkcurrentimequery.Take(3).ToList(); for (var i = 0; i < results.Length; ++i) results[i] = new TopProject(int.Parse(queryresults[i].ProjectID.ToString(CultureInfo.InvariantCulture)), queryresults[i].ProjectTitle, ""); } else { var notimequery = from pr in context.ProjectRequirements join p in context.Projects on pr.ProjectID equals p.ProjectID where (p.StatusInt == 0) orderby p.ProjectID descending select new { p.ProjectID, pr.ProjectTitle }; if (notimequery.Count() > 3) { var checknotimequery = notimequery.ToList(); var queryresults = checknotimequery.Take(3).ToList(); for (var i = 0; i < results.Length; ++i) results[i] = new TopProject(int.Parse(queryresults[i].ProjectID.ToString(CultureInfo.InvariantCulture)), queryresults[i].ProjectTitle, ""); } else { var allprojects = from pr in context.ProjectRequirements join p in context.Projects on pr.ProjectID equals p.ProjectID orderby p.ProjectID descending select new { p.ProjectID, pr.ProjectTitle }; var allprojectquery = allprojects.ToList(); var queryresults = allprojectquery.Take(3).ToList(); for (var i = 0; i < results.Length; ++i) results[i] = new TopProject(int.Parse(queryresults[i].ProjectID.ToString(CultureInfo.InvariantCulture)), queryresults[i].ProjectTitle, ""); } } ProjectPhoto(results); //TopProjectDataList.DataSource = results; //TopProjectDataList.DataBind(); } }
public void DeleteFromResponseDelay(SidejobEntities context) { var rd = (from c in context.ResponseDelays where c.ProjectID == ProjectID select c).FirstOrDefault(); if (rd != null) { context.DeleteObject(rd); context.SaveChanges(); } }
public void AddNewBidderWin(SidejobEntities context, int projectId) { var newBid = GetCurrentNewBid(projectId, NewProID); var newwin = new ProfessionalWinBid { BidID = newBid.BidID, ProID = NewProID, NumberofBids = GetNumberofBids(context) }; context.AddToProfessionalWinBids(newwin); context.SaveChanges(); }
protected void CustomerPage() { ///////////////CLEAN THIS MORE/////////////// //Example: //Authenticated //Customer Profile using (var context = new SidejobEntities()) { var customer = (from c in context.CustomerGenerals where c.CustomerID == 85 select c).FirstOrDefault(); var customerportfolio = (from c in context.CustomerPortfolios where c.CustomerID == 85 select c).FirstOrDefault(); if (customer != null) { var customertitle = customer.FirstName + " " + customer.LastName + " " + customer.CountryName + "," + customer.RegionName + "," + customer.CityName; //Page Title + Page Attributes like Profile, photo, add photo Page.Title = customer.FirstName + " " + customer.LastName + "Profile or Images"; var nl1 = new System.Web.UI.WebControls.Literal {Text = Environment.NewLine}; //Title var title = new HtmlMeta {Name = "title", Content = CrawlerStringLimit(customertitle)}; Page.Header.Controls.AddAt(1, title); //Description if (customerportfolio != null) { var customerdescription = customerportfolio.About; var description = new HtmlMeta {Name = "description", Content = CrawlerStringLimit(customerdescription)}; Page.Header.Controls.AddAt(2, description); } //username + + Page Attributes like Profile, photo, add photo var keyword = customer.UserName + Resources.Resource.HomeKeywords; var keywords = new HtmlMeta {Name = "keywords", Content = CrawlerStringLimit(keyword)}; Page.Header.Controls.AddAt(3, keywords); //Author var customerauthor = customer.FirstName + " " + customer.LastName; var author = new HtmlMeta {Name = "auhtor", Content = CrawlerStringLimit(customerauthor)}; Page.Header.Controls.AddAt(4, author); } } }
public void CatchMessage(SidejobEntities context, AutomatedMessage m) { var messageProblem = new AutomationEmailProblem { MessageID = m.MessageID, EmailAddress = m.EmailAddress, Title = m.Title, Message = m.Message }; context.AddToAutomationEmailProblems(messageProblem); context.SaveChanges(); }
public Bid GetCurrentNewBid(int projectid, int professionalid) { using (var context = new SidejobEntities()) { var newbid = (from c in context.Bids where c.ProjectID == projectid && c.BidderID == professionalid orderby c.AmountOffered select c).FirstOrDefault(); return newbid; } }
private void TestPosterBidderMessage() { using (var context = new SidejobEntities()) { var cp = (from c in context.ClosedProjects where c.ProjectID == 105 select c).FirstOrDefault(); var t = new TimeUp(); if (cp != null) t.TestPosterPayFees(105,cp); } }
public static void BidderTimeUpUpdate(int projectid, int actionid) { using (var context = new SidejobEntities()) { var cp = (from c in context.ClosedProjects where c.ProjectID == projectid select c).FirstOrDefault(); if (cp != null) { var timeupUpdate = new TimeUp(projectid, actionid, cp); } } }
public static void BidderResponseDelayUpdate(int projectid) { using (var context = new SidejobEntities()) { var rd = (from c in context.ResponseDelays where c.ProjectID == projectid select c).FirstOrDefault(); if (rd != null) { rd.Status = 4; context.SaveChanges(); } } }