public BitmapImage CompanIcon(int?CompanyID) { try { using (FBEntities entities = new FBEntities()) { var companyIconFilePath = entities.Company_Info.Where(x => x.CompanyID == CompanyID).Select(x => x.Icon).FirstOrDefault(); if (companyIconFilePath != null) { BitmapImage bitmapImage = new BitmapImage(); bitmapImage.BeginInit(); bitmapImage.UriSource = new Uri(companyIconFilePath); bitmapImage.EndInit(); return(bitmapImage); } else { BitmapImage bitmapImage = new BitmapImage(); bitmapImage.BeginInit(); bitmapImage.UriSource = new Uri("C:\\b\\anon.jpg"); bitmapImage.EndInit(); return(bitmapImage); } } } catch (Exception ex) { throw ex; } }
public bool UpdatePassword(User_Com user_Pass, int?ID, string oldPass) { try { using (FBEntities entities = new FBEntities()) { var user = entities.User_Com.Where(x => x.ID == ID).FirstOrDefault(); if (user.Password != oldPass) { return(false); } else { user.Password = user_Pass.Password; entities.SaveChanges(); return(true); } } } catch (Exception ex) { throw ex; } }
public int?CompanyUser(string mail, string pass) { using (FBEntities entities = new FBEntities()) { int?id = 0; id = entities.User_Com.Where(x => x.Mail == mail).Select(x => x.ID).FirstOrDefault(); if (id != 0) { int?id2 = 0; id2 = entities.User_Com.Where(x => x.Password == pass).Select(x => x.ID).FirstOrDefault(); if (id == id2) { var companyUser = entities.Company.Where(x => x.UserID == id).Select(x => x.CompanyID).FirstOrDefault(); if (companyUser != 0) { return(companyUser); } else { return(0); } } else { return(0); } } else { return(0); } } }
public void getViews() { try { using (FBEntities _contex = new FBEntities()) { // var categories = _contex.FeedBack_Info.Join(_contex.FeedBack_Point, _contex.FeedBack_Point, id, _contex.FeedBack_Point.Where(x => x.FeedBackID == id).FirstOrDefault(); var a = from info in _contex.FeedBack_Info from point in _contex.FeedBack_Point where info.FeedBackID == point.FeedBackID select new { info.FeedBackID, point }; var b = a; } } catch (Exception ex) { throw ex; } }
public List <vFeedBack> getFeedBackList(int?id) { try { using (FBEntities entities = new FBEntities()) { var userFeedBAckID = entities.FeedBack_Info.Where(x => x.UserID == id); int counter = 0; List <vFeedBack> feedBackIDlist = new List <vFeedBack>(); foreach (var item in userFeedBAckID) { var feedbackID = userFeedBAckID.OrderBy(x => x.FeedBackID).Skip(counter).FirstOrDefault(); var view = entities.vFeedBack.Where(x => x.Bildirim_Numarası == feedbackID.FeedBackID).FirstOrDefault(); feedBackIDlist.Add(view); counter++; } return(feedBackIDlist.ToList()); } } catch (Exception ex) { throw ex; } }
public FBRepo(FBEntities ctx) { _ctx = ctx; }