/// <summary>
/// Adds the specified service level client.
/// </summary>
/// <param name="serviceLevelClient">The service level client.</param>
/// <returns></returns>
public tbl_ServiceLevelClient Add(tbl_ServiceLevelClient serviceLevelClient)
{
serviceLevelClient.ID = Guid.NewGuid();
_dataContext.tbl_ServiceLevelClient.AddObject(serviceLevelClient);
_dataContext.SaveChanges();
return(serviceLevelClient);
}
/// <summary>
/// Handles the OnInsertCommand event of the rgServiceLevelClient control.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="Telerik.Web.UI.GridCommandEventArgs"/> instance containing the event data.</param>
protected void rgServiceLevelClient_OnInsertCommand(object sender, GridCommandEventArgs e)
{
if (e.Item.OwnerTableView.Name == "ServiceLevelContact")
{
return;
}
var item = e.Item as GridEditableItem;
var values = new Hashtable();
item.ExtractValues(values);
var serviceLevelClient = new tbl_ServiceLevelClient();
item.UpdateValues(serviceLevelClient);
serviceLevelClient.ServiceLevelID = ServiceLevel.ID;
DataManager.ServiceLevelClient.Add(serviceLevelClient);
}
/// <summary>
/// Binds the data.
/// </summary>
private void BindData()
{
CommentsCount = ContentCommentRepository.GetCommentsCount(CurrentUser.Instance.SiteID, ContentId, CommentType);
OfficialComment = ContentCommentRepository.SelectOfficialComment(CurrentUser.Instance.SiteID, ContentId, CommentType);
tbl_ServiceLevelClient serviceLevelClient = null;
var dataManager = new DataManager();
switch (CommentType)
{
case CommentTables.tbl_RequirementComment:
var requirement = dataManager.Requirement.SelectById(CurrentUser.Instance.SiteID, ContentId);
if (requirement != null)
{
serviceLevelClient =
requirement.tbl_ServiceLevel.tbl_ServiceLevelClient.FirstOrDefault(
o => o.ClientID == requirement.CompanyID);
}
break;
case CommentTables.tbl_RequestComment:
var request = dataManager.Request.SelectById(CurrentUser.Instance.SiteID, ContentId);
if (request != null)
{
serviceLevelClient =
request.tbl_ServiceLevel.tbl_ServiceLevelClient.FirstOrDefault(
o => o.ClientID == request.CompanyID);
}
break;
}
if (serviceLevelClient != null)
{
rprDesitnations.DataSource = serviceLevelClient.tbl_ServiceLevelContact.Where(
o => o.tbl_Contact.tbl_User.FirstOrDefault() != null).Select(
o =>
new
{
UserID = o.tbl_Contact.tbl_User.FirstOrDefault().ID,
o.tbl_Contact.UserFullName
});
rprDesitnations.DataBind();
}
}
/// <summary>
/// Deletes the specified service level client.
/// </summary>
/// <param name="serviceLevelClient">The service level client.</param>
public void Delete(tbl_ServiceLevelClient serviceLevelClient)
{
_dataContext.tbl_ServiceLevelClient.DeleteObject(serviceLevelClient);
_dataContext.SaveChanges();
}
/// <summary>
/// Updates the specified service level client.
/// </summary>
/// <param name="serviceLevelClient">The service level client.</param>
public void Update(tbl_ServiceLevelClient serviceLevelClient)
{
_dataContext.SaveChanges();
}
