public string DataTrigger_Delete(Iinterface Entity) { try { // Get Command object with Stored procedure ObjCmd = Entity.Delete(); // to Command object for a pending local transaction ObjCmd.Connection = Conn; ObjCmd.Transaction = DbTrans; ObjCmd.ExecuteNonQuery(); strmsg = "False"; } catch (Exception e) { OperationError = (e.Message) + "Sorry, Record can not be deleted."; strmsg = "True"; return(strmsg); } return(strmsg); }
public DataView DataTrigger_Get_All(Iinterface Entity) { Conn = Objconn.Odbc_SQL_Connection; ObjCmd = Entity.Get_All(); ObjCmd.Connection = Conn; MySqlDataAdapter da = new MySqlDataAdapter(ObjCmd); DataSet DS = new DataSet(); da.Fill(DS); ObjCmd.Connection.Close(); ObjCmd.Connection.Dispose(); ObjCmd.Connection = null; DataView DV = new DataView(DS.Tables[0]); DS.Dispose(); DS = null; //null da = null; //null Objconn.Dispose(); //null Conn.Close(); //null Conn.Dispose(); //null Conn = null; //null ObjCmd = null; //null return(DV); }
public string DataTrigger_Get_Max(Iinterface Entity) { try { // Get Database connection ObjCmd = Entity.Get_Max(); ObjCmd.Connection = DbTrans.Connection; ObjCmd.Transaction = DbTrans; // Dataadapter MySqlDataAdapter da = new MySqlDataAdapter(ObjCmd); // fill dataset DataSet DS = new DataSet(); da.Fill(DS); //ObjCmd.Connection.Close(); return(DS.Tables[0].Rows[0]["MaxID"].ToString()); } catch (Exception e) { OperationError = (e.Message) + "Sorry, Maximum Primary Key can not be extracted."; strmsg = "True"; } return(strmsg); }
public static void PrintListOfFiles(this DirectoryInfo dir, Iinterface ui) { var files = dir.GetFiles(); foreach (var file in files) { ui.Write("File name: " + file.Name + "\tCreation time: " + file.CreationTime.ToString() + "\n"); } }
public static void Run() { Bderived b = new Bderived(); ABase a = b; Iinterface i = b; a.hello(); b.hello(); i.hello(); }
public static void PrintMasivZ(MasivZ arr, Iinterface ui) { foreach (var symb in arr.Symbols) { ui.Write(symb + " "); } ui.Write("\n"); foreach (var code in arr.Codes) { ui.Write(code + " "); } ui.Write("\n"); }
public DataView Transaction_Get_Single(Iinterface Entity) { ObjCmd = Entity.Get_Single(); //ObjCmd.Connection = Conn; ObjCmd.Connection = DbTrans.Connection; ObjCmd.Transaction = DbTrans; // Dataadapter MySqlDataAdapter da = new MySqlDataAdapter(ObjCmd); // fill dataset DataSet DS = new DataSet(); da.Fill(DS); // Create the DataView Object DataView DV = new DataView(DS.Tables[0]); return(DV); }
// public DataView Transaction_Get_All(Iinterface Entity) // { // ObjCmd = Entity.Get_All(); // ObjCmd.Transaction = DbTrans; // ObjCmd.Connection = Conn; // // // Dataadapter // OdbcDataAdapter da = new OdbcDataAdapter(ObjCmd); // // fill dataset // DataSet DS = new DataSet(); // da.Fill(DS); // // // Create the DataView Object // DataView DV = new DataView(DS.Tables[0]); // // return DV; // } public DataView DataTrigger_Get_Single(Iinterface Entity) { // Get Database connection Conn = Objconn.Odbc_SQL_Connection; ObjCmd = Entity.Get_Single(); ObjCmd.Connection = Conn; // Dataadapter MySqlDataAdapter da = new MySqlDataAdapter(ObjCmd); // fill dataset DataSet DS = new DataSet(); da.Fill(DS); ObjCmd.Connection.Close(); ObjCmd.Connection.Dispose(); ObjCmd.Connection = null; // Create the DataView Object DataView DV = new DataView(DS.Tables[0]); return(DV); }
/*public string DataTrigger_Delete(Iinterface Entity) * { * // Get Command object with Stored procedure * ObjCmd = Entity.Delete(); * // to Command object for a pending local transaction * ObjCmd.Transaction = DbTrans; * * try * { * ObjCmd.Connection = Conn; * ObjCmd.ExecuteNonQuery(); * } * catch(Exception e) * { * OperationError = (e.Message) + "Sorry, Record can not be deleted."; * strmsg="True"; * } * * return strmsg ; * }*/ public string DataTrigger_Update(Iinterface Entity) { // Get Command object with Stored procedure ObjCmd = Entity.Update(); // to Command object for a pending local transaction ObjCmd.Connection = DbTrans.Connection; ObjCmd.Transaction = DbTrans; try { ObjCmd.ExecuteNonQuery(); } catch (Exception e) { // Rollback transaction //DbTrans.Rollback(); OperationError = (e.Message) + "Sorry, Record can not be updated."; strmsg = "True"; } return(strmsg); }
public ArrayPrinter(Iinterface ui) { UserInterface = ui; }
public DependencyLogic(Iinterface inter) { this._inter = inter; _inter.Execute(); }
Iinterface c; //I removed the default new since it will get assigned in constructor public AnotherClass(Iinterface obj) { c = obj; }
public StringsTasksRunner(Iinterface ui) { UserInterface = ui; }
public ArraysTasksRunner(Iinterface ui) { UserInterface = ui; }
public PrimitiveTaskRunner(Iinterface ui) { UserInterface = ui; }
public FilesTasksRunner(Iinterface ui) { UserInterface = ui; }