private void AddItemToAssy(string itemno, string qty, string assyno) { SPMSQLCommands connectAPI = new SPMSQLCommands(); DateTime datecreated = DateTime.Now; string sqlFormattedDatetime = datecreated.ToString("yyyy-MM-dd HH:mm:ss"); string username = connectAPI.getuserfullname(); try { if (_connection.State == ConnectionState.Closed) { _connection.Open(); } SqlCommand cmd = _connection.CreateCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = "INSERT INTO [SPM_Database].[dbo].[ItemDependencies] ([AssyNo],[ItemNo],[Qty]," + "DateCreated, CreatedBy, LastSaved, LastUser)" + " VALUES('" + assyno + "','" + itemno + "','" + qty + "','" + sqlFormattedDatetime + "','" + username + "','" + sqlFormattedDatetime + "','" + username + "')"; cmd.ExecuteNonQuery(); _connection.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message, "SPM Connect - Error on Add item to dependency", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { _connection.Close(); } }
private void OpenModelToolStripMenuItem_Click(object sender, EventArgs e) { using (SPMSQLCommands sc = new SPMSQLCommands()) { if (connectapi.ConnectUser.Dept == Department.Eng) { sc.Checkforspmfile(GetAssynumber()); } else { sc.Checkforspmfileprod(GetAssynumber()); } } }