public string GetCaseStatusByCaseID(Object FieldValue)
{
if (FieldValue == null)
{
return String.Empty;
}
else
{
CaseAdmin _CaseStatusAdminAccess = new CaseAdmin();
CaseStatus _caseStatusList = _CaseStatusAdminAccess.GetByCaseStatusID(int.Parse(FieldValue.ToString()));
if (_caseStatusList == null)
{
return string.Empty;
}
else
{
return _caseStatusList.CaseStatusNme;
}
}
}
public string GetCasePriorityByCaseID(Object FieldValue)
{
if (FieldValue == null)
{
return String.Empty;
}
else
{
CaseAdmin _CasePriorityAdmin = new CaseAdmin();
CasePriority _CasePriority = _CasePriorityAdmin.GetByCasePriorityID(int.Parse(FieldValue.ToString()));
if(_CasePriority == null)
{
return string.Empty;
}
else
{
return _CasePriority.CasePriorityNme;
}
}
}
/// <summary>
/// Delete button Click Event
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnDelete_Click(object sender, EventArgs e)
{
CaseAdmin caseAdmin = new CaseAdmin();
NoteAdmin noteAdmin = new NoteAdmin();
Account _account = accountAdmin.GetByAccountID(ItemId);
Guid UserKey = new Guid();
if(_account !=null)
{
if(_account.UserID.HasValue)
//Get UserId for this account
UserKey = _account.UserID.Value;
}
//Delete the note for this AccountId.
noteAdmin.DeleteByAccountId(ItemId);
//Delete the case for this AccountId.
caseAdmin.DeleteByAccountId(ItemId);
bool status = accountAdmin.Delete(_account);
if (status) //Check
{
//Get user by Unique GUID - User Id
MembershipUser user = Membership.GetUser(UserKey);
if (user != null)
{
//Delete online account
Membership.DeleteUser(user.UserName);
}
//Redirect to list page
Response.Redirect(ListPageLink);
}
else
{
lblMsg.Text = "Unable to delete this account. Please try again.";
}
}
private string GetAccountTypeByAccountID(Object FieldValue)
{
if (FieldValue == null)
{
return string.Empty;
}
else
{
CaseAdmin _CaseAdmin = new CaseAdmin();
AccountType _AccountTypeList = _CaseAdmin.GetByAccountTypeID(int.Parse(FieldValue.ToString()));
if (_AccountTypeList != null)
{
return _AccountTypeList.AccountTypeNme;
}
else
{
return String.Empty;
}
}
}
private void BindValues()
{
CaseAdmin _CaseAdmin = new CaseAdmin();
CaseRequest _CaseList = _CaseAdmin.GetByCaseID(ItemID);
if (_CaseList != null)
{
//Set General Case Information
lblCreatedDate.Text = _CaseList.CreateDte.ToShortDateString();
lblTitle.Text = _CaseList.Title;
lblCaseTitle.Text = _CaseList.Title;
lblAccountName.Text = this.GetAccountTypeByAccountID(_CaseList.AccountID);
lblCaseStatus.Text = this.GetCaseStatusByCaseID(_CaseList.CaseStatusID);
lblCasePriority.Text = this.GetCasePriorityByCaseID(_CaseList.CasePriorityID);
//txtCaseDescription.Text = _CaseList.Description;
lblCaseDescription.Text = _CaseList.Description;
//Set Customer Information
lblCustomerName.Text = _CaseList.FirstName + " " + _CaseList.LastName;
lblCompanyName.Text = _CaseList.CompanyName;
lblEmailID.Text = _CaseList.EmailID;
lblPhoneNumber.Text = _CaseList.PhoneNumber;
}
}
/// <summary>
/// Submit Button Click Event
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSubmit_Click(object sender, EventArgs e)
{
CaseAdmin _CaseAdmin = new CaseAdmin();
CaseRequest _CaseList = new CaseRequest();
//If edit mode then retrieve data first
if (itemID > 0 )
{
_CaseList = _CaseAdmin.GetByCaseID(itemID);
}
//Set Null Values
_CaseList.OwnerAccountID = null;
_CaseList.CaseOrigin = "admin";
_CaseList.CreateUser = System.Web.HttpContext.Current.User.Identity.Name;
_CaseList.CreateDte = System.DateTime.Now;
_CaseList.PortalID = ZNodeConfigManager.SiteConfig.PortalID;
//Set Values
_CaseList.Title = txtCaseTitle.Text.Trim();
_CaseList.Description = txtCaseDescription.Text.Trim();
_CaseList.EmailID = txtEmailID.Text.Trim();
_CaseList.FirstName = txtFirstName.Text.Trim();
_CaseList.LastName = txtLastName.Text.Trim();
_CaseList.PhoneNumber = txtPhoneNo.Text.Trim();
_CaseList.CompanyName = txtCompanyName.Text.Trim();
if (lstAccountList.SelectedValue == "-1")
{
_CaseList.AccountID = null;
}
else
{
_CaseList.AccountID = int.Parse(lstAccountList.SelectedValue);
}
if (lstCasePriority.SelectedIndex != -1)
{
_CaseList.CasePriorityID = int.Parse(lstCasePriority.SelectedValue);
}
if (lstCaseStatus.SelectedValue != null)
{
_CaseList.CaseStatusID = int.Parse(lstCaseStatus.SelectedValue);
}
bool retval = false;
if (itemID > 0)
{
retval = _CaseAdmin.Update(_CaseList);
}
else
{
retval = _CaseAdmin.Add(_CaseList);
}
if (retval)
{
//redirect to list page
Response.Redirect("~/admin/secure/sales/cases/list.aspx");
}
else
{
//display error message
lblMsg.Text = "An error occurred while updating. Please try again.";
}
}
private void BindEditData()
{
CaseAdmin _CaseAdmin = new CaseAdmin();
CaseRequest _CaseList = _CaseAdmin.GetByCaseID(itemID);
if (_CaseList != null)
{
if (_CaseList.AccountID == null)
{}
else
{
lstAccountList.SelectedValue = _CaseList.AccountID.ToString();
}
if (lstCasePriority.Items.Count > 0)
{
lstCaseStatus.SelectedValue = _CaseList.CaseStatusID.ToString();
}
if (lstCaseStatus.Items.Count > 0)
{
lstCasePriority.SelectedValue = _CaseList.CasePriorityID.ToString();
}
//set Values
txtCaseTitle.Text = _CaseList.Title;
txtCaseDescription.Text = _CaseList.Description.Replace("<br>", "\r\n");
txtFirstName.Text = _CaseList.FirstName;
txtLastName.Text = _CaseList.LastName;
txtCompanyName.Text = _CaseList.CompanyName;
txtEmailID.Text = _CaseList.EmailID;
txtPhoneNo.Text = _CaseList.PhoneNumber;
lblCaseDate.Text = _CaseList.CreateDte.ToShortDateString();
}
}
private void BindData()
{
//Bind Account Type Dropdown List
CaseAdmin _AdminAccess = new CaseAdmin();
lstAccountList.DataSource = _AdminAccess.GetByPortalID(ZNodeConfigManager.SiteConfig.PortalID);
lstAccountList.DataTextField = "CustomerName";
lstAccountList.DataValueField = "AccountID";
lstAccountList.DataBind();
ListItem LI = new ListItem();
LI.Text = "None";
LI.Value = "-1";
lstAccountList.Items.Insert(0, LI);
lstAccountList.Items[0].Selected = true;
//Bind Case status DropdownList
lstCaseStatus.DataSource = _AdminAccess.GetAllCaseStatus();
lstCaseStatus.DataTextField = "CaseStatusNme";
lstCaseStatus.DataValueField = "CaseStatusID";
lstCaseStatus.DataBind();
//Bind case priority DropdownList
lstCasePriority.DataSource = _AdminAccess.GetAllCasePriority();
lstCasePriority.DataTextField = "CasePriorityNme";
lstCasePriority.DataValueField = "CasePriorityID";
lstCasePriority.DataBind();
}
private void BindData()
{
CaseAdmin _CaseAdmin = new CaseAdmin();
CaseRequest _CaseList = _CaseAdmin.GetByCaseID(ItemId);
if (_CaseList != null)
{
txtEmailSubj.Text = _CaseList.Title;
lblEmailid.Text = _CaseList.EmailID;
}
}
/// <summary>
/// Bind Searched Data
/// </summary>
private void BindSearchData()
{
CaseAdmin _CaseAdminAccess = new CaseAdmin();
DataSet MyDataSet = _CaseAdminAccess.SearchCase(int.Parse(ListCaseStatus.SelectedValue),txtcaseid.Text.Trim(),txtfirstname.Text.Trim(),txtlastname.Text.Trim(),txtcompanyname.Text.Trim(),txttitle.Text.Trim());
DataView dv = new DataView(MyDataSet.Tables[0]);
dv.Sort = "CaseID Desc";
uxGrid.DataSource = dv;
uxGrid.DataBind();
}
private void BindList()
{
CaseAdmin _AdminAccess = new CaseAdmin();
ListCaseStatus.DataSource = _AdminAccess.GetAllCaseStatus();
ListCaseStatus.DataTextField = "CaseStatusNme";
ListCaseStatus.DataValueField = "CaseStatusID";
ListCaseStatus.DataBind();
ListItem newItem = new ListItem();
newItem.Text = "All";
newItem.Value = "-1";
ListCaseStatus.Items.Insert(0, newItem);
ListCaseStatus.SelectedIndex = 1;
}
/// <summary>
/// Binds a Grid
/// </summary>
private void BindGrid()
{
CaseAdmin _CaseAdmin = new CaseAdmin();
TList<CaseRequest> caseList = _CaseAdmin.GetAll();
caseList.Sort("CaseID Desc");
SortDataTable(caseList.ToDataSet(false),"",false);
uxGrid.DataSource = caseList;
uxGrid.DataBind();
}
/// <summary>
/// Occurs when the hyperlink to sort a column is clicked
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void uxGrid_Sorting(object sender, GridViewSortEventArgs e)
{
CaseAdmin _CaseAdminAccess = new CaseAdmin();
DataSet MyDataSet = _CaseAdminAccess.SearchCase(int.Parse(ListCaseStatus.SelectedValue), txtcaseid.Text.Trim(), txtfirstname.Text.Trim(), txtlastname.Text.Trim(), txtcompanyname.Text.Trim(), txttitle.Text.Trim());
uxGrid.DataSource = SortDataTable(MyDataSet, e.SortExpression,true);
uxGrid.DataBind();
if (GetSortDirection() == "DESC")
{
e.SortDirection = (SortDirection.Descending);
}
else
{
e.SortDirection = SortDirection.Ascending;
}
}
