private int UpdateTerritory() { Cursor.Current = Cursors.WaitCursor; SalesTerritory st = new SalesTerritory(); string name = txtTerritory.Text.Trim(); int terrID = 0; try { terrID = Int32.Parse(lblTerritoryID.Text.ToString()); } catch { terrID = 0; MessageBox.Show("Select a territory to update", "Sales Territory", MessageBoxButtons.OK, MessageBoxIcon.Error); return(0); } finally { Cursor.Current = Cursors.Default; } try { st.Name = name; st.TerritoryID = terrID; st.CountryRegionCode = string.Empty; st.UpdateSalesTerritory(st); } catch (Exception ex) { MessageBox.Show(ex.Message, "Sales Territory", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { Cursor.Current = Cursors.Default; st = null; } return(terrID); }
private void btnSave_Click(object sender, EventArgs e) { SalesTerritory st = new SalesTerritory(); SalesTerritoryHistory hist = new SalesTerritoryHistory(); try { if (txtName.Text.Trim() == String.Empty) { MessageBox.Show("Please enter territory name", "MICS", MessageBoxButtons.OK, MessageBoxIcon.Stop); return; } if (cmbSalesPerson.Items.Count == 0) { btnSave.Enabled = false; } else { btnSave.Enabled = true; } if (cmbSalesPerson.SelectedIndex == 0) { MessageBox.Show("Please select a sale person", "MICS", MessageBoxButtons.OK, MessageBoxIcon.Stop); return; } st.Name = txtName.Text; st.CountryRegionCode = txtCounty.Text; if (txtTerritoryID.Text.Trim() == String.Empty) { //new record hist.TerritoryID = st.AddSalesTerritory(st); hist.SalesPersonID = Int32.Parse(cmbSalesPerson.SelectedValue.ToString()); hist.StartDate = dtStartDate.Value; //hist.EndDate = null; hist.AddSalesTerritoryHistory(hist); MessageBox.Show("Record saved successfully", "MICS", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { //existing record, update territory and territory history st.TerritoryID = Int32.Parse(txtTerritoryID.Text); st.UpdateSalesTerritory(st); hist.ID = m_currentHistoryId; hist.SalesPersonID = Int32.Parse(cmbSalesPerson.SelectedValue.ToString()); hist.TerritoryID = st.TerritoryID; hist.StartDate = dtStartDate.Value; //hist.EndDate = dtEndDate.Value; hist.UpdateSalesTerritoryHistory(hist); //hist.AddSalesTerritoryHistory(hist); MessageBox.Show("Record saved successfully", "MICS", MessageBoxButtons.OK, MessageBoxIcon.Information); } RefreshForm(); } catch (Exception ex) { MessageBox.Show(ex.Message, "MICS", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { st = null; } }