public BackgroundInfo GetBackgroundInfoByInfoID(int?id)
{
if (id == null)
{
return(null);
}
var peo = db.BackgroundInfoes
.Where(b => b.ID == id).FirstOrDefault();
BackgroundInfo bi = new BackgroundInfo();
if (bi == null)
{
return(null);
}
else
{
bi.ID = peo.ID;
bi.title = peo.title;
bi.type = peo.type;
bi.startDate = peo.startDate;
bi.endDate = peo.endDate;
bi.description = peo.description;
bi.isCurrentPosition = peo.isCurrentPosition;
bi.UserInfoID = peo.UserInfoID;
return(bi);
}
}
public void UpdateCurrentPosition([Bind(Include = "ID,type,title,startDate,endDate,description,isCurrentPosition,UserInfoID,createdDate,updatedDate")] BackgroundInfo backgroundInfo)
{
db.Entry(backgroundInfo).State = EntityState.Modified;
db.Entry(backgroundInfo).Property("createdDate").IsModified = false;
db.Entry(backgroundInfo).Property("UserInfoID").IsModified = false;
db.SaveChanges();
}
public BackgroundInfo GetCurrentPositionByID(int?id, Boolean isCP)
{
BackgroundInfo cP = new BackgroundInfo();
if (id == null)
{
return(null);
}
var peo = db.BackgroundInfoes
.Where(b => b.UserInfoID == id && b.isCurrentPosition == isCP)
.FirstOrDefault();
if (peo == null)
{
return(null);
}
else
{
cP.endDate = peo.endDate;
cP.startDate = peo.startDate;
cP.ID = peo.ID;
cP.type = peo.type;
cP.isCurrentPosition = peo.isCurrentPosition;
cP.title = peo.title;
cP.description = peo.description;
cP.UserInfoID = peo.UserInfoID;
}
return(cP);
}
public List <BackgroundInfo> GetBackgroundInfoByID(int?id, Boolean isCP)
{
List <BackgroundInfo> bInfoes = new List <BackgroundInfo>();
if (id == null)
{
return(null);
}
var peo = db.BackgroundInfoes
.Where(b => b.UserInfoID == id && b.isCurrentPosition == isCP);
//var peo = (from BackgroundInfo in db.BackgroundInfoes select new { Id = obj.Id, Name = obj.Name });
foreach (BackgroundInfo bi in peo)
{
BackgroundInfo b = new BackgroundInfo();
b.description = bi.description;
b.endDate = bi.endDate;
b.startDate = bi.startDate;
b.title = bi.title;
b.type = bi.type;
b.UserInfoID = bi.UserInfoID;
b.ID = bi.ID;
bInfoes.Add(b);
}
if (bInfoes == null)
{
return(null);
}
return(bInfoes);
}
public BackgroundInfo GetCurrentPositionByID(int? id, Boolean isCP)
{
BackgroundInfo cP = new BackgroundInfo();
if (id == null)
{
return null;
}
var peo = db.BackgroundInfoes
.Where(b => b.UserInfoID == id && b.isCurrentPosition == isCP)
.FirstOrDefault();
if (peo == null)
{
return null;
}
else
{
cP.endDate = peo.endDate;
cP.startDate = peo.startDate;
cP.ID = peo.ID;
cP.type = peo.type;
cP.isCurrentPosition = peo.isCurrentPosition;
cP.title = peo.title;
cP.description = peo.description;
cP.UserInfoID = peo.UserInfoID;
}
return cP;
}
public BackgroundInfo GetBackgroundInfoByInfoID(int? id)
{
if (id == null)
{
return null;
}
var peo = db.BackgroundInfoes
.Where(b => b.ID == id).FirstOrDefault();
BackgroundInfo bi = new BackgroundInfo();
if (bi == null)
{
return null;
}
else
{
bi.ID = peo.ID;
bi.title = peo.title;
bi.type = peo.type;
bi.startDate = peo.startDate;
bi.endDate = peo.endDate;
bi.description = peo.description;
bi.isCurrentPosition = peo.isCurrentPosition;
bi.UserInfoID = peo.UserInfoID;
return bi;
}
}
public List<BackgroundInfo> GetBackgroundInfoByID(int? id , Boolean isCP)
{
List<BackgroundInfo> bInfoes = new List<BackgroundInfo>();
if (id == null)
{
return null;
}
var peo = db.BackgroundInfoes
.Where(b => b.UserInfoID == id && b.isCurrentPosition == isCP);
//var peo = (from BackgroundInfo in db.BackgroundInfoes select new { Id = obj.Id, Name = obj.Name });
foreach (BackgroundInfo bi in peo)
{
BackgroundInfo b = new BackgroundInfo();
b.description = bi.description;
b.endDate = bi.endDate;
b.startDate = bi.startDate;
b.title = bi.title;
b.type = bi.type;
b.UserInfoID = bi.UserInfoID;
b.ID = bi.ID;
bInfoes.Add(b);
}
if (bInfoes == null)
{
return null;
}
return bInfoes;
}
public void DeleteBackgroundInfoByID(int?id)
{
if (id == null)
{
//return null;
}
BackgroundInfo backgroundInfo = db.BackgroundInfoes.Find(id);
db.BackgroundInfoes.Remove(backgroundInfo);
db.SaveChanges();
}
public void UpdateCurrentPosition(BackgroundInfo CurrentPositionClient)
{
CurrentPositionBusinessLayer cpbl = new CurrentPositionBusinessLayer();
cpbl.UpdateCurrentPosition(CurrentPositionClient);
}
public void AddCurrentPositionData(BackgroundInfo BackgroundInfoClient)
{
var manager = new UserManager<ApplicationUser>(new UserStore<ApplicationUser>(new ApplicationDbContext()));
var currentUser = manager.FindById(User.Identity.GetUserId());
int id = currentUser.UserInfo.Id;
BackgroundInfo bi = new BackgroundInfo();
bi.UserInfoID = id;
bi.type = BackgroundInfoClient.type;
bi.title = BackgroundInfoClient.title;
bi.endDate = new DateTime(2013,02,08);
bi.startDate = BackgroundInfoClient.startDate;
bi.description = BackgroundInfoClient.description;
bi.isCurrentPosition = true;
bi.createdDate = DateTime.Now;
bi.updatedDate = null;
CurrentPositionBusinessLayer cpBal = new CurrentPositionBusinessLayer();
cpBal.InsertCurrentPosition(bi);
}
public void UpdateBackgroundInfo(BackgroundInfo BackgroundInfoClient)
{
BackgroundInfoBusinessLayer biBal = new BackgroundInfoBusinessLayer();
biBal.UpdateBackgroundInfo(BackgroundInfoClient);
}
public void AddBackgroundInfo(BackgroundInfo BackgroundInfoClient)
{
var manager = new UserManager<ApplicationUser>(new UserStore<ApplicationUser>(new ApplicationDbContext()));
var currentUser = manager.FindById(User.Identity.GetUserId());
int id = currentUser.UserInfo.Id;
BackgroundInfo bi = new BackgroundInfo();
bi.UserInfoID = id;
bi.title = BackgroundInfoClient.title;
bi.type = BackgroundInfoClient.type;
bi.startDate = BackgroundInfoClient.startDate;
bi.endDate = BackgroundInfoClient.endDate;
bi.description = BackgroundInfoClient.description;
bi.isCurrentPosition = false;
BackgroundInfoBusinessLayer biBal = new BackgroundInfoBusinessLayer();
biBal.InsertBackgroundInfo(bi);
}
public void InsertCurrentPosition([Bind(Include = "ID,type,title,startDate,endDate,description,isCurrentPosition,UserInfoID, createdDate, updatedDate")] BackgroundInfo backgroundInfo)
{
db.BackgroundInfoes.Add(backgroundInfo);
db.SaveChanges();
}
