private void CloseAllOpenConnections(LinqDataContext ctx) { ctx.Log = new StringWriter(); if (ctx.DatabaseExists()) { //drop all connections by disabling multi-user (and immediatly abort all current transactions) ctx.ExecuteCommand("ALTER DATABASE " + _databaseName + " SET SINGLE_USER WITH ROLLBACK IMMEDIATE"); //re-enable multi-user ctx.ExecuteCommand("ALTER DATABASE " + _databaseName + " SET MULTI_USER"); } }
private void DeleteExsistingOrder() { using (var ctx = new System.Data.Linq.DataContext(Central.SpecialConnStr)) { ctx.ExecuteCommand("delete from objects where id={0}", _bar.Id); } }
static CreateTable() { var context = new System.Data.Linq.DataContext(Conexion.Connection); // Crear Tabla Por la Aplicacion. // CREATE TABLE[TAcciones] context.ExecuteCommand("CREATE TABLE[TAcciones] ([idAcciones] INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,[fkCliente] INTEGER NOT NULL,[fkTipoAccion] INTEGER NOT NULL,[FechaAccion] DATE DEFAULT CURRENT_DATE NULL,[FechaRecordar] DATE DEFAULT CURRENT_DATE NULL,[Comentario] TEXT NULL);"); // CREATE TABLE[TCliente] context.ExecuteCommand("CREATE TABLE [TCliente] ([idCliente] INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,[Nombre] varCHAR(30) NOT NULL,[Apellido] VARCHAR(30) NOT NULL,[Cedula] VARCHAR(30) UNIQUE NULL,[fkDireccion] INTEGER NULL,[Telefono] varchar(30) NULL,[Email] varCHAR(30) NULL,[Estatu] INTEGER NULL);"); // CREATE TABLE[TDireccion] context.ExecuteCommand("CREATE TABLE[TDireccion] ([idDireccion] INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,[pais] varCHAR(30) NOT NULL,[Ciudad] VARCHAR(30) NOT NULL,[Municipio] vaRCHAR(30) NULL,[Barrio] vaRCHAR(30) NULL,[Calle] varCHAR(15) NULL,[numCasa] INTEGER(4) NULL,[Detalles] varchar(9) NULL); "); // CREATE TABLE[TTipoAccion] context.ExecuteCommand("CREATE TABLE[TTipoAccion] ([idTipoAccion] INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,[Descripcion] VARCHAR(60) NOT NULL); "); // CREATE TABLE[TUsuario] context.ExecuteCommand("CREATE TABLE[TUsuario] ([idUsuario] INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,[Usuario] VARCHAR(30) UNIQUE NOT NULL,[Clave] VARCHAR(30) NOT NULL,[fkUsuario] INTEGER Null); "); }
public void DeleteAll() { System.Configuration.ConnectionStringSettingsCollection connectionStrings = WebConfigurationManager.ConnectionStrings as ConnectionStringSettingsCollection; if (connectionStrings.Count > 0) { System.Data.Linq.DataContext db = new System.Data.Linq.DataContext(connectionStrings["ConnectionString"].ConnectionString); db.ExecuteCommand("TRUNCATE TABLE Employees"); } }
private void button1_Click(object sender, EventArgs e) { Dates = dtpFrom.Value; Motivo = textBox1.Text; using (var ctx = new System.Data.Linq.DataContext(Central.ConnStr)) { ctx.ExecuteCommand("update comenzi set DateControlled={0}, Motivo={1} where Id={2}", Dates, Motivo, Id); } DialogResult = DialogResult.OK; Close(); }
/// <summary> /// Execute an SQL command directly to the database. /// </summary> /// <param name="dataContext">The data context to the database.</param> /// <param name="sqlCommand">The sql command to execute to the database.</param> /// <param name="values">The parameter values for the command, can be null.</param> /// <returns>A value indicating the result of the command.</returns> /// <exception cref="System.ArgumentNullException"></exception> public static Int32 ExecuteCommand(System.Data.Linq.DataContext dataContext, string sqlCommand, params object[] values) { // Check to see if the critical parameters // have been set, throw exception on each. if (sqlCommand == null) { throw new ArgumentNullException("sqlCommand"); } // Execute the command and return // the result from the command. return(dataContext.ExecuteCommand(sqlCommand, values)); }
public void DeleteAll() { using (PersonsDBEntities pb = conn.GetContext()) { System.Configuration.ConnectionStringSettingsCollection connectionStrings = WebConfigurationManager.ConnectionStrings as ConnectionStringSettingsCollection; if (connectionStrings.Count > 0) { System.Data.Linq.DataContext db = new System.Data.Linq.DataContext(connectionStrings["ConnectionString"].ConnectionString); db.ExecuteCommand("TRUNCATE TABLE Department"); } } }
private void PbCloseOrder_Click(object sender, EventArgs e) { if (Workflow.TargetClosedByUser) { var dr = MessageBox.Show("Are you sure you want to recover this order?", "Workflow controller", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dr == DialogResult.Yes) { using (var ctx = new System.Data.Linq.DataContext(Central.SpecialConnStr)) { ctx.ExecuteCommand("update objects set closedord='false' where ordername={0} and aim={1} and department={2}", Workflow.TargetOrder, Workflow.TargetLine, Workflow.TargetDepartment); } var c = new Central(); c.GetBase(); Close(); } } else { var dr = MessageBox.Show("Are you sure you want to close this order?", "Workflow controller", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dr == DialogResult.Yes) { using (var ctx = new System.Data.Linq.DataContext(Central.SpecialConnStr)) { ctx.ExecuteCommand("update objects set closedord='true' where ordername={0} and aim={1}", Workflow.TargetOrder, Workflow.TargetLine); } var c = new Central(); c.GetBase(); Close(); } } }
public int ExecuteCommand(string sql) { UserEngine.SessionTimeOut(); return(Standard.ExecuteCommand(sql)); }
private void SaveData() { var selectedDate = dtpCommData.Value; tableView1.Invalidate(); tableView1.EndEdit(); var groupForDelete = from prod in Tables.Productions where prod.Commessa == Workflow.TargetOrder && prod.Line == Workflow.TargetLine && prod.Department == Workflow.TargetDepartment select prod; var items = groupForDelete.ToList(); foreach (var item in items) { Tables.Productions.DeleteOnSubmit(item); } Config.GetGanttConn().SubmitChanges(); if (!string.IsNullOrEmpty(txtCommCapi.Text) && !string.IsNullOrEmpty(txtPersone.Text)) { bool wantToSave = true; if (!_deleting && selectedDate.DayOfWeek == DayOfWeek.Saturday || selectedDate.DayOfWeek == DayOfWeek.Sunday) { var diag = MessageBox.Show("Are you sure you want to add production for " + selectedDate.DayOfWeek.ToString() + "?", "Workflow controller", MessageBoxButtons.YesNo, MessageBoxIcon.Question); wantToSave = diag == DialogResult.Yes ? true : false; } if (!wantToSave) { return; } InsertNewRecord(); txtCommCapi.Text = ""; txtCommCapi.Focus(); } lblSavedInfo.Visible = true; lblSavedInfo.Location = new Point(Width / 2 - lblSavedInfo.Width / 2, lblSavedInfo.Location.Y); lblSavedInfo.BringToFront(); lblSavedInfo.Refresh(); foreach (DataRow dr in _dtComm.Rows) { int.TryParse(dr[9].ToString(), out var dQ); double.TryParse(dr[10].ToString(), out var price); bool.TryParse(dr[11].ToString(), out var incHours); int.TryParse(dr[12].ToString(), out var abatim); double.TryParse(dr[13].ToString(), out var qtyH); var shift = dr[14].ToString(); double.TryParse(dr[15].ToString(), out var settingHours); var pd = new Production { Data = Convert.ToDateTime(dr[1].ToString()), Commessa = dr[2].ToString(), Capi = Convert.ToInt32(dr[3]), Line = dr[4].ToString(), Members = Convert.ToInt32(dr[5]), Department = dr[6].ToString(), Abovenormal = Convert.ToBoolean(dr[7]), Times = Convert.ToDateTime(dr[8].ToString()), Dailyqty = dQ, Price = price, IncludeHours = incHours, Abatim = abatim, QtyH = qtyH, Shift = shift, SettingHours = settingHours, }; Tables.Productions.InsertOnSubmit(pd); } try { Config.GetGanttConn().SubmitChanges(); if (tableView1.Rows.Count <= 0) { using (var context = new System.Data.Linq.DataContext(Central.SpecialConnStr)) { context.ExecuteCommand("update objects set " + "startprod={0},endprod={1},prodqty={2},delayts={3}, delaystart={4},delayend={5} " + "where ordername={6} and aim={7} and department={8}", 0L, 0L, 0L, 0L, 0L, 0L, Workflow.TargetOrder, Workflow.TargetLine, Workflow.TargetDepartment); } } else { var jMod = new JobModel(); jMod.GetJobContinum(Workflow.TargetOrder, Workflow.TargetLine, Workflow.TargetDepartment); } var menu = new Central(); menu.GetBase(); } catch (Exception ex) { lblSavedInfo.Visible = false; lblSavedInfo.Refresh(); MessageBox.Show(ex.Message); } if (Width < 700) { Close(); } else { ShowProductionDateRange(); System.Threading.Thread.Sleep(200); lblSavedInfo.Visible = false; lblSavedInfo.Refresh(); } }
public object[] GetJobContinum(string job, string aim, string dept) { //object[] obj = new object[] { }; var production = from prod in Models.Tables.Productions where prod.Commessa == job && prod.Line == aim && prod.Department == dept orderby prod.Data select prod; var jobMod = Central.TaskList.SingleOrDefault(x => x.Name == job && x.Aim == aim && x.Department == dept); var jobModEndProduction = jobMod.ProductionEndDate.Date; int.TryParse(jobMod.WorkingDays.ToString(), out var jobWorkingDays); var prodStart = production.ToList().Count > 0 ? production.ToList().First().Data : new DateTime(); var prodEnd = production.ToList().Count > 0 ? production.ToList().Last().Times : new DateTime(); if (production.ToList().Count == 0) { return(new object[] { prodStart, prodEnd, 0, 0, 0, new TimeSpan(0, 0, 0, 0, 0), new TimeSpan(0, 0, 0, 0, 0) }); } var prodOverDays = 0.0; var lastDate = DateTime.MinValue; var startShift = Central.ShiftFrom.Hours; var endShift = Central.ShiftTo.Hours; var shiftRange = Central.ShiftTo.Subtract(Central.ShiftTo).TotalHours; var dymDailyQty = 0; var dymQty = 0.0; var dymOverQty = 0.0; var dymAlertTime = new TimeSpan(0, 0, 0, 0, 0); var dymOverTime = new TimeSpan(0, 0, 0, 0, 0); foreach (var prod in production) { if (lastDate != prod.Data.Date) { int.TryParse(prod.Dailyqty.ToString(), out var q); dymDailyQty += q; } lastDate = prod.Data.Date; dymQty += prod.Capi; } var restQty = 0.0; restQty = (dymDailyQty - dymQty); if (restQty <= 0) { dymAlertTime = new TimeSpan(0, 0, 0, 0, 0); } else { var hour = Convert.ToInt32(GetHoursBySector()); var r = Convert.ToInt32(restQty / 60); var dd = r / hour; var hh = r % hour; if (Math.Floor(Convert.ToDecimal(dd)) == 0) { dd = 0; } dymAlertTime = new TimeSpan(dd, startShift + hh, 0, 0, 0); if (dd == 0 && hh == 0) { dymAlertTime = new TimeSpan(0, 0, 0, 0, 0); } } var obj = new object[] { prodStart, prodEnd, dymQty, prodOverDays, dymOverQty, dymOverTime, dymAlertTime }; DateTime.TryParse(prodEnd.ToString(), out var endDate); if (endDate.Date > jobModEndProduction) { jobWorkingDays += 1; } using (var context = new System.Data.Linq.DataContext(Central.SpecialConnStr)) { context.ExecuteCommand("update objects set " + "startprod={0},endprod={1},prodqty={2},delayts={3}, delaystart={4},delayend={5}, workingdays={9} " + "where ordername={6} and aim={7} and department={8}", GetLSpan(prodStart), GetLSpan(endDate), dymQty, dymAlertTime.Ticks, GetLSpan(endDate), GetLSpan(endDate) + dymAlertTime.Ticks, job, aim, dept, jobWorkingDays); } return(obj); }