public IList <Client_FocalPoint> GetClientFocalPointList(ClientFocalPoint clientFP)
{
IList <Client_FocalPoint> list = null;
try
{
//using (PMEntities context = new PMEntities("name=PMEntities"))
//{
// var items = context.Knowledge_Project_Members.Include("Knowledge_Project").Include("Profile_Information")
// .Where(p => p.Knowledge_Project.Guid == ProjectGuid)
// .Select(row => new UserDetail { IdMember = row.IdMember, UserName = row.Profile_Information.UserName });
// return items.ToList();
//}
//using (var db = new Cubicle_EntityEntities())
//{
// IQueryable<Client_FocalPoint> query = db.ClientFocalPoints.Include("Clients").Select(p => new Client_FocalPoint { ClientID = p.ClientID, ClientName = p.Client.Clientname, FocalPointID = p.ClientFocalPointID, FocalPointCode = p.ClientFocalPointCode, FocalPointName = p.ClientFocalPointName });
// if (clientFP.ClientFocalPointName != string.Empty)
// query = query.Where(p => p.FocalPointName.ToUpper().Contains(clientFP.ClientFocalPointName.ToUpper()));
// if (clientFP.ClientFocalPointCode != string.Empty)
// query = query.Where(p => p.FocalPointCode.ToUpper().Contains(clientFP.ClientFocalPointCode.ToUpper()));
// if (clientFP.ClientID != 0)
// query = query.Where(p => p.ClientID == clientFP.ClientID);
// list = query.ToList();
//}
}
catch (Exception ex)
{
}
return(list);
}
public Boolean CheckDuplicate(ClientFocalPoint clientFP, Boolean IsInsert)
{
Boolean Result = true;
try
{
var c = _clientFPRepository.GetSingle(p => p.ClientFocalPointName.ToUpper() == clientFP.ClientFocalPointName.ToUpper() && p.ClientFocalPointCode.ToUpper() == clientFP.ClientFocalPointCode.ToUpper() && p.ClientID == clientFP.ClientID);
if (!IsInsert)
{
if (c == null)
{
Result = true;
}
else if (c.ClientFocalPointID == clientFP.ClientFocalPointID)
{
Result = true;
}
else
{
Result = false;
}
}
else
{
if (c == null)
{
Result = true;
}
else
{
Result = false;
}
}
}
catch (Exception ex)
{
//bool false = BusinessLogicExceptionHandler.HandleException(ref ex);
if (false)
{
throw ex;
}
}
return(Result);
}
