public static RadioButton RdTypeCheckedChanged(object sender, EventArgs e)
{
RadioButton selectedrb = null;
var rb = sender as RadioButton;
try
{
if (rb == null)
{
return(null);
}
// Ensure that the RadioButton.Checked property
// changed to true.
if (rb.Checked)
{
// Keep track of the selected RadioButton by saving a reference
// to it.
selectedrb = rb;
}
}
catch (Exception ex)
{
MessageClass.ShowError(ex.Message, System.Reflection.MethodBase.GetCurrentMethod().ReflectedType.Name);
}
return(selectedrb);
}
public static bool CreateFile(String dataPath)
{
FileStream fs = null;
try
{
dataPath = dataPath.Replace((char)92, '/');
dataPath = dataPath.Replace((char)9, '/');
if (!File.Exists(dataPath))
{
string temp = Path.GetDirectoryName(dataPath);
if (temp != null && !Directory.Exists(temp))
{
Directory.CreateDirectory(temp);
}
fs = new FileStream(dataPath, FileMode.CreateNew);
fs.Close();
}
return(true);
}
catch (Exception ex)
{
MessageClass.ShowError(ex.Message, System.Reflection.MethodBase.GetCurrentMethod().ReflectedType.Name);
}
finally
{
if (fs != null)
{
fs.Close();
}
}
return(false);
}
public int Count(string strSQL)
{
var result = 0;
try
{
ConnectDb();
if (!_isConnected)
{
return(result);
}
var sqlCom = new MySqlCommand(strSQL, _conn);
MySqlDataReader reader = sqlCom.ExecuteReader();
if (reader.Read())
{
result = reader.GetInt32(0);
}
DisconnectDb();
}
catch (Exception ex)
{
MessageClass.HideError(ex.Message, System.Reflection.MethodBase.GetCurrentMethod().ReflectedType.Name);
}
return(result);
}
public static void AppendDataTable(DataTable dtSource, ref DataTable dtDestination)
{
try
{
if (dtSource == null || dtSource.Rows.Count < 1)
{
return;
}
if (dtDestination == null || dtDestination.Rows.Count < 1)
{
dtDestination = dtSource;
return;
}
foreach (DataRow dr in dtSource.Rows)
{
dtDestination.ImportRow(dr);
}
}
catch (Exception ex)
{
MessageClass.ShowError(ex.Message, System.Reflection.MethodBase.GetCurrentMethod().ReflectedType.Name);
return;
}
}
public Boolean Update(string strSQL)
{
Boolean result = true;
try
{
ConnectDb();
if (!_isConnected)
{
return(false);
}
var sqlCom = new MySqlCommand(strSQL, _conn);
sqlCom.ExecuteNonQuery();
sqlCom.Dispose();
DisconnectDb();
}
catch (MySqlException ex)
{
if (ex.ErrorCode != -2147467259)
{
MessageClass.HideError(ex.Message, System.Reflection.MethodBase.GetCurrentMethod().ReflectedType.Name);
}
result = false;
}
return(result);
}
public MySqlConnection ConnectDb()
{
try
{
if (_isConnected == false)
{
try
{
if (_mConnString.Length <= 0)
{
_isConnected = false;
return(null);
}
_conn = new MySqlConnection(_mConnString);
_conn.Open();
}
catch (MySqlException ex)
{
_isConnected = false;
MessageClass.HideError(ex.Message + "MySqlException", System.Reflection.MethodBase.GetCurrentMethod().ReflectedType.Name);
return(null);
}
_isConnected = true;
}
return(_conn);
}
catch (Exception ex)
{
MessageClass.HideError(ex.Message, System.Reflection.MethodBase.GetCurrentMethod().ReflectedType.Name);
return(null);
}
}
public String SingleResult(string strSQL)
{
String result = String.Empty;
try
{
ConnectDb();
if (!_isConnected)
{
return(result);
}
var sqlCom = new MySqlCommand(strSQL, _conn);
MySqlDataReader sqlRead = sqlCom.ExecuteReader();
if (sqlRead.Read())
{
result = sqlRead[0].ToString();
}
sqlCom.Dispose();
DisconnectDb();
}
catch (Exception ex)
{
MessageClass.HideError(ex.Message, System.Reflection.MethodBase.GetCurrentMethod().ReflectedType.Name);
}
return(result);
}
public static DataTable LoadAll()
{
DataTable dt = null;
try
{
dt = new DataTable();
var dc = new DataColumn
{
DataType = System.Type.GetType("System.String"),
ColumnName = Status,
ReadOnly = true,
Unique = true
};
dt.Columns.Add(dc);
DataRow dr = dt.NewRow();
dr[0] = Active;
dt.Rows.Add(dr);
dr = dt.NewRow();
dr[0] = Cancel;
dt.Rows.Add(dr);
}
catch (Exception ex)
{
MessageClass.ShowError(ex.Message, System.Reflection.MethodBase.GetCurrentMethod().ReflectedType.Name);
}
return(dt);
}
public static void DelConfig()
{
try
{
File.Delete(Application.ExecutablePath + ".config");
}
catch (Exception ex) { MessageClass.ShowError(ex.Message, System.Reflection.MethodBase.GetCurrentMethod().ReflectedType.Name); }
}
public Boolean ExecuteNonQuery(string strSQL, MySqlParameter[] oSqlParameter)
{
const bool isSusscess = false;
try
{
ConnectDb();
if (!_isConnected)
{
return(isSusscess);
}
var sqlCom = new MySqlCommand();
MySqlTransaction trans = _conn.BeginTransaction(System.Data.IsolationLevel.ReadCommitted);
sqlCom.Connection = _conn;
sqlCom.CommandTimeout = 0;
sqlCom.Transaction = trans;
try
{
sqlCom.CommandText = strSQL;
if (oSqlParameter != null)
{
sqlCom.Prepare();
foreach (MySqlParameter prm in oSqlParameter)
{
sqlCom.Parameters.Add(prm);
}
}
sqlCom.ExecuteNonQuery();
trans.Commit();
}
catch (Exception ex)
{
trans.Rollback();
MessageClass.HideError(ex.Message, System.Reflection.MethodBase.GetCurrentMethod().ReflectedType.Name);
}
}
catch (Exception ex)
{
MessageClass.HideError(ex.Message, System.Reflection.MethodBase.GetCurrentMethod().ReflectedType.Name);
}
finally
{
DisconnectDb();
}
if (oSqlParameter != null)
{
strSQL = oSqlParameter.Aggregate(strSQL, (current, prm) => current + (":" + prm.Value.ToString()));
}
return(isSusscess);
}
public static bool IsText(String strValue)
{
try
{
var rgx = new Regex("[^0-9]");
return(!rgx.IsMatch(strValue.Trim()));
}
catch (Exception ex)
{
MessageClass.ShowError(ex.Message, System.Reflection.MethodBase.GetCurrentMethod().ReflectedType.Name);
return(false);
}
}
public static bool IsNumeric(string strValue)
{
var results = false;
try
{
double dTmp = 0;
results = double.TryParse(strValue.Trim(), System.Globalization.NumberStyles.Any, null, out dTmp);
}
catch (Exception ex)
{
MessageClass.ShowError(ex.Message, System.Reflection.MethodBase.GetCurrentMethod().ReflectedType.Name);
}
return(results);
}
public static String Encrypt(String origValue)
{
String enryValue = String.Empty;
try
{
var enDes = new TripleDes();
enryValue = enDes.Encrypt(origValue);
}
catch (Exception ex)
{
MessageClass.ShowError(ex.Message, System.Reflection.MethodBase.GetCurrentMethod().ReflectedType.Name);
}
return(enryValue);
}
public static void LoadListBox(ListBox ddl, DataTable dt, string textField, string valueField)
{
try
{
ddl.DataSource = null;
ddl.Items.Clear();
ddl.DisplayMember = textField;
ddl.ValueMember = valueField;
ddl.DataSource = dt;
}
catch (Exception ex)
{
MessageClass.ShowError(ex.Message, System.Reflection.MethodBase.GetCurrentMethod().ReflectedType.Name);
}
}
public static void LoadDropDown(ComboBox ddl, DataTable dt, string textField, string valueField)
{
try
{
ddl.SuspendLayout();
ddl.Items.Clear();
ddl.DataSource = dt;
//new BindingSource(dt, "");
ddl.DisplayMember = textField;
ddl.ValueMember = valueField;
ddl.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
ddl.AutoCompleteSource = AutoCompleteSource.ListItems;
ddl.ResumeLayout();
}
catch (Exception ex)
{
MessageClass.ShowError(ex.Message, System.Reflection.MethodBase.GetCurrentMethod().ReflectedType.Name);
}
}
public static void AltLoadListBox(ListBox ddl, DataTable dt)
{
try
{
ddl.BeginUpdate();
for (var i = 0; i < dt.Rows.Count; i++)
{
if (dt.Rows[i][0].ToString().Length > 0)
{
ddl.Items.Add(dt.Rows[i][0].ToString());
}
}
ddl.EndUpdate();
}
catch (Exception ex)
{
MessageClass.ShowError(ex.Message, System.Reflection.MethodBase.GetCurrentMethod().ReflectedType.Name);
}
}
public static void CloseAllChild(Form[] mdiChildren)
{
try
{
using (new HourGlass())
{
foreach (Form childForm in mdiChildren)
{
childForm.Close();
childForm.Dispose();
}
GC.Collect();
}
}
catch (Exception ex)
{
MessageClass.ShowError(ex.Message, MethodBase.GetCurrentMethod().ReflectedType.Name);
}
}
public static void RemLastRow(DataGridView dgView, int lastSavedRow, int lastSavedIndex)
{
try
{
if (dgView.Rows.Count < 1)
{
return;
}
dgView.Focus();
dgView.ClearSelection();
dgView.Rows[lastSavedRow].Selected = true;
dgView.Rows[lastSavedRow].Cells[0].Selected = true;
dgView.FirstDisplayedScrollingRowIndex = lastSavedIndex;
}
catch (Exception ex)
{
MessageClass.HideError(ex.Message, System.Reflection.MethodBase.GetCurrentMethod().ReflectedType.Name);
}
}
public static bool IsDate(String strValue)
{
bool results = false;
try
{
if (strValue.Length < 12)
{
return(false);
}
DateTime dt;
results = DateTime.TryParse(strValue.Trim(), out dt);
}
catch (Exception ex)
{
MessageClass.ShowError(ex.Message, System.Reflection.MethodBase.GetCurrentMethod().ReflectedType.Name);
}
return(results);
}
private static void ClearControl(Control c)
{
try
{
if (c is TextBox && c.Enabled)
{
c.Text = String.Empty;
}
if (c is ComboBox && c.Enabled)
{
var t = (ComboBox)c;
t.SelectedIndex = 0;
}
}
catch (Exception ex)
{
MessageClass.ShowError(ex.Message, MethodBase.GetCurrentMethod().ReflectedType.Name);
}
}
private String GetPasswordwMd5(string pass)
{
try
{
var x = new MD5CryptoServiceProvider();
byte[] bs = System.Text.Encoding.UTF8.GetBytes(pass);
bs = x.ComputeHash(bs);
var s = new System.Text.StringBuilder();
foreach (byte b in bs)
{
s.Append(b.ToString("x2").ToLower());
}
return(s.ToString());
}
catch (Exception ex)
{
MessageClass.ShowError(ex.Message, System.Reflection.MethodBase.GetCurrentMethod().ReflectedType.Name);
return(String.Empty);
}
}
public static void CloseForm(Form frm, BackgroundWorker bgWrkr)
{
try
{
if (bgWrkr != null)
{
if (bgWrkr.IsBusy)
{
bgWrkr.CancelAsync();
}
}
frm.Close();
frm.Dispose();
GC.Collect();
}
catch (Exception ex)
{
MessageClass.ShowError(ex.Message, MethodBase.GetCurrentMethod().ReflectedType.Name);
}
}
public DataTable RetDataTable(string strSQL, CommandType oCommandType, MySqlParameter[] oSqlParameter)
{
DataTable dt = null;
try
{
ConnectDb();
if (!_isConnected)
{
return(null);
}
var da = new MySqlDataAdapter
{
SelectCommand = new MySqlCommand(strSQL, _conn)
{
CommandTimeout = 0, CommandType = oCommandType
}
};
if (oSqlParameter != null)
{
foreach (MySqlParameter prm in oSqlParameter)
{
da.SelectCommand.Parameters.Add(prm);
}
}
var dsResult = new DataTable();
da.Fill(dsResult);
dt = dsResult;
da.Dispose();
DisconnectDb();
}
catch (Exception ex)
{
MessageClass.HideError(ex.Message, System.Reflection.MethodBase.GetCurrentMethod().ReflectedType.Name);
}
return(dt);
}
public static String GetCurrentRow(DataGridView dgView, int intCellNo)
{
var id = String.Empty;
try
{
var selectedRowCount = dgView.Rows.GetRowCount(DataGridViewElementStates.Selected);
if (selectedRowCount > 0)
{
if (dgView.SelectedRows.Count > 0)
{
if (dgView.SelectedRows.Count > 1)
{
var currentRow = dgView.SelectedRows[0];
id = currentRow.Cells[intCellNo].Value.ToString();
}
else
{
var i = dgView.SelectedCells[0].RowIndex;
if (dgView.Rows[i].Cells[intCellNo].Value != null)
{
id = dgView.Rows[i].Cells[intCellNo].Value.ToString();
}
}
}
if (id.Length <= 0)
{
return(string.Empty);
}
}
}
catch (Exception ex)
{
MessageClass.ShowError(ex.Message, System.Reflection.MethodBase.GetCurrentMethod().ReflectedType.Name);
}
return(id);
}
public static void LoadListView(ListView lst, DataTable dt)
{
try
{
lst.Items.Clear();
lst.BeginUpdate();
for (int i = 0; i < dt.Rows.Count; i++)
{
DataRow dr = dt.Rows[i];
var itm = new ListViewItem(dr[0].ToString());
for (int n = 1; n < dt.Columns.Count; n++)
{
itm.SubItems.Add(dr[n].ToString());
}
lst.Items.Add(itm);
}
lst.EndUpdate();
}
catch (Exception ex)
{
MessageClass.ShowError(ex.Message, System.Reflection.MethodBase.GetCurrentMethod().ReflectedType.Name);
}
}
public static void LoadDropDownWBlank(ComboBox ddl, DataTable dt)
{
try
{
ddl.SuspendLayout();
ddl.Items.Clear();
ddl.BeginUpdate();
ddl.Items.Add("");
for (int i = 0; i < dt.Rows.Count; i++)
{
ddl.Items.Add(dt.Rows[i][0].ToString());
}
ddl.EndUpdate();
ddl.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
ddl.AutoCompleteSource = AutoCompleteSource.ListItems;
ddl.DropDownStyle = ComboBoxStyle.DropDown;
ddl.ResumeLayout();
}
catch (Exception ex)
{
MessageClass.ShowError(ex.Message, System.Reflection.MethodBase.GetCurrentMethod().ReflectedType.Name);
}
}
public static bool WriteToFile(String strfullFilepath, bool append, String data)
{
bool result = true;
StreamWriter fs = null;
try
{
fs = append ? new StreamWriter(strfullFilepath, true) : new StreamWriter(strfullFilepath);
fs.WriteLine(data);
}
catch (Exception ex)
{
MessageClass.ShowError(ex.Message, System.Reflection.MethodBase.GetCurrentMethod().ReflectedType.Name);
result = false;
}
finally
{
if (fs != null)
{
fs.Close();
}
}
return(result);
}
public static void SelectLastRow(DataGridView dgView)
{
try
{
if (dgView.Rows.Count < 1)
{
return;
}
dgView.Focus();
dgView.ClearSelection();
var newSelIndex = dgView.Rows.Count - 1;
dgView.Rows[newSelIndex].Selected = true;
dgView.Rows[newSelIndex].Cells[0].Selected = true;
if (dgView.FirstDisplayedScrollingRowIndex + dgView.DisplayedRowCount(false) <= newSelIndex)
{
dgView.FirstDisplayedScrollingRowIndex =
newSelIndex - dgView.DisplayedRowCount(false) + 1;
}
}
catch (Exception ex)
{
MessageClass.HideError(ex.Message, System.Reflection.MethodBase.GetCurrentMethod().ReflectedType.Name);
}
}
public static void LoadSubfrm(Form newMdiChild, Form parentForm, bool isResize)
{
try
{
using (new HourGlass())
{
GC.Collect();
newMdiChild.Font = Gobal.Myfont;
if (isResize)
{
newMdiChild.WindowState = FormWindowState.Maximized;
newMdiChild.MinimumSize = new Size(Screen.PrimaryScreen.WorkingArea.Width - 2,
Screen.PrimaryScreen.WorkingArea.Height - 20);
newMdiChild.MdiParent = parentForm;
}
else
{
newMdiChild.StartPosition = FormStartPosition.CenterParent;
}
}
if (isResize)
{
newMdiChild.Show();
}
else
{
newMdiChild.ShowDialog();
}
}
catch (Exception ex)
{
MessageClass.ShowError(ex.Message, MethodBase.GetCurrentMethod().ReflectedType.Name);
}
}
public MySqlDataReader Query(string strSQL)
{
MySqlDataReader sqlRead = null;
try
{
ConnectDb();
if (!_isConnected)
{
return(null);
}
var sqlCom = new MySqlCommand(strSQL, _conn);
sqlRead = sqlCom.ExecuteReader();
sqlCom.Dispose();
DisconnectDb();
}
catch (Exception ex)
{
MessageClass.HideError(ex.Message, System.Reflection.MethodBase.GetCurrentMethod().ReflectedType.Name);
}
return(sqlRead);
}