protected override void grid_RowCommand(object sender, GridViewCommandEventArgs e) { Button btn = e.CommandSource as Button; if (btn == null) { return; } GridViewRow row = btn.NamingContainer as GridViewRow; int rowIndex = row.RowIndex; if (e.CommandName.Equals("Copy")) { var newValues = this.GetValues(row); string origName = newValues[FIELDS[1]].ToString().Replace(" ", " "); origName = origName.Replace(" ", " "); string copyName = origName + "_COPY"; copyName = GetUniqueName("ProdDesc", "ProdID", "tblprodfore", copyName); { ClassA classA = new ClassA(GetDirectory() + userDir); classA.setGlobalVar(); string uniqueName = ""; try { uniqueName = classA.CopyProdFore(origName, copyName); } catch (Exception exp) { logFiles.ErrorLog(exp); SetData(); try { Master.HideLoadingPopup(); } catch (Exception) { } Master.ShowErrorMessage("There is invalid data in the Product file. Some information may not be copied."); return; } classA.Close(); tableSync.SyncTables(); tableSync.UpdateEquipNames(); tableSync.UpdateOperNames(); SetData(); if (!uniqueName.Equals("")) { try { SetData(); int id = int.Parse(GetId(uniqueName)); GoToEditMode(id); } catch (Exception) { } } } try { Master.HideLoadingPopup(); } catch (Exception) { } } else { base.grid_RowCommand(sender, e); } }
protected override bool InsertRecord(string[] entries) { bool wasInserted = false; connec = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source= " + GetDirectory() + userDir + MAIN_USER_DATABASE + ";"); string command = GetCommandString(Command.INSERT); OleDbCommand cmd = new OleDbCommand(command, connec); { int i = 1; string prodDesc = ""; if (entries.Length > 0) { prodDesc = MyUtilities.clean(entries[0]).Trim(); } for (int j = 0; j < entries.Length && i < FIELDS.Length; j++) { if (mode.Equals("Standard")) { while (i < FIELDS.Length && ADVANCED_FIELDS[i]) { i++; } } if (i < FIELDS.Length) { string value = MyUtilities.clean(entries[j]); if (value.Trim().Length > 0) { value = value.Trim(); } if (CHECKBOXES[i]) { value = value.ToLower().Equals("true") ? "1" : "0"; } if (FIELDS[i].Equals("LaborDesc") || FIELDS[i].Equals("EquipDesc") || FIELDS[i].Equals("ProdDesc") || FIELDS[i].Equals("OpNam")) { value = value.ToUpper(); } cmd.Parameters.AddWithValue(FIELDS[i], value); i++; } } try { connec.Open(); int result = cmd.ExecuteNonQuery(); wasInserted = true; connec.Close(); this.SetData(); int prodId = int.Parse(GetId(prodDesc)); { ClassA classA = new ClassA(GetDirectory() + userDir); classA.addoper_1(prodId); classA.Close(); } } catch { try { connec.Close(); connec = null; } catch { } } } FillDefaultInsertRow(); return(wasInserted); }
protected override void InsertRow(bool goToEdit) { GridViewRow row = grid.FooterRow; Control[] txtControls = new Control[FIELDS.Length]; //TextBox[] txtInserts = new TextBox[FIELDS.Length]; List <String> selectedFields = new List <String>(); List <TextBox> selectedTextBoxes = new List <TextBox>(); selectedTextBoxes.Add(null); selectedFields.Add(FIELDS[0]); for (int i = 1; i < FIELDS.Length; i++) { txtControls[i] = row.FindControl(TEXT_BOX_IDS[i]); if (txtControls[i] == null) { return; } } connec = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source= " + GetDirectory() + userDir + MAIN_USER_DATABASE + ";"); //string command = GetCommandString(Command.INSERT, selectedFields.ToArray()); string command = GetCommandString(Command.INSERT); OleDbCommand cmd = new OleDbCommand(command, connec); { /*for (int i = 1; i < selectedFields.Count; i++) { * string value = selectedTextBoxes.ElementAt(i).Text; * cmd.Parameters.AddWithValue(selectedFields[i], value); * }*/ string prodDesc = ""; for (int i = 1; i < txtControls.Length; i++) { string value; if (mode.Equals("Advanced") || !ADVANCED_FIELDS[i]) { if (COMBOS[i]) { if (((AjaxControlToolkit.ComboBox)txtControls[i]).SelectedItem != null) { value = ((AjaxControlToolkit.ComboBox)txtControls[i]).SelectedValue; } else { value = MyUtilities.clean(((AjaxControlToolkit.ComboBox)txtControls[i]).Text); } } else if (CHECKBOXES[i]) { value = (((CheckBox)txtControls[i]).Checked) ? "1" : "0"; } else { value = MyUtilities.clean(((TextBox)txtControls[i]).Text); } if (FIELDS[i].Equals("LaborDesc") || FIELDS[i].Equals("EquipDesc") || FIELDS[i].Equals("ProdDesc") || FIELDS[i].Equals("OpNam")) { value = value.ToUpper(); } cmd.Parameters.AddWithValue(FIELDS[i], value); if (i == 1) { prodDesc = value; } } } try { connec.Open(); int result = cmd.ExecuteNonQuery(); connec.Close(); int prodId = int.Parse(GetId(prodDesc)); { ClassA classA = new ClassA(GetDirectory() + userDir); classA.addoper_1(prodId); classA.Close(); tableSync.UpdateEquipNames(); tableSync.UpdateOperNames(); } if (goToEdit) { SetData(); GoToEditMode(prodId); } } catch { try { connec.Close(); connec = null; } catch { } SaveInsertValues(grid.FooterRow, TEXT_BOX_IDS); Master.ShowErrorMessage(DbUse.INSERT_DATA_ERROR_MSG); } } }