private void OnControlLoad(object sender, EventArgs e)
{
//Event handler for control load event
this.Cursor = Cursors.WaitCursor;
try {
if (!this.DesignMode)
{
if (this.cboClient.Items.Count == 0)
{
this.mClientDS.Clear();
this.mClientDS.Merge(CRMGateway.GetCompanies());
OnClientChanged(null, EventArgs.Empty);
}
if (this.cboAgent.Items.Count == 0)
{
this.mAgentDS.Clear();
this.mAgentDS.AgentTable.AddAgentTableRow("", "", "All", "", "", "", "", "", 0, "", "", "", "", "", "", "", "", "", "");
this.mAgentDS.Merge(CRMGateway.GetAgents());
if (this.cboAgent.Items.Count > 0)
{
this.cboAgent.SelectedIndex = 0;
}
OnAgentChanged(null, EventArgs.Empty);
}
this.dtpFrom.Value = DateTime.Today.AddDays(-90);
this.dtpTo.Value = DateTime.Today;
}
}
catch (Exception ex) { App.ReportError(new ApplicationException(ex.Message, ex)); }
finally { this.Cursor = Cursors.Default; }
}
public long CreateIssue(Issue issue)
{
//Create a new issue
long iid = 0;
try {
//Apply simple business rules
//Create the TransactionScope to execute the commands, guaranteeing that both commands can commit or roll back as a single unit of work
using (TransactionScope scope = new TransactionScope()) {
//
//Create issue
object io = new CRMGateway().CreateIssue(issue.TypeID, issue.Subject, issue.Contact, issue.CompanyID, issue.RegionNumber, issue.DistrictNumber, issue.AgentNumber, issue.StoreNumber);
iid = (long)io;
//Add the single 'Open' action
if (issue.Actions.Count == 0)
{
throw new ApplicationException("No action specified.");
}
;
bool ok = new CRMGateway().CreateAction(issue.Actions[0].TypeID, iid, issue.Actions[0].UserID, issue.Actions[0].Comment);
//Commits the transaction; if an exception is thrown, Complete is not called and the transaction is rolled back
scope.Complete();
}
}
catch (Exception ex) { throw new FaultException <CustomersFault>(new CustomersFault(ex.Message), "Service Error"); }
return(iid);
}
private void OnControlLoad(object sender, EventArgs e)
{
//Event handler for control load event
this.Cursor = Cursors.WaitCursor;
try {
#region Grid customizations from normal layout (to support cell editing)
this.grdDeliveries.DisplayLayout.Override.RowSelectors = DefaultableBoolean.False;
this.grdDeliveries.DisplayLayout.Override.SelectTypeRow = SelectType.None;
this.grdDeliveries.DisplayLayout.Override.SelectTypeCell = SelectType.Single;
this.grdDeliveries.DisplayLayout.TabNavigation = TabNavigation.NextCell;
this.grdDeliveries.DisplayLayout.Override.AllowAddNew = AllowAddNew.No;
this.grdDeliveries.DisplayLayout.Override.AllowDelete = DefaultableBoolean.False;
this.grdDeliveries.DisplayLayout.Override.AllowUpdate = DefaultableBoolean.False;
this.grdDeliveries.DisplayLayout.Override.CellClickAction = CellClickAction.EditAndSelectText;
this.grdDeliveries.DisplayLayout.Override.MaxSelectedCells = 1;
this.grdDeliveries.DisplayLayout.Override.RowFilterMode = RowFilterMode.AllRowsInBand;
this.grdDeliveries.DisplayLayout.Override.RowFilterAction = RowFilterAction.HideFilteredOutRows;
//this.grdDeliveries.DisplayLayout.Bands[0].Columns["CBOL"].SortIndicator = SortIndicator.Descending;
#endregion
if (!this.DesignMode)
{
this.mClients.Merge(CRMGateway.GetCompanies());
if (this.cboClient.Items.Count > 0)
{
this.cboClient.SelectedIndex = 0;
}
}
this.dtpFrom.Value = DateTime.Today.AddDays(-7);
this.dtpTo.Value = DateTime.Today;
}
catch (Exception ex) { App.ReportError(new ApplicationException(ex.Message)); }
finally { this.Cursor = Cursors.Default; }
}
private void OnIssueCategorySelected(object sender, EventArgs e)
{
//Event handler for change in issue category
this.mIssueTypes.Clear();
string issueCategory = this.cboIssueCategory.SelectedValue != null?this.cboIssueCategory.SelectedValue.ToString() : "";
this.mIssueTypes.Merge(CRMGateway.GetIssueTypes(issueCategory));
this.cboIssueType.SelectedIndex = -1;
OnIssueTypeSelected(null, EventArgs.Empty);
}
public byte[] GetAttachment(int id)
{
//Get an existing file attachment from database
byte[] bytes = null;
try {
bytes = new CRMGateway().GetAttachment(id);
}
catch (Exception ex) { throw new FaultException <CustomersFault>(new CustomersFault(ex.Message), "Service Error"); }
return(bytes);
}
public DataSet SearchIssues(string searchText)
{
//Get issue search data
DataSet ds = null;
try {
ds = new CRMGateway().SearchIssues(searchText);
}
catch (Exception ex) { throw new FaultException <CustomersFault>(new CustomersFault(ex.Message), "Service Error"); }
return(ds);
}
public DataSet ViewIssues(DateTime fromDate)
{
//Get issues
DataSet ds = null;
try {
ds = new CRMGateway().ViewIssues(fromDate);
}
catch (Exception ex) { throw new FaultException <CustomersFault>(new CustomersFault(ex.Message), "Service Error"); }
return(ds);
}
private void OnScopeChanged(object sender, EventArgs e)
{
//Event handler for change in scope
try {
//Prepare a location selector for the specified scope
string scope = this.cboScope.SelectedItem != null?this.cboScope.SelectedItem.ToString() : SCOPE_NONE;
this.cboLocation.Visible = (scope == SCOPE_NONE || scope == SCOPE_DISTRICTS || scope == SCOPE_REGIONS || scope == SCOPE_AGENTS);
this.txtStore.Visible = (scope == SCOPE_STORES || scope == SCOPE_SUBSTORES);
this.cboLocation.DataSource = null;
CRMDataset locationDS = new CRMDataset();
CRMDataset ds = null;
int companyID = int.Parse(this.cboCompany.SelectedValue.ToString());
string number = this.cboCompany.SelectedValue.ToString().PadLeft(8, '0').Substring(5, 3);
switch (scope)
{
case SCOPE_DISTRICTS:
ds = CRMGateway.GetDistricts(number);
this.cboLocation.DisplayMember = "LocationTable.LocationName";
this.cboLocation.ValueMember = "LocationTable.Location";
break;
case SCOPE_REGIONS:
ds = CRMGateway.GetRegions(number);
this.cboLocation.DisplayMember = "LocationTable.LocationName";
this.cboLocation.ValueMember = "LocationTable.Location";
break;
case SCOPE_STORES:
case SCOPE_SUBSTORES:
this.txtStore.Text = "";
break;
case SCOPE_AGENTS:
ds = CRMGateway.GetAgents(number);
this.cboLocation.DisplayMember = "AgentTable.AgentSummary";
this.cboLocation.ValueMember = "AgentTable.AgentNumber";
break;
}
if (ds != null)
{
locationDS.Merge(ds);
this.cboLocation.DataSource = locationDS;
}
this.cboLocation.Enabled = this.cboLocation.Items.Count > 0;
if (this.cboLocation.Items.Count > 0)
{
this.cboLocation.SelectedIndex = 0;
}
OnCompanyLocationChanged(null, EventArgs.Empty);
}
catch (Exception ex) { App.ReportError(new ApplicationException("Unexpected error when location scope changed.", ex)); }
}
public DataSet SearchIssuesAdvanced(object[] criteria)
{
//Get issue search data
DataSet ds = null;
try {
ds = new CRMGateway().SearchIssuesAdvanced(criteria);
}
catch (Exception ex) { throw new FaultException <CustomersFault>(new CustomersFault(ex.Message), "Service Error"); }
return(ds);
}
public bool UpdateIssueType(int id, string description, int isactive)
{
//Update an existing issue type
bool updated = false;
try {
//
updated = new CRMGateway().UpdateIssueType(id, description, isactive);
}
catch (Exception ex) { throw new FaultException <CustomersFault>(new CustomersFault(ex.Message), "Service Error"); }
return(updated);
}
public bool CreateIssueType(string type, string category, string description)
{
//Create a new issue type
bool created = false;
try {
//
created = new CRMGateway().CreateIssueType(type, category, description);
}
catch (Exception ex) { throw new FaultException <CustomersFault>(new CustomersFault(ex.Message), "Service Error"); }
return(created);
}
private void OnView(object sender, EventArgs e)
{
//
this.Cursor = Cursors.WaitCursor;
try {
this.mDeliveries.Clear();
if (this.cboClient.SelectedValue != null && this.mskStoreNumber.Text.Trim().Length > 0)
{
this.grdDeliveries.DataSource = CRMGateway.GetDeliveries(int.Parse(this.cboClient.SelectedValue.ToString()), int.Parse(this.mskStoreNumber.Text), this.dtpFrom.Value, this.dtpTo.Value);
}
}
catch (Exception ex) { App.ReportError(new ApplicationException(ex.Message)); }
finally { this.Cursor = Cursors.Default; }
}
private void OnStoreKeyUp(object sender, KeyEventArgs e)
{
//Event handler for store textbox key up event
try {
if (e.KeyCode == Keys.Enter)
{
this.txtStoreName.Text = this.txtStoreAddress.Text = this.txtStoreDetail.Text = "";
if (this.cboClient.SelectedValue != null && this.mskStore.Text.Trim().Length > 0)
{
CRMDataset ds = new CRMDataset();
ds.Merge(CRMGateway.GetStoreDetail(int.Parse(this.cboClient.SelectedValue.ToString()), int.Parse(this.mskStore.Text)));
if (ds.StoreTable.Rows.Count > 0)
{
CRMDataset.StoreTableRow store = ds.StoreTable[0];
this.txtStoreName.Text = store.StoreName.Trim() + " (store #" + store.StoreNumber.ToString() + "; substore #" + store.SubStoreNumber.Trim() + ")";
StringBuilder address = new StringBuilder();
address.AppendLine((!store.IsStoreAddressline1Null() ? store.StoreAddressline1.Trim() : ""));
address.AppendLine((!store.IsStoreAddressline2Null() ? store.StoreAddressline2.Trim() : ""));
address.AppendLine((!store.IsStoreCityNull() ? store.StoreCity.Trim() : "") + ", " +
(!store.IsStoreStateNull() ? store.StoreState.Trim() : "") + " " +
(!store.IsStoreZipNull() ? store.StoreZip.Trim() : ""));
this.txtStoreAddress.Text = address.ToString();
StringBuilder detail = new StringBuilder();
detail.AppendLine((!store.IsRegionDescriptionNull() ? store.RegionDescription.Trim() : "") +
" (" + (!store.IsRegionNull() ? store.Region.Trim() : "") + "), " +
(!store.IsDistrictNameNull() ? store.DistrictName.Trim() : "") +
" (" + (!store.IsDistrictNull() ? store.District.Trim() : "") + ")");
detail.AppendLine("Zone " + (!store.IsZoneNull() ? store.Zone.Trim() : "") + ", " +
"Agent " + (!store.IsAgentNumberNull() ? store.AgentNumber.Trim() : "") + " " +
(!store.IsAgentNameNull() ? store.AgentName.Trim() : ""));
detail.AppendLine("Window " + (!store.IsWindowTimeStartNull() ? store.WindowTimeStart.ToString("HH:mm") : "") + " - " +
(!store.IsWindowTimeEndNull() ? store.WindowTimeEnd.ToString("HH:mm") : "") + ", " +
"Del Days " + getDeliveryDays(store) + ", " +
(!store.IsScanStatusDescrptionNull() ? store.ScanStatusDescrption.Trim() : ""));
detail.AppendLine("JA Transit " + (!store.IsStandardTransitNull() ? store.StandardTransit.ToString() : "") + ", " + "OFD " + getOFD(store));
detail.AppendLine("Special Inst: " + (!store.IsSpecialInstructionsNull() ? store.SpecialInstructions.Trim() : ""));
this.txtStoreDetail.Text = detail.ToString();
}
}
refreshReports();
}
}
catch (Exception ex) { App.ReportError(new ApplicationException("Unexpected error when store keyed in.", ex)); }
}
private void OnAgentChanged(object sender, EventArgs e)
{
//Event handler for change in selected agent
try {
this.mTerminals.Clear();
if (this.cboAgent.SelectedValue != null)
{
this.mTerminals.Merge(CRMGateway.GetAgentTerminals(this.cboAgent.SelectedValue.ToString()));
if (this.cboTerminal.Items.Count > 0)
{
this.cboTerminal.SelectedIndex = 0;
}
OnAgentTerminalChanged(null, EventArgs.Empty);
}
}
catch (Exception ex) { App.ReportError(new ApplicationException("Unexpected error on agent selection.", ex)); }
}
public bool AddAction(Action action)
{
//Add a new action to an existing issue
bool added = false;
try {
//Apply simple business rules
//Create the TransactionScope to execute the commands, guaranteeing that both commands can commit or roll back as a single unit of work
using (TransactionScope scope = new TransactionScope()) {
//
added = new CRMGateway().CreateAction(action.TypeID, action.IssueID, action.UserID, action.Comment);
//Commits the transaction; if an exception is thrown, Complete is not called and the transaction is rolled back
scope.Complete();
}
}
catch (Exception ex) { throw new FaultException <CustomersFault>(new CustomersFault(ex.Message), "Service Error"); }
return(added);
}
public bool AddAttachment(Attachment attachment)
{
//Create a new issue
bool added = false;
try {
//Apply simple business rules
//Create the TransactionScope to execute the commands, guaranteeing that both commands can commit or roll back as a single unit of work
using (TransactionScope scope = new TransactionScope()) {
//
added = new CRMGateway().CreateAttachment(attachment.Filename, attachment.File, attachment.ActionID);
//Commits the transaction; if an exception is thrown, Complete is not called and the transaction is rolled back
scope.Complete();
}
}
catch (Exception ex) { throw new FaultException <CustomersFault>(new CustomersFault(ex.Message), "Service Error"); }
return(added);
}
private void OnFormLoad(object sender, EventArgs e)
{
//Event handler for form load event
this.Cursor = Cursors.WaitCursor;
try {
this.mToolTip = new ToolTip();
this.mToolTip.ShowAlways = true;
this.mToolTip.SetToolTip(this.cboActionType, "Select an action type.");
this.mActionsDS.Clear(); this.mActionsDS.Merge(CRMGateway.GetActionTypes(this.mIssue.ID));
this.cboActionType.SelectedValue = this.mAction.TypeID;
this.txtComment.Text = this.mAction.Comment;
this.txtComments.Text = showAllActions(this.mIssue.Actions);
this.chkShowAll.Checked = true;
OnShowAllCheckedChanged(null, EventArgs.Empty);
}
catch (Exception ex) { App.ReportError(ex); }
finally { OnValidateForm(null, EventArgs.Empty); this.Cursor = Cursors.Default; }
}
private void OnAgentTerminalChanged(object sender, EventArgs e)
{
//Event handler for change in agent terminal
try {
this.txtTerminalName.Text = this.txtTerminalAddress.Text = this.txtTermainlDetail.Text = "";
if (this.cboTerminal.SelectedValue != null)
{
CRMDataset ds = new CRMDataset();
ds.Merge(CRMGateway.GetAgentTerminalDetail(this.cboTerminal.SelectedValue.ToString()));
if (ds.AgentTable.Rows.Count > 0)
{
CRMDataset.AgentTableRow agent = ds.AgentTable[0];
this.txtTerminalName.Text = agent.AgentNumber.ToString() + " - " + agent.AgentName.Trim();
StringBuilder address = new StringBuilder();
address.AppendLine((!agent.IsAddressLine1Null() ? agent.AddressLine1.Trim() : ""));
address.AppendLine((!agent.IsAddressLine2Null() ? agent.AddressLine2.Trim() : ""));
address.AppendLine((!agent.IsCityNull() ? agent.City.Trim() : "") + ", " +
(!agent.IsStateNull() ? agent.State.Trim() : "") + " " +
(!agent.IsZipNull() ? agent.Zip.Trim() : ""));
this.txtTerminalAddress.Text = address.ToString();
StringBuilder detail = new StringBuilder();
detail.AppendLine("Contact: " + (!agent.IsContactNull() ? agent.Contact.Trim() : ""));
detail.AppendLine("Phone: " + (!agent.IsPhoneNull() ? agent.Phone.Trim() : ""));
detail.AppendLine("Coordinator: " + (!agent.IsCoordinatorNull() ? agent.Coordinator.Trim() : ""));
detail.AppendLine("Agent Type: " + (!agent.IsTypeNull() ? agent.Type.Trim() : ""));
detail.AppendLine(
("Main Zone: " + (!agent.IsMainZoneNull() ? agent.MainZone.Trim() : "")) + ", " +
("Type= " + (!agent.IsZoneTypeNull() ? agent.ZoneType.Trim() : "")) + ", " +
("Status= " + (!agent.IsZoneStatusNull() ? agent.ZoneStatus.Trim() : "")) + ", " +
("Is Main= " + (!agent.IsIsMainZoneNull() ? agent.IsMainZone.ToString() : ""))
);
this.txtTermainlDetail.Text = detail.ToString();
}
refreshReports();
}
}
catch (Exception ex) { App.ReportError(new ApplicationException("Unexpected error on agent selection.", ex)); }
}
public DataSet GetIssueTypes(string issueCategory)
{
//Issue types- all or filtered by category
DataSet issueTypes = new DataSet();
try {
DataSet ds = new CRMGateway().GetIssueTypes();
if (ds != null && ds.Tables["IssueTypeTable"] != null && ds.Tables["IssueTypeTable"].Rows.Count > 0)
{
if (issueCategory != null && issueCategory.Trim().Length > 0)
{
issueTypes.Merge(ds.Tables["IssueTypeTable"].Select("Category='" + issueCategory + "'"));
}
else
{
issueTypes.Merge(ds);
}
}
}
catch (Exception ex) { throw new ApplicationException(ex.Message, ex); }
return(issueTypes);
}
private void showStoreDetail()
{
//
this.txtStoreDetail.Clear();
if (this.cboCompany.SelectedValue != null && this.txtStore.Text.Length > 0)
{
CRMDataset ds = new CRMDataset();
switch (this.cboScope.SelectedItem.ToString())
{
case SCOPE_STORES:
ds.Merge(CRMGateway.GetStoreDetail(int.Parse(this.cboCompany.SelectedValue.ToString()), int.Parse(this.txtStore.Text)));
break;
case SCOPE_SUBSTORES:
ds.Merge(CRMGateway.GetStoreDetail(int.Parse(this.cboCompany.SelectedValue.ToString()), this.txtStore.Text));
break;
}
if (ds.StoreTable.Rows.Count > 0)
{
this.txtStoreDetail.Text = getStoreDetailString(ds.StoreTable[0]);
}
}
}
private static void OnDoWork(object sender, DoWorkEventArgs e)
{
//
try { e.Result = CRMGateway.GetIssues(); }
catch { }
}
private void OnFormLoad(object sender, EventArgs e)
{
//Event handler for form load event
this.Cursor = Cursors.WaitCursor;
try {
this.mToolTip = new System.Windows.Forms.ToolTip();
this.mToolTip.ShowAlways = true;
this.mToolTip.SetToolTip(this.cboIssueType, "Select an issue type.");
this.mCompanyDS.Clear(); this.mCompanyDS.Merge(CRMGateway.GetCompanies());
this.mIssueCategorys.Clear(); this.mIssueCategorys.Merge(CRMGateway.GetIssueCategories());
this.mActionsDS.Clear(); this.mActionsDS.Merge(CRMGateway.GetActionTypes(this.mIssue.ID));
if (this.mIssue.ID == 0 && this.mIssue.CompanyID == -1)
{
this.cboCompany.SelectedIndex = -1;
}
else
{
this.cboCompany.SelectedValue = this.mIssue.CompanyID;
}
OnCompanySelected(null, EventArgs.Empty);
if (this.mIssue.DistrictNumber != null)
{
this.cboScope.SelectedItem = SCOPE_DISTRICTS; OnScopeChanged(null, EventArgs.Empty);
this.cboLocation.SelectedValue = this.mIssue.DistrictNumber;
}
else if (this.mIssue.RegionNumber != null)
{
this.cboScope.SelectedItem = SCOPE_REGIONS; OnScopeChanged(null, EventArgs.Empty);
this.cboLocation.SelectedValue = this.mIssue.RegionNumber;
}
else if (this.mIssue.AgentNumber != null)
{
this.cboScope.SelectedItem = SCOPE_AGENTS; OnScopeChanged(null, EventArgs.Empty);
this.cboLocation.SelectedValue = this.mIssue.AgentNumber;
}
else if (this.mIssue.StoreNumber > -1)
{
this.cboScope.SelectedItem = SCOPE_STORES; OnScopeChanged(null, EventArgs.Empty);
this.txtStore.Text = this.mIssue.StoreNumber.ToString();
showStoreDetail();
}
else
{
this.cboLocation.DataSource = null;
}
this.cboIssueCategory.SelectedIndex = -1;
OnIssueCategorySelected(this.cboIssueCategory, EventArgs.Empty);
if (this.mIssue.TypeID > -1)
{
this.cboIssueType.SelectedValue = this.mIssue.TypeID;
}
this.txtContact.Text = this.mIssue.Contact;
this.txtSubject.Text = this.mIssue.Subject;
this.cboActionType.SelectedIndex = -1; // this.mIssue.ID == 0 ? 0 : -1;
this.txtComments.Text = getAllActionComments();
this.chkShowAll.Checked = this.mIssue.ID > 0;
OnShowAllCheckedChanged(null, EventArgs.Empty);
this.cboCompany.Enabled = this.mIssue.ID == 0 && this.cboCompany.Items.Count > 0;
this.cboScope.Enabled = this.mIssue.ID == 0;
this.cboLocation.Enabled = this.txtStore.Enabled = this.mIssue.ID == 0;
this.cboIssueCategory.Enabled = this.cboIssueType.Enabled = this.mIssue.ID == 0;
this.txtContact.Enabled = this.mIssue.ID == 0;
this.txtSubject.Enabled = this.mIssue.ID == 0;
this.chkShowAll.Enabled = this.mIssue.ID > 0 && this.mIssue.Actions.Count > 0;
}
catch (Exception ex) { App.ReportError(ex); }
finally { OnValidateForm(null, EventArgs.Empty); this.Cursor = Cursors.Default; }
}