private static bool CheckData(Transport obj, string newDB) { string q = "USE " + newDB + "; "; q += "SELECT * FROM " + TRANSPORT.TRANSPORT_TBL + " WHERE " + TRANSPORT.TRANSPORT_NAME + " = '" + obj.Transport_name + "'; "; using (IDataReader redr = new DAL().Listreader(q)) { while (redr.Read() == true) { obj.Transport_id = redr[TRANSPORT.TRANSPORT_ID].ToString(); obj.Transport_name = ChangeCase.UpperFirst(obj.Transport_name); CTransport.Update(obj, new DAL()); return(true); } return(false); } }
private void Save_Event() { if (Validation() != false) { switch (fAction) { case BtnEvent.Open: this.Hide(); Form_NeedToRefresh(); break; case BtnEvent.New: try { var vData = CollectData(); dalsession = new DAL(); dalsession.BeginTransaction(); CTransport.Insert(vData, dalsession); dalsession.Commit(); MessageBox.Show(this.FindForm(), "Record Saved Successfully.", "Save...", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); this.Hide(); Form_NeedToRefresh(); } catch (Exception ex) { if (dalsession != null) { dalsession.Rollback(); } MessageBox.Show(this.FindForm(), "Something Goes Wrong \r\n" + ex.Message, "Could Not Save...", MessageBoxButtons.OK, MessageBoxIcon.Error); SetFocus(); return; } break; case BtnEvent.Edit: try { var vData = CollectData(); dalsession = new DAL(); dalsession.BeginTransaction(); CTransport.Update(vData, dalsession); dalsession.Commit(); MessageBox.Show(this.FindForm(), "Record Updated Successfully.", "Update...", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); this.Hide(); Form_NeedToRefresh(); } catch (Exception ex) { if (dalsession != null) { dalsession.Rollback(); } MessageBox.Show(this.FindForm(), "Something Goes Wrong \r\n" + ex.Message, "Could Not Update...", MessageBoxButtons.OK, MessageBoxIcon.Error); SetFocus(); return; } break; case BtnEvent.Delete: try { dalsession = new DAL(); dalsession.BeginTransaction(); CTransport.Delete(vId, dalsession); dalsession.Commit(); MessageBox.Show(this.FindForm(), "Record Deleted Successfully.", "Delete...", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); this.Hide(); Form_NeedToRefresh(); } catch (Exception ex) { if (dalsession != null) { dalsession.Rollback(); } MessageBox.Show(this.FindForm(), "Something Goes Wrong \r\n" + ex.Message, "Could Not Update...", MessageBoxButtons.OK, MessageBoxIcon.Error); SetFocus(); return; } break; case BtnEvent.Print: this.Hide(); Form_NeedToRefresh(); break; } } }