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;
}
