protected void btnSave_Click(object sender, EventArgs e)
 {
     try
     {
         DepartmentTableAdapters.DepartmentSelectCommandTableAdapter dep_Adapter = new DepartmentTableAdapters.DepartmentSelectCommandTableAdapter();
         DataTable dt = dep_Adapter.GetDepartmentByShortName(txtCompanyShortName.Text, loggedInUserCoId);
         if (dt.Rows.Count == 0)
         {
             int coId = 0;
             if (loggedInUserRole == WebConstants.Roles.Admin)
             {
                 coId = int.Parse(ddlCompany.SelectedValue);
             }
             else
             {
                 coId = loggedInUserCoId;
             }
             dep_Adapter.InsertDepartment(coId, false, txtCompanyShortName.Text, txtCompanyLongName.Text, txtContactTitle.Text, txtContactInitial.Text.Trim(), txtForename.Text.Trim(), txtSurname.Text.Trim(), txtAddressNo.Text.Trim(), txtAddress1.Text.Trim(), txtAddress2.Text.Trim(), txtAddress3.Text.Trim(), txtAddress4.Text.Trim(), txtAddress5.Text.Trim(), txtPostalCode.Text.Trim(),GetFullAddress(), txtTele.Text.Trim(), txtTele1.Text.Trim(), txtFax.Text.Trim(), txtEmail.Text.Trim(), txtCoNotes.Text.Trim(), loggedInUserId, DateTime.Now, loggedInUserId, DateTime.Now);
             Response.Redirect("DepartmentList.aspx");
         }
         else
         {
             SetErrorMessage(WebConstants.Messages.Error.ALREAD_EXISTS);
         }
     }
     catch
     {
         SetErrorMessage(WebConstants.Messages.Error.CONNECTION_ERROR);
     }
 }