private void CmdSave_Click(object sender, EventArgs e) { try { if (txtName.Text.Trim() == string.Empty) { MessageBox.Show("Please Enter Sector Name", "Sector Name"); txtName.Focus(); return; } int vTown; int.TryParse(CmbTown.SelectedValue.ToString(), out vTown); // int.TryParse(CmbFilter.SelectedValue.ToString(), out vFilter); Objects.Sectors obj = new Objects.Sectors(); // obj.SectorOrder = txtOrd obj.SectorName = txtName.Text.Trim(); // obj.TownID = vFilter; if (vTown > 0) { obj.TownID = vTown; } if (!vOpenMode) { obj.SectorID = Int32.Parse(objDAL.getNextNo().ToString()); objDAL.InsertRecord(obj); } else { // UPdate obj.SectorID = Int16.Parse(txtName.Tag.ToString()); objDAL.UpdateRecord(obj); } MessageBox.Show("Record Saved Succesfully", "Save"); CmdClear_Click(sender, e); LoadGrid(CmbTown.SelectedValue.ToString()); } catch (Exception exc) { MessageBox.Show(exc.Message); } }
public void UpdateRecord(Objects.Sectors obj) { try { SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "SP_SectorsUpdate"; cmd.Parameters.AddWithValue("@SectorID", obj.SectorID); cmd.Parameters.AddWithValue("@TownID", obj.TownID); cmd.Parameters.AddWithValue("@SectorName", obj.SectorName); cmd.Parameters.AddWithValue("@SectorOrder", obj.SectorOrder); new Database(connectionstring).ExecuteNonQueryOnly(cmd); } catch (Exception exc) { throw exc; } }