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;
}
}
