/// <summary> /// This method updates documents in the collection using linq extended operators /// </summary> /// <param name="product1"> Product that will be modified during the operation </param> private void UpdateUsingExtendedLinq(Product product1) { // Update the UnitsInStock, UnitPrice for the products with category "Milk Products" DBUpdateBuilder update = DBUpdate.Set("UnitsInStock", 3).Set("UnitPrice", 420); // Update documents in the Products collection: long rowsAffected = _prodUpdatable.Update(update, x => x.ID == product1.ID, WriteConcern.InMemory); Console.WriteLine(string.Format("{0} documents updated in '{1}' collection", rowsAffected, _productsCollection.Name)); }
public CustomerDataTable() { cus = new Customer(); util = new Utility(log); log = new LogWrite(new LogOpen()); dbString = new DBConnectionString(log); dbConnect = new DBConnect(dbString, log); dbFill = new DBFill(dbConnect, log); dbDelete = new DBDelete(dbConnect, log); dbInsert = new DBInsert(dbConnect, log); dbUpdate = new DBUpdate(dbConnect, log); dbFilter = new DBFilter(dbConnect, log); }
public IActionResult UpdateDB() { try { var task = DBUpdate.Begin(_configuration); return(Ok()); } catch (Exception ex) { _logger.LogCritical("Exception on UpdateDB.", ex); return(StatusCode(500)); } }
public Project(int t_Id, string t_ProjectName, string t_ProjectDescription, Nullable <DateTime> t_ApprovalDate, Priority t_Priority, State t_ProjectState, DateTime t_PlannedStartdate, DateTime t_PlannedEnddate, Nullable <DateTime> t_Startdate, Nullable <DateTime> t_Enddate, int t_ProjectProgress, string t_ProjectDocumentsLink, int t_ProjectMethodId, int t_EmployeeId) { Id = t_Id; ProjectName = t_ProjectName; ProjectDescription = t_ProjectDescription; ApprovalDate = t_ApprovalDate; Priority = t_Priority; ProjectState = t_ProjectState; PlannedStartdate = t_PlannedStartdate; PlannedEnddate = t_PlannedEnddate; Startdate = t_Startdate; Enddate = t_Enddate; ProjectProgress = t_ProjectProgress; ProjectDocumentsLink = t_ProjectDocumentsLink; ProjectMethodId = t_ProjectMethodId; EmployeeId = t_EmployeeId; _dbUpdateObj = new DBUpdate(); }
// Projektphasen definieren public void Define(Nullable <DateTime> t_plannedstartdate, Nullable <DateTime> t_plannedenddate, Nullable <DateTime> t_plannedreviewdate, string t_phasedocumentslink, string t_phasename) { DBUpdate dbUpdateObj = new DBUpdate(); dbUpdateObj.DefineProjectPhase(Id, t_plannedstartdate, t_plannedenddate, t_plannedreviewdate, t_phasedocumentslink); // Prüfen, ob schon ein Meilenstein existiert DBGet dbGetObj = new DBGet(); var checkMilestone = dbGetObj.GeneralGet("Milestone", Id); // Existiert noch kein Meilenstein, wird eine Meilenstein am geplanten Phasenende definiert if (checkMilestone.Count == 0) { if (t_plannedenddate != null) { string milestoneName = t_phasename + " Ende"; DBCreate dbCreateObj = new DBCreate(); dbCreateObj.MilestoneCreate(milestoneName, t_plannedenddate, Id); } } }
// Effektive Kosten setzen public void SetCost(Nullable <int> t_EffectiveCost, string t_Deviation) { DBUpdate dbUpdateObj = new DBUpdate(); dbUpdateObj.SetExternalCost(Id, t_EffectiveCost, t_Deviation); }
// Aktivitätstatus setzen public void SetState(int t_ActivityProgress) { DBUpdate dbUpdateObj = new DBUpdate(); dbUpdateObj.SetActivityState(Id, t_ActivityProgress); }
// Aktivitätdatum setzen public void SetDates(Nullable <DateTime> t_Startdate, Nullable <DateTime> t_Enddate) { DBUpdate dbUpdateObj = new DBUpdate(); dbUpdateObj.SetActivityDates(Id, t_Startdate, t_Enddate); }
// Effektive Zeit setzen public void SetTime(Nullable <int> t_EffectiveTime, string t_Deviation) { DBUpdate dbUpdateObj = new DBUpdate(); dbUpdateObj.SetEmployeeResource(Id, t_EffectiveTime, t_Deviation); }
// ProjektPhase freigeben public void Release(Nullable <DateTime> t_approvaldate, string t_visum, State t_projectphasestate) { DBUpdate dbUpdateObj = new DBUpdate(); dbUpdateObj.SetPhaseApprovalDate(Id, t_approvaldate, t_visum, t_projectphasestate); }
// ProjektPhase Status setzen public void SetState(int t_progress, State t_phasestate) { DBUpdate dbUpdateObj = new DBUpdate(); dbUpdateObj.SetPhaseState(Id, t_progress, t_phasestate); }
// ProjektPhase Datum setzen public void SetDates(Nullable <DateTime> t_StartDate, Nullable <DateTime> t_EndDate, Nullable <DateTime> t_ReviewDate) { DBUpdate dbUpdateObj = new DBUpdate(); dbUpdateObj.SetPhaseDates(Id, t_StartDate, t_EndDate, t_ReviewDate); }
public static bool TestServer(out string ErrorReason, bool SkipSomeSanityChecks = false) { ErrorReason = ""; SQLLib sql = null; try { if (Settings.Default.DBType.ToLower() == "mssql") { if (Settings.Default.DBServer == "" || Settings.Default.DBDB == "") { ErrorReason = "Servername / DB missing"; return(false); } sql = new SQLLib(); sql.SqlCommandTimeout = 0; //waiting .... :-) sql.ApplicationName = "Fox SDC Server [test/update connection]"; sql.ConnectionPooling = false; sql.SEHError = true; if (sql.ConnectDatabase(Settings.Default.DBServer, Settings.Default.DBDB, true) == false) { ErrorReason = "Cannot connect to the SQL Server"; return(false); } } if (Settings.Default.DBType.ToLower() == "localdb") { if (Settings.Default.DBLocalPath == "") { ErrorReason = "LocalDB path missing"; return(false); } sql = new SQLLib(); sql.SqlCommandTimeout = 0; //waiting .... :-) sql.ApplicationName = "Fox SDC Server [test/update connection]"; sql.ConnectionPooling = false; sql.SEHError = true; if (sql.ConnectLocalDatabase(Settings.Default.DBLocalPath) == false) { ErrorReason = "Cannot connect to the SQL Server"; return(false); } } } catch (Exception ee) { ErrorReason = "Cannot connect to the SQL Server [SEH]\n" + ee.ToString(); Debug.WriteLine(ee.ToString()); return(false); } if (sql == null) { ErrorReason = "sql==null //is the SQL Profile properly defined in registry?\n"; return(false); } string ServerVersion = Convert.ToString(sql.ExecSQLScalar("SELECT SERVERPROPERTY('productversion')")); string ServerVPart = ServerVersion.Split('.')[0].Trim(); int ServerVPartI = 0; if (int.TryParse(ServerVPart, out ServerVPartI) == false) { sql.CloseConnection(); ErrorReason = "Cannot read SQL Version"; return(false); } if (ServerVPartI < 11) { sql.CloseConnection(); ErrorReason = "Unsupported SQL Version - Minimum V.11 (SQL 2012)"; } try { sql.ExecSQL("SELECT * FROM Config"); } catch { sql.CloseConnection(); ErrorReason = "Cannot SELECT Table CONFIG."; return(false); } try { if (Convert.ToString(sql.ExecSQLScalar("SELECT Value FROM Config WHERE [Key]='ID'")) != "FOXSDCv1") { sql.CloseConnection(); ErrorReason = "Invalid ID in Config Table"; return(false); } } catch { sql.CloseConnection(); ErrorReason = "Cannot SELECT Table CONFIG. (ID)"; return(false); } while (DBUpdate.UpdateDB(sql) == false) { ; } sql.SEHError = true; try { if (Convert.ToInt32(sql.ExecSQLScalar("SELECT Value FROM Config WHERE [Key]='Version'")) != Program.DBVersion) { sql.CloseConnection(); ErrorReason = "Invalid Version in Config Table"; return(false); } } catch { sql.CloseConnection(); ErrorReason = "Cannot SELECT Table CONFIG. (Version)"; return(false); } if (Convert.ToInt32(sql.ExecSQLScalar("SELECT COUNT(*) FROM Users WHERE Username='******'")) == 0) { FoxEventLog.WriteEventLog("Creating user ROOT", EventLogEntryType.Warning); sql.InsertMultiData("Users", new SQLData("Username", "root"), new SQLData("Name", "Root User"), new SQLData("Password", DefaultPasswordHash), new SQLData("Permissions", AllPermissions), new SQLData("MustChangePassword", 1)); } if (Convert.ToInt32(sql.ExecSQLScalar("SELECT COUNT(*) FROM Users WHERE Username='******' AND Permissions=@p", new SQLParam("@p", AllPermissions))) == 0) { FoxEventLog.WriteEventLog("Fixing user ROOT", EventLogEntryType.Warning); sql.ExecSQL("UPDATE Users SET Permissions=@p WHERE Username='******'", new SQLParam("@p", AllPermissions)); } try { Guid g; if (Guid.TryParse(Convert.ToString(sql.ExecSQLScalar("SELECT Value FROM Config WHERE [Key]='GUID'")), out g) == false) { FoxEventLog.WriteEventLog("Creating GUID", EventLogEntryType.Warning); sql.ExecSQL("DELETE FROM Config WHERE [Key]='GUID'"); sql.ExecSQL("INSERT INTO Config VALUES ('GUID', @g)", new SQLParam("@g", Guid.NewGuid().ToString())); } } catch (Exception ee) { Debug.WriteLine(ee.ToString()); ErrorReason = "Cannot verify GUID"; return(false); } SettingsManager.LoadSettings(sql); //try //{ // string ret = Convert.ToString(sql.ExecSQLScalar("select dbo.FoxCreateSerial(1, 1)")); //} //catch (Exception ee) //{ // Debug.WriteLine(ee.ToString()); // ErrorReason = "Cannot execute FUNCTIONs in SQL"; // return (false); //} sql.CloseConnection(); ErrorReason = ""; return(true); }