private void btnCreateSaveProcedure_Click(object sender, RoutedEventArgs e) { try { if (ddlTables.SelectedValue != null && ddlTables.SelectedValue.ToString().Equals("ALL")) { if (MessageBox.Show("Do you want to Create Save Procedure for All tables?", _strMessageBoxCaption, MessageBoxButton.YesNo) == MessageBoxResult.Yes) { foreach (DataRow row in _dtTables.Rows) { _strTableName = row["TABLE_NAME"].ToString(); DataTable dt = GetColumnsDesc(); StringBuilder sb = _iDbBuilder.BuildSaveProcedure(_strTableName, dt); string filePath = _strFileSavedDirectory + "usp" + _strTableName + "Save.sql"; if (!string.IsNullOrEmpty(sb.ToString())) { Util.Utility.WriteToDisk(filePath, sb.ToString()); } else { MessageBox.Show("OOPs!! There's nothing to create...", _strMessageBoxCaption, MessageBoxButton.OK); } } } } else if (ddlTables.SelectedValue != null && !string.IsNullOrEmpty(ddlTables.SelectedValue.ToString())) { _strTableName = ddlTables.SelectedValue.ToString(); DataTable dt = GetColumnsDesc(); StringBuilder sb = _iDbBuilder.BuildSaveProcedure(_strTableName, dt); string filePath = _strFileSavedDirectory + "usp" + _strTableName + "Save.sql"; if (!string.IsNullOrEmpty(sb.ToString())) { Util.Utility.WriteToDisk(filePath, sb.ToString()); } else { MessageBox.Show("OOPs!! There's nothing to create...", _strMessageBoxCaption, MessageBoxButton.OK); } } } catch (Exception ex) { MessageBox.Show(ex.Message, _strMessageBoxCaption, MessageBoxButton.OK, MessageBoxImage.Error); } }