public void AccessTableAdd() { String Criteria; Criteria = "PartnerID =" + textBox1.Text; Rs.MoveFirst(); //go to the beginning to start serach Rs.Find(Criteria); //Either We find the record(s), which is the first record if there are more than one //If record is found the file pointer stays at it //if not found, the file pointer has passed eof meaning eof = true if (Rs.EOF == true) { //not found Rs.AddNew(); SaveinTable(); Rs.Update(); MessageBox.Show("Record Added succesfully"); ClearBoxes(); return; } else { //found MessageBox.Show("Duplicate Record, try another PartnerID"); return; } }
private void rent_Click(object sender, EventArgs e) { Rscar.MoveFirst(); Rsuser.MoveFirst(); while (!Rscar.EOF) { if (carID.Text.Equals(Rscar.Fields["CarID"].Value)) { Rscar.Fields["Availability"].Value = "No"; Rsuser.AddNew(); Rsuser.Fields["CarID"].Value = Convert.ToInt32(carID.Text); Rsuser.Fields["FirstName"].Value = firstName.Text; Rsuser.Fields["LastName"].Value = lastName.Text; Rsuser.Fields["PhoneNumber"].Value = phoneNumber.Text; Rsuser.Fields["RentDate"].Value = Convert.ToDateTime(rentDate.Text); Rsuser.Fields["ReturnDate"].Value = Convert.ToDateTime(returnDate.Text); Rsuser.Fields["Rent"].Value = "Yes"; Rscar.Update(); Rsuser.Update(); MessageBox.Show("You rent car successfully"); return; } Rscar.MoveNext(); } MessageBox.Show("Something wrong...."); }
private void submit_Click(object sender, EventArgs e) { Boolean flag = false; RsAccount.MoveFirst(); if (amountbox.Text.Equals("") || numbox.Text.Equals("") || typebox.Text.Equals("") || branchnumbox.Text.Equals("")) { MessageBox.Show("Please enter full of your infomation."); Clear(); } else { while (!RsAccount.EOF) { if (Convert.ToInt32(numbox.Text) == RsAccount.Fields["AccountNumber"].Value && Convert.ToInt32(branchnumbox.Text) == RsAccount.Fields["BranchNumber"].Value) { flag = true; break; } RsAccount.MoveNext(); } if (flag == true) { RsTranscript.AddNew(); RsTranscript.Fields["Date"].Value = datebox.Text; RsTranscript.Fields["Time"].Value = timebox.Text; RsTranscript.Fields["Amount"].Value = Convert.ToInt32(amountbox.Text); RsTranscript.Fields["AccountNumber"].Value = Convert.ToInt32(numbox.Text); RsTranscript.Fields["TransactionType"].Value = typebox.Text; RsTranscript.Fields["BranchNumber"].Value = Convert.ToInt32(branchnumbox.Text); if (typebox.Text.Equals("Deposit")) { int total = Convert.ToInt32(amountbox.Text) + RsAccount.Fields["Balance"].Value; RsAccount.Fields["Balance"].Value = total; } else if (typebox.Text.Equals("Withdraw")) { int total = RsAccount.Fields["Balance"].Value - Convert.ToInt32(amountbox.Text); RsAccount.Fields["Balance"].Value = total; } RsAccount.Update(); RsTranscript.Update(); MessageBox.Show("Your transaction completed successfully!!!!"); Show(); info.Parent = tabControl1; transcript.Parent = null; createAccount.Parent = null; } else { MessageBox.Show("Your transaction faild...."); Clear(); } } }
private void edt_Click_1(object sender, EventArgs e) { if (edt.Text == "&Edit") { LockUnLockMe(false); addcust.Enabled = false; prev.Enabled = false; nxt.Enabled = false; fnd.Text = "&Cancel"; edt.Text = "&Update"; prename = textname.Text; return; } else if (edt.Text == "&Update") { if (textname.Text == "") { XtraMessageBox.Show("Invaild Name"); textname.Focus(); textname.Select(); return; } if (textid.Text == "") { XtraMessageBox.Show("Invaild ID"); textid.Focus(); textid.Select(); return; } if (textmobile.Text == "") { XtraMessageBox.Show("Invaild Base Weight"); textmobile.Focus(); textmobile.Select(); return; } GetData(); comm_tb.Update(); int rowlist = commidities_list.Items.Count; for (int i = 0; i < rowlist; i++) { if (commidities_list.Items[i].ToString() == prename) { commidities_list.Items[i] = textname.Text; commidities_list.Update(); break; } } SetButton(); LockUnLockMe(true); } }
//Adding new record into DB private void button1_Click(object sender, EventArgs e) { if (textBox1.Text == "" || textBox2.Text == "" || textBox3.Text == "" || textBox4.Text == "" || textBox5.Text == "" || textBox6.Text == "" || textBox7.Text == "" || textBox8.Text == "" || textBox9.Text == "" || textBox10.Text == "" || textBox11.Text == "" || textBox12.Text == "" || textBox13.Text == "" || textBox14.Text == "" || textBox15.Text == "" || textBox16.Text == "" || textBox17.Text == "" || textBox18.Text == "") { MessageBox.Show("Please Fill up all boxes"); return; } String Criteria; Criteria = "ContactID =" + textBox1.Text; Rs.MoveFirst(); //go to the beginning to start serach Rs.Find(Criteria); //Either We find the record(s), which is the first record if there are more than one //If record is found the file pointer stays at it //if not found, the file pointer has passed eof meaning eof = true if (Rs.EOF == true) { //not found Rs.AddNew(); SaveinTable(); Rs.Update(); MessageBox.Show("Record Added succesfully"); ClearBoxes(); return; } else { //found MessageBox.Show("Duplicate Record, try another ISBN"); return; } }
private void coletadados() { ADODB.Recordset dados = new ADODB.Recordset(); ADODB.Recordset itens = new ADODB.Recordset(); String SQL = "SELECT * FROM SAÍDA WHERE (COD_SAI = " + _id + ");"; String SQLProdutos = "SELECT * FROM PRODUTOS;"; //Buscando os itens dados.Open(SQL, new Conexao().getDb4(), ADODB.CursorTypeEnum.adOpenDynamic, ADODB.LockTypeEnum.adLockOptimistic); itens.Open(SQLProdutos, new Conexao().getDb4(), ADODB.CursorTypeEnum.adOpenDynamic, ADODB.LockTypeEnum.adLockOptimistic); while (!(dados.EOF || dados.BOF)) { itens.Find("cod =" + dados.Fields[dados.Fields[0].Name].Value, 0, ADODB.SearchDirectionEnum.adSearchForward); if (!(itens.BOF || itens.EOF)) { itens.Fields[36].Value = Convert.ToInt64(itens.Fields[36].Value) + Convert.ToInt64(dados.Fields[1].Value); itens.Update(); } dados.MoveNext(); } //EXcluindo ITENS SQL = "DELETE FROM SAÍDA WHERE (COD_SAI = " + _id + ");"; dados.Close(); dados.Open(SQL, new Conexao().getDb4(), ADODB.CursorTypeEnum.adOpenDynamic, ADODB.LockTypeEnum.adLockOptimistic); //Excluindo capa SQL = "DELETE FROM cod_sai WHERE(COD_SAI = " + _id + ");"; dados.Open(SQL, new Conexao().getDb4(), ADODB.CursorTypeEnum.adOpenDynamic, ADODB.LockTypeEnum.adLockOptimistic); }
public bool ChangeEmail(string cookieid, string email) { bool updated = false; string sqlString = "SELECT usercred.id, usercred.mail FROM usercred INNER JOIN userlist ON usercred.id = userlist.id WHERE userlist.sessionid = '" + cookieid + "';"; conn = new ADODB.Connection(); rec = new ADODB.Recordset(); bool openedCon = DbUse.OpenAdoMysql(conn); bool openedRec = DbUse.OpenAdoRec(conn, rec, sqlString); try { if (!openedCon || !openedRec) { throw new Exception("An error has occured. Please try again."); } else if (rec.EOF) { throw new Exception("An internal error has occured. Missing data."); } else { rec.Fields["mail"].Value = email; rec.Update(); updated = true; } } catch (Exception ex) { logFiles.ErrorLog(ex); Master.ShowErrorMessage(ex.Message); } finally { DbUse.CloseAdoRec(rec); DbUse.CloseAdo(conn); } return(updated); }
public void CallingCLRMethodsThatHaveValueTypeParametersWorksWithReferenceTypes() { var recordset = new ADODB.Recordset(); recordset.Fields.Append("name", ADODB.DataTypeEnum.adVarChar, 20, ADODB.FieldAttributeEnum.adFldUpdatable); recordset.Open(CursorType: ADODB.CursorTypeEnum.adOpenUnspecified, LockType: ADODB.LockTypeEnum.adLockUnspecified, Options: 0); recordset.AddNew(); recordset.Fields["name"].Value = "TestName"; recordset.Update(); var _ = DefaultRuntimeSupportClassFactory.DefaultVBScriptValueRetriever; object objField = _.CALL( context: null, target: recordset, members: new string[0], argumentProviderBuilder: _.ARGS.Val("name") ); Assert.Equal( "TestName", _.CALL( context: null, target: this, member1: "MockMethodReturningInputString", argumentProviderBuilder: _.ARGS.Ref(objField, v => { objField = v; }) ) ); }
public static void AddData <T>(this IDatabaseObject <T> source) where T : class { string name = typeof(T).Name; string sql = "[" + name + "]"; ADODB.Recordset rs = DataSeverConnection.Instance.Recordset(sql, ADODB.CursorTypeEnum.adOpenDynamic, ADODB.LockTypeEnum.adLockOptimistic); rs.AddNew(); PropertyInfo[] properties = typeof(T).GetProperties(); for (int i = 0; i < rs.Fields.Count; i++) { PropertyInfo property = null; properties.Each(f => { if (f.Name == rs.Fields[i].Name) { property = f; return; } }); rs.Fields[i].Value = property.GetValue(source); } rs.Update(); rs.Close(); }
private void createButton_Click(object sender, EventArgs e) { if (clientIN.Text.Equals("") || accountIN.Text.Equals("") || typeIN.Text.Equals("") || balanceIN.Text.Equals("") || limitIN.Text.Equals("") || branchIN.Text.Equals("")) { MessageBox.Show("Please enter full of your infomation."); } else { RsAccount.AddNew(); RsUser.AddNew(); RsUser.Fields["ClientID"].Value = clientIN.Text; RsUser.Fields["Password"].Value = passIN.Text; RsAccount.Fields["ClientID"].Value = Convert.ToInt32(clientIN.Text); RsAccount.Fields["AccountNumber"].Value = Convert.ToInt32(accountIN.Text); RsAccount.Fields["AccountType"].Value = typeIN.Text; RsAccount.Fields["Balance"].Value = Convert.ToInt32(balanceIN.Text); RsAccount.Fields["CreditLimit"].Value = Convert.ToInt32(limitIN.Text); RsAccount.Fields["BranchNumber"].Value = Convert.ToInt32(branchIN.Text); RsUser.Update(); RsAccount.Update(); Show(); createAccount.Parent = null; login.Parent = tabControl1; } }
private ADODB.Recordset CreateInMemoryADORS(IGTKeyObjects DDCKeyObjects) { ADODB.Recordset shapeADORecordset = new ADODB.Recordset(); try { shapeADORecordset.Fields.Append("G3E_FNO", ADODB.DataTypeEnum.adInteger, 0, ADODB.FieldAttributeEnum.adFldFixed, null); shapeADORecordset.Fields.Append("G3E_FID", ADODB.DataTypeEnum.adInteger, 0, ADODB.FieldAttributeEnum.adFldFixed, null); shapeADORecordset.Open(System.Type.Missing, System.Type.Missing, ADODB.CursorTypeEnum.adOpenUnspecified, ADODB.LockTypeEnum.adLockUnspecified, 0); foreach (IGTKeyObject keyObject in DDCKeyObjects) { shapeADORecordset.AddNew(System.Type.Missing, System.Type.Missing); shapeADORecordset.Fields["G3E_FNO"].Value = keyObject.FNO; shapeADORecordset.Fields["G3E_FID"].Value = keyObject.FID; shapeADORecordset.Update(System.Type.Missing, System.Type.Missing); } } catch (Exception ex) { string exMsg = string.Format("Error occurred in {0} of {1}.{2}{3}", System.Reflection.MethodBase.GetCurrentMethod().Name, this.ToString(), Environment.NewLine, ex.Message); throw new Exception(exMsg); } return(shapeADORecordset); }
private void edt_Click(object sender, EventArgs e) { if (edt.Text == "&Edit") { LockUnLockMe(false); textBox1.ReadOnly = true; addcust.Enabled = false; prev.Enabled = false; nxt.Enabled = false; fnd.Text = "&Cancel"; edt.Text = "&Update"; prename = textname.Text; return; } else if (edt.Text == "&Update") { if (textname.Text == "") { XtraMessageBox.Show("Invaild Name"); return; } GetData(); cstmr_tb.Update(); int rowlist = customers_list.Items.Count; for (int i = 0; i < rowlist; i++) { if (customers_list.Items[i].ToString() == prename) { customers_list.Items[i] = textname.Text; customers_list.Update(); break; } } SetButton(); LockUnLockMe(true); } }
private static bool InsertIntoAsketPorTimeEntries() { string Select = "select з.IdPorAsket, тз.IssueId, ТЗ.Spent_On,тз.Hours, Ф.UserName , тз.Comments + ' Импортировано из Redmine. ' as Comments, тз.id" + " from " + DB.TABLE_REDMINE_TIME_ENTRIES + " as ТЗ " + " left join " + DB.TABLE_REDMINE_USERS + " as П on тз.UserId = п.id " + " left join " + DB.TABLE_ASKET_USERS + " as Ф On п.IdUserFromFam = Ф.код " + " left join " + DB.TABLE_REDMINE_ISSUES + " as З on ТЗ.IssueId = З.id " + " where Deleted = 0 and InsertIntoAsketPor = 0 and з.idPorAsket is not null "; ADODB.Recordset rsSelect = DB.Select(Select); if (rsSelect == null) { return(false); } ADODB.Recordset RsAddPor = DB.Update("select top 1 Код, КодПоручения, Дата, Часов, Кто, Примечания from " + DB.TABLE_REPORT_DEVELOPER); if (RsAddPor == null) { return(false); } ADODB.Recordset RsUpdateTimeEntries = DB.Update("Select Id, InsertIntoAsketPor,IdRazrabAsket from " + DB.TABLE_REDMINE_TIME_ENTRIES + " where Deleted = 0 and InsertIntoAsketPor = 0 and IdRazrabAsket =0"); if (RsUpdateTimeEntries == null) { return(false); } while (!(rsSelect.EOF)) { RsAddPor.AddNew(); RsAddPor.Fields["КодПоручения"].Value = rsSelect.Fields["IdPorAsket"].Value; RsAddPor.Fields["Дата"].Value = rsSelect.Fields["Spent_On"].Value; RsAddPor.Fields["Часов"].Value = rsSelect.Fields["Hours"].Value; RsAddPor.Fields["Кто"].Value = rsSelect.Fields["UserName"].Value; RsAddPor.Fields["Примечания"].Value = rsSelect.Fields["Comments"].Value; RsAddPor.Update(); RsUpdateTimeEntries.Filter = "id = " + rsSelect.Fields["id"].Value; if (RsUpdateTimeEntries.RecordCount == 1) { RsUpdateTimeEntries.Fields["InsertIntoAsketPor"].Value = true; RsUpdateTimeEntries.Fields["IdRazrabAsket"].Value = RsAddPor.Fields["Код"].Value; RsUpdateTimeEntries.Update(); } rsSelect.MoveNext(); } rsSelect.Close(); RsAddPor.Close(); return(true); }
public bool salvar() { String SQL; if (alterado) { ADODB.Recordset RSDados = new ADODB.Recordset(); RSDados.CursorLocation = ADODB.CursorLocationEnum.adUseClient; RSDados.LockType = ADODB.LockTypeEnum.adLockOptimistic; RSDados.CursorType = ADODB.CursorTypeEnum.adOpenKeyset; if (cod != 0) { SQL = "SELECT Duplicatas.* FROM Duplicatas WHERE (((Duplicatas.Código)=" + cod + "));"; } else { SQL = "SELECT Duplicatas.* FROM Duplicatas;"; } RSDados.Open(SQL, new Conexao().getContas()); if (cod == 0) { RSDados.AddNew(); } RSDados.Fields["data"].Value = Vencimento.ToShortDateString(); RSDados.Fields["Origem"].Value = Origem; RSDados.Fields["informação"].Value = Informacao; RSDados.Fields["complemento"].Value = Complemento; RSDados.Fields["Valor"].Value = Valor; RSDados.Fields["Pago"].Value = Pago; RSDados.Fields["Classificação"].Value = Classificacao; RSDados.Fields["DataNota"].Value = DataNota.ToShortDateString(); RSDados.Fields["Empresa"].Value = Empresa; RSDados.Update(); if (cod == 0) { cod = Convert.ToInt32(RSDados.Fields["cod"].Value); } RSDados.Close(); return(true); } return(false); }
private static bool ConnectUsersFromRedmineWithAsket() { string SqlSelect = "select Код,email from " + DB.TABLE_ASKET_USERS + " where уволен = 0 and email in( select mail from " + DB.TABLE_REDMINE_USERS + " where IdUserFromFam = 0)"; ADODB.Recordset rs = DB.Select(SqlSelect); ADODB.Recordset users = DB.Update("Select * from " + DB.TABLE_REDMINE_USERS); while (!rs.EOF) { users.Filter = "mail = '" + rs.Fields["email"].Value + "'"; users.Fields["IdUserFromFam"].Value = rs.Fields["Код"].Value; rs.MoveNext(); } users.Update(); users.Close(); rs.Close(); rs = null; return(true); }
public virtual void Update() { try { string[] keys = GetPrimaryKeyColumns(); string tblName = typeof(T).Name; int idx = tblName.IndexOf("'"); if (idx > 0) { tblName = tblName.Substring(0, idx); } string sql = "SELECT * FROM [" + typeof(T).Name + "] WHERE " + GetSQLCriteria(GetPrimaryKeys(keys)); ADODB.Recordset rs = DataSeverConnection.Instance.Recordset(sql, ADODB.CursorTypeEnum.adOpenDynamic, ADODB.LockTypeEnum.adLockOptimistic); FillRecordset(false, rs, keys); rs.Update(); } catch (Exception err) { MessageBox.Show("Error Updating Database: " + err.Message); } }
public void ADORecordsetSupportsDefaultFieldAccess() { var recordset = new ADODB.Recordset(); recordset.Fields.Append("name", ADODB.DataTypeEnum.adVarChar, 20, ADODB.FieldAttributeEnum.adFldUpdatable); recordset.Open(CursorType: ADODB.CursorTypeEnum.adOpenUnspecified, LockType: ADODB.LockTypeEnum.adLockUnspecified, Options: 0); recordset.AddNew(); recordset.Fields["name"].Value = "TestName"; recordset.Update(); var _ = DefaultRuntimeSupportClassFactory.DefaultVBScriptValueRetriever; Assert.Equal( recordset.Fields["name"], _.CALL( context: null, target: recordset, members: new string[0], argumentProviderBuilder: _.ARGS.Val("name") ), new ADOFieldObjectComparer() ); }
public virtual void Add(bool addAll = false, ProgressReporter pg = null) { //lock (DataSeverConnection.Instance.Connection) //{ try { string sql = "SELECT * FROM [" + typeof(T).Name.SanitizeTypeName() + "]"; ADODB.Recordset rs = DataSeverConnection.Instance.Recordset(sql, ADODB.CursorTypeEnum.adOpenDynamic, ADODB.LockTypeEnum.adLockOptimistic); string[] keys = GetPrimaryKeyColumns(); try { rs.AddNew(); FillRecordset(addAll, rs, keys); rs.Update(); } catch (Exception) { return; } if (addAll == false) { keys.Each(k => { int pos = rs.GetFieldPosition(k); PropertyInfo temp = typeof(T).GetProperty(k); object val = rs.Fields[pos].Value; temp.SetValue(this, Convert.ChangeType(val, temp.PropertyType)); }); } rs.Close(); NeedsToSave = false; if (pg != null) { pg.ReportProgress(pg.ReportAction); } } catch (Exception err) { MessageBox.Show("Error adding to Database: " + err.Message); } //} }
public static void SaveDatabase() { ADODB.Connection cn = new ADODB.Connection(); cn.Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Application.StartupPath + "\\mdb\\" + CComLibrary.GlobeVal.filesave.methodname + ".mdb", null, null, -1); ADODB.Recordset rs; rs = new ADODB.Recordset(); rs.LockType = ADODB.LockTypeEnum.adLockPessimistic; rs.CursorType = ADODB.CursorTypeEnum.adOpenDynamic; string sql = "select * from FirstTable"; rs.Open(sql, cn, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockOptimistic, (int)ADODB.CommandTypeEnum.adCmdText); if ((rs.RecordCount > 0)) { rs.MoveFirst(); } string mshiyanghao = ""; string myangpinmingcheng = ""; int nshiyanhao = 0; int nyangpinmingcheng = 0; int nRecordId = 0; for (int j = 0; j < CComLibrary.GlobeVal.filesave.mdatabaseitemselect.Count; j++) { if (CComLibrary.GlobeVal.filesave.mdatabaseitemselect[j].Name == "试样号") { mshiyanghao = CComLibrary.GlobeVal.filesave.mdatabaseitemselect[j].Value; nshiyanhao = j; } if (CComLibrary.GlobeVal.filesave.mdatabaseitemselect[j].Name == "样品名称") { myangpinmingcheng = CComLibrary.GlobeVal.filesave.mdatabaseitemselect[j].Value; nyangpinmingcheng = j; } } bool mb = false; string wshiyanghao = ""; string wyangpinmingcheng = ""; for (int i = 0; i < rs.RecordCount; i++) { wshiyanghao = Convert.ToString(rs.Fields[nshiyanhao + 1].Value); wyangpinmingcheng = Convert.ToString(rs.Fields[nyangpinmingcheng + 1].Value); if ((wshiyanghao == mshiyanghao) && (wyangpinmingcheng == myangpinmingcheng)) { mb = true; nRecordId = Convert.ToInt32(rs.Fields[0].Value); break; } else { rs.MoveNext(); } } for (int i = 0; i < 1; i++) { object missing = System.Reflection.Missing.Value; if (mb == false) { rs.AddNew(missing, missing); rs.Fields["RecordId"].Value = rs.RecordCount; } else { rs.Delete(ADODB.AffectEnum.adAffectCurrent); rs.AddNew(missing, missing); rs.Fields["RecordId"].Value = nRecordId; } for (int j = 0; j < CComLibrary.GlobeVal.filesave.mdatabaseitemselect.Count; j++) { if (CComLibrary.GlobeVal.filesave.mdatabaseitemselect[j].Value == null) { rs.Fields[j + 1].Value = ""; } else { rs.Fields[j + 1].Value = CComLibrary.GlobeVal.filesave.mdatabaseitemselect[j].Value; } } rs.Update(); } rs.Close(); cn.Close(); }
private void button1_Click(object sender, EventArgs e) { if (comboBox2.Text == "") { MessageBox.Show("PAY Type can't be empty"); comboBox2.Select(); comboBox2.Focus(); return; } if (comboBox2.Text == "CHEQUE") { if (textBox5.Text == "") { MessageBox.Show("Enter Cheque Details"); textBox5.Select(); textBox5.Focus(); return; } } for (int i = 0; i < dataGridView1.RowCount - 1; i++) { for (int j = 0; j <= 2; j++) { if (dataGridView1.Rows[i].Cells[j] == null || dataGridView1.Rows[i].Cells[j].Value == "") { MessageBox.Show("Field can't be empty"); dataGridView1.CurrentCell = dataGridView1.Rows[i].Cells[j]; return; } } } Temp1.Open(@"select * from farmerpayment", Program.DB, ADODB.CursorTypeEnum.adOpenStatic, ADODB.LockTypeEnum.adLockOptimistic); for (int i = 0; i < dataGridView1.RowCount - 1; i++) { Temp1.AddNew(); Temp1.Fields["fpayId"].Value = Int64.Parse(textBox1.Text); if (comboBox2.Text == "CASH") { Temp1.Fields["fpaytype"].Value = "CASH"; } else if (comboBox2.Text == "CHEQUE") { Temp1.Fields["fpaytype"].Value = "CHEQUE : " + textBox5.Text; } Temp2.Open(@"select * from farmerdetails WHERE fNames='" + dataGridView1.Rows[i].Cells[0].EditedFormattedValue + "'", Program.DB, ADODB.CursorTypeEnum.adOpenStatic, ADODB.LockTypeEnum.adLockOptimistic); Temp1.Fields["fID"].Value = Temp2.Fields["fID"].Value; Temp2.Close(); Temp1.Fields["pattiId"].Value = Int64.Parse(dataGridView1.Rows[i].Cells[1].EditedFormattedValue.ToString()); Temp1.Fields["Amount"].Value = decimal.Parse(dataGridView1.Rows[i].Cells[2].EditedFormattedValue.ToString()); Temp2.Open(@"select * from pattirefer WHERE pattiID = " + Int64.Parse(dataGridView1.Rows[i].Cells[1].EditedFormattedValue.ToString()) + "", Program.DB, ADODB.CursorTypeEnum.adOpenStatic, ADODB.LockTypeEnum.adLockOptimistic); Temp2.Fields["payable"].Value = Temp2.Fields["payable"].Value - decimal.Parse(dataGridView1.Rows[i].Cells[2].EditedFormattedValue.ToString()); Temp2.Update(); Temp2.Close(); Temp1.Fields["PayDay"].Value = dateTimePicker1.Value.ToShortDateString(); Temp1.Fields["TotalAmount"].Value = decimal.Parse(textBox2.Text); Temp1.Update(); } Temp1.Close(); MessageBox.Show("SAVED"); textBox1.Text = (Int64.Parse(textBox1.Text) + 1).ToString(); comboBox2.SelectedIndex = -1; label7.Visible = false; textBox5.Visible = false; textBox2.Text = ""; dataGridView1.Rows.Clear(); }
/// <summary> /// Creates an ADODB.Recordset from an System.Collections.Generic.IEnumerable(T). /// </summary> /// <typeparam name="T">The type of the elements of input.</typeparam> /// <param name="input">The System.Collections.Generic.IEnumerable(T) to create an ADODB.Recordset from.</param> /// <returns>An ADODB.Recordset that contains elements from the input sequence.</returns> public static ADODB.Recordset ToRecordset <T>(this IEnumerable <T> input) { var adoType = new ADODB.DataTypeEnum(); if (DataTypes.TryGetAdoTypeForClrType(typeof(T), out adoType)) { throw new ArgumentException("The T of IEnumerable<T> must be a custom POCO, not an ADO compatible type.", "input"); } var rs = new ADODB.Recordset(); var type = typeof(T); BindingFlags flags = BindingFlags.Public | BindingFlags.Instance; PropertyInfo[] properties = type.GetProperties(flags); // create properties foreach (var property in properties) { if (DataTypes.TryGetAdoTypeForClrType(property.PropertyType, out adoType)) { int definedSize = 0; if (property.PropertyType == typeof(string)) { // TODO: set string size to length of longest string in POCO? definedSize = 1000; } if (property.PropertyType == typeof(Guid)) { definedSize = 38; } rs.Fields.Append(property.Name, adoType, definedSize, ADODB.FieldAttributeEnum.adFldIsNullable); } } // insert data rs.Open(); if (input.Any()) { foreach (var item in input) { rs.AddNew(); foreach (var property in properties) { var value = property.GetValue(item, null); if (property.PropertyType == typeof(Guid)) { value = value.ToString(); } if (value != null) { rs.Fields[property.Name].Value = value; } } rs.Update(); } } return(rs); }
private void btnsave_Click(object sender, EventArgs e) { ADODB.Recordset tmp = new ADODB.Recordset(); try { if (ADOconn.State == 0) { ADOconn.Open("Provider=SQLOLEDB;Initial Catalog= " + decoder.InitialCatalog + ";Data Source=" + decoder.DataSource + ";", decoder.UserID, decoder.Password, 0); } ADODB.Recordset rec = new ADODB.Recordset(); Conn.Close(); // Conn.Open(); bool isempty; isempty = false; if (isedit) { if (txtpriv.Text.Substring(1, 1) == "0") { MessageBox.Show("Insufficient Priveleges ", "Insufficient Priveleges "); return; } } else { if (txtpriv.Text.Substring(0, 1) == "0") { MessageBox.Show("Insufficient Priveleges ", "Insufficient Priveleges "); return; } } if (isempty) { MessageBox.Show("Entry Not Completed, Please fill all Yellow Marked fileds!!", "Invalid Entry"); return; } try { // ADOconn.BeginTrans(); //if (cmbmonth.SelectedIndex<0) //{ // MessageBox.Show("Invalid Salary Month, Please Select a Valid Month", "Invalid Entry"); // return; //} ADOconn.BeginTrans(); int i = 0; string entry_no = dtentry.Value.Date.ToString("yyyyMMdd"); if (isedit) { sql = "delete from reconcil_det where Reconcil_No = '" + entry_no + "'"; object a; ADOconn.Execute(sql, out a); } sql = "select * from reconcil_det where Reconcil_No = '" + entry_no + "'"; rec = new ADODB.Recordset(); rec.Open(sql, ADOconn, ADODB.CursorTypeEnum.adOpenStatic, ADODB.LockTypeEnum.adLockOptimistic, -1); if (rec.RecordCount == 0) { // rec.AddNew(); } else { MessageBox.Show("Entry Already Exist , Cannot enter as a New entry", "Invalid Entry"); return; } for (i = 0; i < dgv1.Rows.Count; i++) { if (dgv1[0, i].Value != null) { rec.AddNew(); if (dgv1[3, i].Value == null) { dgv1[3, i].Value = 0; } if (dgv1[4, i].Value == null) { dgv1[4, i].Value = 0; } double amt = Convert.ToDouble(dgv1[3, i].Value) + Convert.ToDouble(dgv1[4, i].Value); rec.Fields["Reconcil_No"].Value = entry_no; rec.Fields["Reconcil_Date"].Value = dtentry.Value.Date; rec.Fields["Reconcil_user"].Value = Gvar.username; rec.Fields["Amount"].Value = Math.Abs(amt); rec.Fields["Bank_No"].Value = cmbbank.SelectedValue; rec.Fields["DR_CR"].Value = dgv1[2, i].Value; rec.Fields["plus_minus"].Value = ""; rec.Fields["pay_date"].Value = dgv1[0, i].Value; rec.Fields["SNO"].Value = i + 1; rec.Fields["trn_type"].Value = "A"; rec.Fields["NARRATION"].Value = dgv1[5, i].Value; rec.Update(); } } for (i = 0; i < dgvbank.Rows.Count; i++) { if (dgvbank[2, i].Value != null) { rec.AddNew(); if (dgvbank[0, i].Value == null) { dgvbank[0, i].Value = ""; } if (dgvbank[1, i].Value == null) { dgvbank[1, i].Value = 0; } double amt = Convert.ToDouble(dgvbank[2, i].Value); rec.Fields["Reconcil_No"].Value = entry_no; rec.Fields["Reconcil_Date"].Value = dtentry.Value.Date; rec.Fields["Reconcil_user"].Value = Gvar.username; rec.Fields["Amount"].Value = Math.Abs(amt); rec.Fields["Bank_No"].Value = cmbbank.SelectedValue; if (dgvbank[1, i].Value == "+") { rec.Fields["DR_CR"].Value = "D"; } else { rec.Fields["DR_CR"].Value = "C"; } rec.Fields["plus_minus"].Value = dgvbank[1, i].Value; rec.Fields["pay_date"].Value = ""; rec.Fields["SNO"].Value = i + 1; rec.Fields["trn_type"].Value = "B"; rec.Fields["NARRATION"].Value = dgvbank[0, i].Value; rec.Update(); } } for (i = 0; i < dgvbook.Rows.Count; i++) { if (dgvbook[2, i].Value != null) { rec.AddNew(); if (dgvbook[0, i].Value == null) { dgvbook[0, i].Value = ""; } if (dgvbook[1, i].Value == null) { dgvbook[1, i].Value = 0; } double amt = Convert.ToDouble(dgvbook[2, i].Value); rec.Fields["Reconcil_No"].Value = entry_no; rec.Fields["Reconcil_Date"].Value = dtentry.Value.Date; rec.Fields["Reconcil_user"].Value = Gvar.username; rec.Fields["Amount"].Value = Math.Abs(amt); rec.Fields["Bank_No"].Value = cmbbank.SelectedValue; if (dgvbook[1, i].Value == "+") { rec.Fields["DR_CR"].Value = "D"; } else { rec.Fields["DR_CR"].Value = "C"; } rec.Fields["plus_minus"].Value = dgvbook[1, i].Value; rec.Fields["pay_date"].Value = ""; rec.Fields["SNO"].Value = i + 1; rec.Fields["trn_type"].Value = "C"; rec.Fields["NARRATION"].Value = dgvbook[0, i].Value; rec.Update(); } } ADOconn.CommitTrans(); isedit = true; MessageBox.Show("Successfully Saved"); } catch (Exception ex) { ADOconn.RollbackTrans(); MessageBox.Show(ex.Message); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
//string sql; private void save_form() { ADODB.Connection ADOconn = new ADODB.Connection(); try { //if (tooltip.Text.Trim().Length < 3) //{ // MessageBox.Show("Invalid Length of Code, Must Be 3 Digit!!"); // return; //} ADOconn.Open("Provider=SQLOLEDB;Initial Catalog= " + decoder.InitialCatalog + ";Data Source=" + decoder.DataSource + ";", decoder.UserID, decoder.Password, 0); ADODB.Recordset rec = new ADODB.Recordset(); Conn.Close(); // Conn.Open(); bool isempty; isempty = false; if (isedit) { if (txtpriv.Text.Substring(1, 1) == "0") { MessageBox.Show("Insufficient Priveleges ", "Insufficient Priveleges "); return; } } else { if (txtpriv.Text.Substring(0, 1) == "0") { MessageBox.Show("Insufficient Priveleges ", "Insufficient Priveleges "); return; } } foreach (Control gb in this.Controls) { if (gb is GroupBox) { foreach (Control tb in gb.Controls) { if (tb is TextBox) { if (tb.Tag == "1") { tb.BackColor = System.Drawing.Color.White; if (string.IsNullOrEmpty(tb.Text.Trim())) { tb.BackColor = System.Drawing.Color.Yellow; isempty = true; } } } } } } if (isempty) { MessageBox.Show("Entry Not Completed, Please fill all Yellow Marked fileds!!", "Invalid Entry"); return; } //if (txtvehno.Text.Trim() == "") txtvehno.Text = "0"; if (txtcuscode.Text.Trim() == "") { txtcuscode.Text = "0"; } //sql = "SELECT * FROM Customer where Customer_no =" + Convert.ToDecimal(txtcuscode.Text.Trim()); Int64 acno = 0; try { sql = "SELECT * FROM Veh_Customer where Cus_code =" + Convert.ToDouble(txtcuscode.Text.Trim()); rec.Open(sql, ADOconn, ADODB.CursorTypeEnum.adOpenStatic, ADODB.LockTypeEnum.adLockOptimistic, -1); if (rec.RecordCount == 0) { sql = "SELECT MAX(cus_code)+1 FROM Veh_Customer"; ADODB.Recordset tmp = new ADODB.Recordset(); tmp.Open(sql, ADOconn, ADODB.CursorTypeEnum.adOpenStatic, ADODB.LockTypeEnum.adLockOptimistic, -1); if (tmp.Fields[0].Value != DBNull.Value) { txtcuscode.Text = tmp.Fields[0].Value.ToString(); } else { txtcuscode.Text = "1"; } tmp = new ADODB.Recordset(); sql = "update ACC_TYPE SET CUR_NO = " + acno + " WHERE ACC_TYPE_CODE=1"; tmp.Open(sql, ADOconn, ADODB.CursorTypeEnum.adOpenDynamic, ADODB.LockTypeEnum.adLockOptimistic, -1); rec.AddNew(); } acno = Convert.ToInt64(txtcuscode.Text.Trim()); rec.Fields["Cus_code"].Value = Convert.ToDouble(txtcuscode.Text.Trim()); //rec.Fields["Cus_code"].Value = txtcuscode.Text.Trim(); rec.Fields["Cus_cat"].Value = cmbcat.SelectedValue; rec.Fields["Cus_Name"].Value = txtcusname.Text.Trim(); rec.Fields["Sponsor_code"].Value = cmbsponsor.SelectedValue; rec.Fields["Id_Number"].Value = txtidnumber.Text.Trim(); rec.Fields["Mobile"].Value = txtmobileno.Text.Trim(); rec.Fields["Address"].Value = txtcusadd.Text.Trim(); rec.Fields["office_no"].Value = txtofficeno.Text.Trim(); rec.Fields["careof"].Value = txtcareof.Text.Trim(); rec.Fields["contact_no"].Value = txtcontactno.Text.Trim(); rec.Fields["ID_issued_at"].Value = txtissueplace.Text.Trim(); rec.Fields["License_No"].Value = txtlicno.Text.Trim(); rec.Fields["ID_Expiry_Date"].Value = txtidexiry.Text.Trim(); rec.Fields["Licence_Issued_at"].Value = txtlicissueplace.Text.Trim(); rec.Fields["Licence_exp_date"].Value = txtlicexpiry.Text.Trim(); rec.Fields["Nationality"].Value = txtnationality.Text.Trim(); rec.Fields["EmailId"].Value = txtemailid.Text.Trim(); rec.Update(); //if (txtvehno.Text.Trim() == "") txtvehno.Text = "0"; //if (txtvalue.Text.Trim() == "") txtvalue.Text = "0"; //sql = "SELECT * FROM Customer where Customer_no =" + Convert.ToDecimal(txtcuscode.Text.Trim()); sql = "SELECT * FROM Accounts where Acc_no ='" + acno + "'"; rec = new ADODB.Recordset(); rec.Open(sql, ADOconn, ADODB.CursorTypeEnum.adOpenStatic, ADODB.LockTypeEnum.adLockOptimistic, -1); if (rec.RecordCount == 0) { rec.AddNew(); } //rec.Fields["veh_no"].Value = Convert.ToDouble(txtvehno.Text.Trim()); rec.Fields["ACC_NO"].Value = txtcuscode.Text.Trim(); rec.Fields["ACC_NAME"].Value = txtcusname.Text.Trim(); rec.Fields["ACC_CATEGORY"].Value = 1; rec.Fields["ACC_TYPE_CODE"].Value = 1; rec.Fields["ACC_TELE_NO"].Value = txtofficeno.Text.Trim(); rec.Fields["ACC_FAX_NO"].Value = txtofficeno.Text.Trim(); rec.Fields["ACC_ADDRESS"].Value = txtcusadd.Text.Trim(); rec.Fields["CONTACT_PERSON"].Value = txtcusname.Text.Trim(); rec.Fields["Id_Number"].Value = txtidnumber.Text.Trim(); rec.Fields["ACC_Mobile_NO"].Value = txtmobileno.Text.Trim(); rec.Fields["flag"].Value = "A"; rec.Update(); MessageBox.Show("Successfully Saved"); load_leaders(); } catch (Exception ex) { MessageBox.Show(ex.Message); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
//string sql; private void save_form() { ADODB.Connection ADOconn = new ADODB.Connection(); try { //if (tooltip.Text.Trim().Length < 3) //{ // MessageBox.Show("Invalid Length of Code, Must Be 3 Digit!!"); // return; //} ADOconn.Open("Provider=SQLOLEDB;Initial Catalog= " + decoder.InitialCatalog + ";Data Source=" + decoder.DataSource + ";", decoder.UserID, decoder.Password, 0); ADODB.Recordset rec = new ADODB.Recordset(); Conn.Close(); // Conn.Open(); bool isempty; isempty = false; if (isedit) { if (txtpriv.Text.Substring(1, 1) == "0") { MessageBox.Show("Insufficient Priveleges ", "Insufficient Priveleges "); return; } } else { if (txtpriv.Text.Substring(0, 1) == "0") { MessageBox.Show("Insufficient Priveleges ", "Insufficient Priveleges "); return; } } foreach (Control gb in this.Controls) { if (gb is GroupBox) { foreach (Control tb in gb.Controls) { if (tb is TextBox) { if (tb.Tag == "1") { tb.BackColor = System.Drawing.Color.White; if (string.IsNullOrEmpty(tb.Text.Trim())) { tb.BackColor = System.Drawing.Color.Yellow; isempty = true; } } } } } } if (isempty) { MessageBox.Show("Entry Not Completed, Please fill all Yellow Marked fileds!!", "Invalid Entry"); return; } //if (txtcuscode.Text.Trim() == "") //{ // MessageBox.Show("Invalid SponsorCode , Please enter a Valid Numeber!!", "Invalid Entry"); // return; //} if (txtcusname.Text.Trim() == "") { MessageBox.Show("Invalid Sponsor Name , Please enter a Valid Name!!", "Invalid Entry"); return; } //txtvehno.Text = "0"; if (txtcuscode.Text.Trim() == "") { txtcuscode.Text = "-0"; } //sql = "SELECT * FROM Customer where Customer_no =" + Convert.ToDecimal(txtcuscode.Text.Trim()); sql = "SELECT * FROM veh_sponsor where sponsor_code ='" + txtcuscode.Text.Trim() + "'"; try { rec.Open(sql, ADOconn, ADODB.CursorTypeEnum.adOpenStatic, ADODB.LockTypeEnum.adLockOptimistic, -1); if (rec.RecordCount == 0) { rec.AddNew(); } //rec.Fields["veh_no"].Value = Convert.ToDouble(txtvehno.Text.Trim()); //rec.Fields["sponsor_code"].Value = Convert.ToDouble(txtcuscode.Text.Trim()); rec.Fields["sponsor_name"].Value = txtcusname.Text.Trim(); rec.Fields["contact_name"].Value = txtcontact.Text.Trim(); rec.Fields["Id_Number"].Value = txtidnumber.Text.Trim(); rec.Fields["Mobile"].Value = txtmobileno.Text.Trim(); rec.Fields["Address"].Value = txtcusadd.Text.Trim(); rec.Update(); rec = new ADODB.Recordset(); rec.Open("SELECT @@IDENTITY", ADOconn, ADODB.CursorTypeEnum.adOpenDynamic, ADODB.LockTypeEnum.adLockOptimistic, -1); //rec.GetRows(); txtcuscode.Text = rec.Fields[0].Value.ToString(); //rec.Requery(); //txtcuscode.Text = rec.Fields["sponsor_code"].Value.ToString(); MessageBox.Show("Successfully Saved"); load_leaders(); } catch (Exception ex) { MessageBox.Show(ex.Message); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
//string sql; private void save_form() { ADODB.Connection ADOconn = new ADODB.Connection(); ADODB.Recordset tmp = new ADODB.Recordset(); try { //if (tooltip.Text.Trim().Length < 3) //{ // MessageBox.Show("Invalid Length of Code, Must Be 3 Digit!!"); // return; //} ADOconn.Open("Provider=SQLOLEDB;Initial Catalog= " + decoder.InitialCatalog + ";Data Source=" + decoder.DataSource + ";", decoder.UserID, decoder.Password, 0); ADODB.Recordset rec = new ADODB.Recordset(); Conn.Close(); // Conn.Open(); bool isempty; isempty = false; if (isedit) { if (txtpriv.Text.Substring(1, 1) == "0") { MessageBox.Show("Insufficient Priveleges ", "Insufficient Priveleges "); return; } } else { if (txtpriv.Text.Substring(0, 1) == "0") { MessageBox.Show("Insufficient Priveleges ", "Insufficient Priveleges "); return; } } foreach (Control gb in this.Controls) { if (gb is GroupBox) { foreach (Control tb in gb.Controls) { if (tb is TextBox) { if (tb.Tag == "1") { tb.BackColor = System.Drawing.Color.White; if (string.IsNullOrEmpty(tb.Text.Trim())) { tb.BackColor = System.Drawing.Color.Yellow; isempty = true; } } } } } } if (isempty) { MessageBox.Show("Entry Not Completed, Please fill all Yellow Marked fileds!!", "Invalid Entry"); return; } try { ADOconn.BeginTrans(); if (!isedit) { gen_accno(); tmp = new ADODB.Recordset(); //sql = "update ACC_TYPE SET CUR_NO = CUR_NO+1 WHERE ACC_TYPE_CODE=" + cmbCostCode.SelectedValue; // tmp.Open(sql, ADOconn, ADODB.CursorTypeEnum.adOpenDynamic, ADODB.LockTypeEnum.adLockOptimistic, -1); } if (txtProjectAmt.Text.Trim() == "") { txtProjectAmt.Text = "0"; } //if (txtvalue.Text.Trim() == "") txtvalue.Text = "0"; //sql = "SELECT * FROM Customer where Customer_no =" + Convert.ToDecimal(txtcuscode.Text.Trim()); sql = "SELECT * FROM project_master where project_code ='" + txtprojectcode.Text.Trim() + "'"; rec.Open(sql, ADOconn, ADODB.CursorTypeEnum.adOpenStatic, ADODB.LockTypeEnum.adLockOptimistic, -1); if (rec.RecordCount == 0) { rec.AddNew(); } if (txtProjectAmt.Text == "") { txtProjectAmt.Text = "0"; } if (txtpercent.Text == "") { txtpercent.Text = "0"; } //rec.Fields["veh_no"].Value = Convert.ToDouble(txtvehno.Text.Trim()); rec.Fields["Project_Code"].Value = txtprojectcode.Text.Trim(); rec.Fields["Project_Name"].Value = txtProjectname.Text.Trim(); rec.Fields["Client_code"].Value = cmbacc.SelectedValue; rec.Fields["Cost_Code"].Value = Convert.ToInt32(txtprojectcode.Text); //cmbCostCode.SelectedValue; rec.Fields["Start_date"].Value = dt1.Value.Date.ToString("yyyy-MM-dd");; rec.Fields["End_Date"].Value = dtend.Value.Date.ToString("yyyy-MM-dd"); rec.Fields["Project_det"].Value = txtDescription.Text.Trim(); rec.Fields["completed"].Value = Convert.ToDouble(txtpercent.Text); rec.Fields["Status"].Value = cmbstatus.Text.Trim(); rec.Fields["Incharge"].Value = cmbincharge.Text.Trim(); rec.Fields["Location"].Value = cmblocaltion.Text.Trim(); rec.Fields["Project_Amt"].Value = Convert.ToDouble(txtProjectAmt.Text); rec.Update(); sql = "select Cost_Code,Cost_name from Cost_Master where cost_code= " + Convert.ToInt32(txtprojectcode.Text); rec = new ADODB.Recordset(); rec.Open(sql, ADOconn, ADODB.CursorTypeEnum.adOpenStatic, ADODB.LockTypeEnum.adLockOptimistic, -1); if (rec.RecordCount == 0) { rec.AddNew(); } rec.Fields["Cost_Code"].Value = Convert.ToInt32(txtprojectcode.Text); rec.Fields["Cost_name"].Value = txtProjectname.Text.Trim(); rec.Update(); ADOconn.CommitTrans(); isedit = true; MessageBox.Show("Successfully Saved"); load_leaders(); } catch (Exception ex) { ADOconn.RollbackTrans(); MessageBox.Show(ex.Message); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void button1_Click(object sender, EventArgs e) { if (textBox1.Text != "") { if (dataGridView1.RowCount > 1) { patti_entry.Open(@"select * from pattirefer", Program.DB, ADODB.CursorTypeEnum.adOpenStatic, ADODB.LockTypeEnum.adLockOptimistic); patti_entry.AddNew(); patti_entry.Fields["pattiId"].Value = pattilbl.Text; patti_entry.Fields["fID"].Value = int.Parse(textBox1.Text); patti_entry.Fields["comm"].Value = float.Parse(txtbcomm.Text); patti_entry.Fields["bardan"].Value = float.Parse(txtbbardan.Text); patti_entry.Fields["hamali"].Value = float.Parse(txtbhamali.Text); patti_entry.Fields["freight"].Value = float.Parse(txtbfreight.Text); patti_entry.Fields["packing"].Value = float.Parse(txtbpacking.Text); patti_entry.Fields["other"].Value = float.Parse(txtbother.Text); patti_entry.Fields["netsale"].Value = float.Parse(txtbnetsale.Text); patti_entry.Fields["exp"].Value = float.Parse(txtbexp.Text); patti_entry.Fields["grosssale"].Value = float.Parse(txtbgrosssale.Text); patti_entry.Fields["patti_date"].Value = dateTimePicker1.Value.ToShortDateString(); transact_entry.Open(@"select * from transactions", Program.DB, ADODB.CursorTypeEnum.adOpenStatic, ADODB.LockTypeEnum.adLockOptimistic); int rc = dataGridView1.RowCount - 1; for (int i = 0; i < rc; i++) { transact_entry.AddNew(); transact_entry.Fields["tID"].Value = transact_entry.RecordCount + 1; transact_entry.Fields["pattiID"].Value = pattilbl.Text; transact_entry.Fields["coID"].Value = dataGridView1.Rows[i].Cells[0].EditedFormattedValue.ToString(); transact_entry.Fields["coweight"].Value = dataGridView1.Rows[i].Cells[4].EditedFormattedValue.ToString(); transact_entry.Fields["coprice"].Value = dataGridView1.Rows[i].Cells[6].EditedFormattedValue.ToString(); transact_entry.Fields["rate"].Value = dataGridView1.Rows[i].Cells[5].EditedFormattedValue.ToString(); transact_entry.Fields["qty"].Value = dataGridView1.Rows[i].Cells[2].EditedFormattedValue.ToString(); string query1 = "select * from customerdetails where CName='" + dataGridView1.Rows[i].Cells[3].EditedFormattedValue + "'"; Temp1.Open(query1, Program.DB, ADODB.CursorTypeEnum.adOpenStatic, ADODB.LockTypeEnum.adLockOptimistic); transact_entry.Fields["cID"].Value = Temp1.Fields["cID"].Value; string query2 = "select * from billrefer where cID = " + Temp1.Fields["cID"].Value + " AND bill_date = #" + dateTimePicker1.Value.ToShortDateString() + "#"; bill_entry.Open(query2, Program.DB, ADODB.CursorTypeEnum.adOpenStatic, ADODB.LockTypeEnum.adLockOptimistic); if (bill_entry.RecordCount == 0) { bill_entry.AddNew(); Temp2.Open(@"select * from billrefer", Program.DB, ADODB.CursorTypeEnum.adOpenStatic, ADODB.LockTypeEnum.adLockOptimistic); if (Temp2.RecordCount == 0) { bill_entry.Fields["billID"].Value = 1; transact_entry.Fields["billId"].Value = 1; } else { bill_entry.Fields["billID"].Value = Temp2.RecordCount + 1; transact_entry.Fields["billId"].Value = Temp2.RecordCount + 1; } Temp2.Close(); bill_entry.Fields["saleamt"].Value = dataGridView1.Rows[i].Cells[6].EditedFormattedValue.ToString(); bill_entry.Fields["totalamt"].Value = dataGridView1.Rows[i].Cells[6].EditedFormattedValue.ToString(); bill_entry.Fields["cID"].Value = Temp1.Fields["cID"].Value; bill_entry.Fields["bill_date"].Value = dateTimePicker1.Value.ToShortDateString(); decimal oldbalance = decimal.Parse(Temp1.Fields["cbalance"].Value.ToString()); Temp1.Fields["cbalance"].Value = decimal.Parse(dataGridView1.Rows[i].Cells[6].EditedFormattedValue.ToString()) + oldbalance; Temp1.Update(); } else { transact_entry.Fields["billId"].Value = bill_entry.Fields["billID"].Value; decimal tempsaleamnt; tempsaleamnt = bill_entry.Fields["saleamt"].Value + decimal.Parse(dataGridView1.Rows[i].Cells[6].EditedFormattedValue.ToString()); bill_entry.Fields["saleamt"].Value = decimal.Parse(tempsaleamnt.ToString()); bill_entry.Fields["totalamt"].Value = decimal.Parse(tempsaleamnt.ToString()); decimal oldbalance = decimal.Parse(Temp1.Fields["cbalance"].Value); Temp1.Fields["cbalance"].Value = decimal.Parse(dataGridView1.Rows[i].Cells[6].EditedFormattedValue.ToString()) + oldbalance; Temp1.Update(); } Temp1.Close(); bill_entry.Update(); bill_entry.Close(); } transact_entry.Update(); transact_entry.Close(); patti_entry.Update(); patti_entry.Close(); dataGridView1.Rows.Clear(); pattinum += 1; pattilbl.Text = pattinum.ToString(); textBox1.Clear(); textBox2.Clear(); txtbbardan.ResetText();//Clear(); txtbcomm.ResetText(); txtbexp.ResetText(); txtbfreight.ResetText(); txtbgrosssale.ResetText(); txtbhamali.ResetText(); txtbnetsale.ResetText(); txtbother.ResetText(); txtbpacking.ResetText(); Program.DB.Close(); Program.DB.Open(); /* pattireportprint PP = new pattireportprint(); * PP.PrintDialog(); * PP.BeginUpdate(); * int b=pattinum-1; * PP.FilterString = "[npattiid] = "+ b +""; * PP.EndUpdate(); * * using (ReportPrintTool printTool = new ReportPrintTool(PP)) * { * * printTool. showPreviewDialog(UserLookAndFeel.Default); * * }*/ } else { MessageBox.Show("can't generate patti on empty list"); dataGridView1.CurrentCell = dataGridView1.Rows[0].Cells[0]; } } else { MessageBox.Show("Enter farmer Id"); textBox1.Focus(); return; } }
private void button1_Click(object sender, EventArgs e) { if (comboBox1.Text == "") { MessageBox.Show("SELECT A CUSTOMER"); comboBox1.Select(); comboBox1.Focus(); return; } if (comboBox2.Text == "") { MessageBox.Show("SELECT PAY TYPE"); comboBox2.Select(); comboBox2.Focus(); return; } if (textBox4.Text == "") { MessageBox.Show("DISCOUNT CAN'T BE EMPTY"); textBox4.Select(); textBox4.Focus(); return; } if (textBox3.Text == "") { MessageBox.Show("AMOUNT CAN'T BE EMPTY"); textBox3.Select(); textBox3.Focus(); return; } if (comboBox2.Text == "CHEQUE" && textBox5.Text == "") { MessageBox.Show("ENTER CHEQUE NUMBER"); textBox5.Select(); textBox5.Focus(); return; } Temp1.Open(@"select * from payments", Program.DB, ADODB.CursorTypeEnum.adOpenStatic, ADODB.LockTypeEnum.adLockOptimistic); Temp1.AddNew(); Temp1.Fields["payID"].Value = Int64.Parse(textBox1.Text); Temp2.Open("SELECT * FROM customerdetails WHERE CName='" + comboBox1.Text + "'", Program.DB, ADODB.CursorTypeEnum.adOpenStatic, ADODB.LockTypeEnum.adLockOptimistic); Temp1.Fields["custID"].Value = Temp2.Fields["cID"].Value; if (comboBox2.Text == "CASH") { Temp1.Fields["paytype"].Value = "CASH"; } else { Temp1.Fields["paytype"].Value = "CHEQUE : " + textBox5.Text; } Temp1.Fields["payday"].Value = dateTimePicker1.Value.ToShortDateString(); Temp1.Fields["amount"].Value = Int64.Parse(textBox3.Text); Temp1.Fields["discount"].Value = Int64.Parse(textBox4.Text); Temp1.Fields["payamount"].Value = Int64.Parse(textBox4.Text) + Int64.Parse(textBox3.Text); Temp1.Update(); Temp1.Close(); Temp2.Fields["cbalance"].Value = Temp2.Fields["cbalance"].Value - (Int64.Parse(textBox4.Text) + Int64.Parse(textBox3.Text)); Temp2.Update(); Temp2.Close(); MessageBox.Show("PAYMENT SUCCESSFUL"); textBox4.Text = "0"; textBox3.Text = "0"; textBox2.Text = "0"; textBox5.Text = ""; comboBox1.SelectedIndex = -1; comboBox2.SelectedIndex = -1; textBox1.Text = (Int64.Parse(textBox1.Text) + 1).ToString(); }
protected void UpdateEntity(string Entity, string ID, string Field, string Value) { object oMissing = System.Reflection.Missing.Value; //get the DataService to get a connection string to the database Sage.Platform.Data.IDataService datasvc = Sage.Platform.Application.ApplicationContext.Current.Services.Get<Sage.Platform.Data.IDataService>(); ADODB.Connection objConn = new ADODB.Connection(); ADODB.Recordset objRS = new ADODB.Recordset(); string strSQL = "SELECT " + Field + " FROM " + Entity + " WHERE " +Entity + "ID = '" + ID + "'"; try { objConn.Open(datasvc.GetConnectionString(),null, null,0 ); objRS.CursorLocation = ADODB.CursorLocationEnum.adUseClient; objRS.CursorType = ADODB.CursorTypeEnum.adOpenDynamic; objRS.LockType = ADODB.LockTypeEnum.adLockOptimistic; objRS.Open(strSQL, objConn, ADODB.CursorTypeEnum.adOpenDynamic, ADODB.LockTypeEnum.adLockOptimistic,-1); if (!objRS.EOF) { //updating try { objRS.Fields[Field].Value = Value; } catch (Exception ex) { } } objRS.Update(oMissing ,oMissing ); objRS.Close(); } catch (Exception ex) { } }
/// <param name="file"></param> public static void WriteData(string file) { //Objekt aus XML-File erstellenaa XmlSerializer serializer = new XmlSerializer(typeof(results)); results resultingMessage = (results)serializer.Deserialize(new XmlTextReader(file)); //Recordset ADODB.Connection cn = new ADODB.Connection(); ADODB.Recordset rs = new ADODB.Recordset(); ADODB.Recordset rsDelete = new ADODB.Recordset(); string cnStr; //Connection string. cnStr = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=PPS-Datenbank.mdb"; //Provider=Microsoft.Jet.OLEDB.4.0;Data Source= try { cn.Open(cnStr); } catch (Exception test) { string dbFehler = Thread.CurrentThread.CurrentUICulture.Name == "de" ? "Datenbank konnte nicht geöffnet werden!" : "Database could not be loaded"; MessageBox.Show(dbFehler + " " + test); } //Überprüfung ob Periode drin try { rs.Open("Select * From warehousestock_article WHERE period = '" + resultingMessage.period + "'", cn, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockOptimistic, -1); if (!rs.EOF) { string periodeFehler = Thread.CurrentThread.CurrentUICulture.Name == "de" ? "Diese Periode wurde bereits importiert!" : "You can not import a period twice."; MessageBox.Show(periodeFehler); return; } } catch (Exception) { } finally { rs.Close(); } //Tabelle warehousestock_article try { rs.Open("Select * From warehousestock_article", cn, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockOptimistic, -1); foreach (resultsWarehousestockArticle myElement in resultingMessage.warehousestock.article) { rs.AddNew(); rs.Fields["period"].Value = resultingMessage.period; rs.Fields["id"].Value = myElement.id; rs.Fields["amount"].Value = myElement.amount; rs.Fields["startamount"].Value = myElement.startamount; rs.Fields["pct"].Value = myElement.pct; rs.Fields["price"].Value = myElement.price; rs.Fields["stockvalue"].Value = myElement.stockvalue; } rs.Update(); } catch (Exception) { } finally { rs.Close(); } //Tabelle warehousestock_totalvalue try { rs.Open("Select * From warehousestock_totalvalue", cn, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockOptimistic, -1); rs.AddNew(); rs.Fields["period"].Value = resultingMessage.period; rs.Fields["stockvalue"].Value = resultingMessage.warehousestock.totalstockvalue; rs.Update(); } catch (Exception) { } finally { rs.Close(); } //Tabelle inwardstockmovement try { rs.Open("Select * From inwardstockmovement", cn, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockOptimistic, -1); foreach (resultsOrder myElement in resultingMessage.inwardstockmovement) { rs.AddNew(); rs.Fields["period"].Value = resultingMessage.period; rs.Fields["id"].Value = myElement.id; rs.Fields["orderperiod"].Value = myElement.orderperiod; rs.Fields["mode"].Value = myElement.mode; rs.Fields["article"].Value = myElement.article; rs.Fields["amount"].Value = myElement.amount; rs.Fields["time"].Value = myElement.time; rs.Fields["materialcosts"].Value = myElement.materialcosts; rs.Fields["ordercosts"].Value = myElement.ordercosts; rs.Fields["entirecosts"].Value = myElement.entirecosts; rs.Fields["piececosts"].Value = myElement.piececosts; } rs.Update(); } catch (Exception) { } finally { rs.Close(); } //Tabelle futureinwardstockmovement try { rs.Open("Select * From futureinwardstockmovement", cn, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockOptimistic, -1); foreach (resultsOrder1 myElement in resultingMessage.futureinwardstockmovement) { rs.AddNew(); rs.Fields["period"].Value = resultingMessage.period; rs.Fields["id"].Value = myElement.id; rs.Fields["orderperiod"].Value = myElement.orderperiod; rs.Fields["mode"].Value = myElement.mode; rs.Fields["article"].Value = myElement.article; rs.Fields["amount"].Value = myElement.amount; } rs.Update(); } catch (Exception) { } finally { rs.Close(); } //Tabelle idletimecosts_workplace try { rs.Open("Select * From idletimecosts_workplace", cn, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockOptimistic, -1); foreach (resultsIdletimecostsWorkplace myElement in resultingMessage.idletimecosts.workplace) { rs.AddNew(); rs.Fields["period"].Value = resultingMessage.period; rs.Fields["id"].Value = myElement.id; rs.Fields["setupevents"].Value = myElement.setupevents; rs.Fields["idletime"].Value = myElement.idletime; rs.Fields["wageidletimecosts"].Value = myElement.wageidletimecosts; rs.Fields["wagecosts"].Value = myElement.wagecosts; rs.Fields["machineidletimecosts"].Value = myElement.machineidletimecosts; } rs.Update(); } catch (Exception) { } finally { rs.Close(); } //Tabelle idletimecosts_sum try { rs.Open("Select * From idletimecosts_sum", cn, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockOptimistic, -1); rs.AddNew(); rs.Fields["period"].Value = resultingMessage.period; rs.Fields["setupevents"].Value = resultingMessage.idletimecosts.sum.setupevents; rs.Fields["idletime"].Value = resultingMessage.idletimecosts.sum.idletime; rs.Fields["wageidletimecosts"].Value = resultingMessage.idletimecosts.sum.wageidletimecosts; rs.Fields["wagecosts"].Value = resultingMessage.idletimecosts.sum.wagecosts; rs.Fields["machineidletimecosts"].Value = resultingMessage.idletimecosts.sum.machineidletimecosts; rs.Update(); } catch (Exception) { } finally { rs.Close(); } //Tabelle waitinglistworkstations try { rs.Open("Select * From waitinglistworkstations", cn, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockOptimistic, -1); foreach (resultsWorkplace myElement in resultingMessage.waitinglistworkstations) { if (myElement.waitinglist == null) { rs.AddNew(); rs.Fields["period"].Value = resultingMessage.period; rs.Fields["id"].Value = myElement.id; rs.Fields["timeneed_sum"].Value = myElement.timeneed; } else { foreach (resultsWorkplaceWaitinglist myUnterelement in myElement.waitinglist) { rs.AddNew(); rs.Fields["period"].Value = resultingMessage.period; rs.Fields["id"].Value = myElement.id; rs.Fields["timeneed_sum"].Value = myElement.timeneed; rs.Fields["period_wp"].Value = myUnterelement.period; rs.Fields["order"].Value = myUnterelement.order; rs.Fields["firstbatch"].Value = myUnterelement.firstbatch; rs.Fields["lastbatch"].Value = myUnterelement.lastbatch; rs.Fields["item"].Value = myUnterelement.item; rs.Fields["amount"].Value = myUnterelement.amount; rs.Fields["timeneed"].Value = myUnterelement.timeneed; } } } rs.Update(); } catch (Exception) { } finally { rs.Close(); } //TODO WaitinglistStock try { rs.Open("Select * From waitingliststock", cn, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockOptimistic, -1); foreach (resultsMissingpart missingpart in resultingMessage.waitingliststock) { foreach (resultsMissingpartWaitinglist myWaitingListElement in missingpart.waitinglist) { rs.AddNew(); rs.Fields["missingpart"].Value = missingpart.id; rs.Fields["period"].Value = resultingMessage.period; rs.Fields["item"].Value = myWaitingListElement.item; rs.Fields["amount"].Value = myWaitingListElement.amount; rs.Fields["order"].Value = myWaitingListElement.order; rs.Fields["firstbatch"].Value = myWaitingListElement.firstbatch; rs.Fields["lastbatch"].Value = myWaitingListElement.lastbatch; } } rs.Update(); } catch (Exception) { } finally { rs.Close(); } //TODO orders inwrok mit liste? //Tabelle ordersinwork try { rs.Open("Select * From ordersinwork", cn, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockOptimistic, -1); foreach (resultsWorkplace1 myElement in resultingMessage.ordersinwork) { rs.AddNew(); rs.Fields["period"].Value = resultingMessage.period; rs.Fields["id"].Value = myElement.id; rs.Fields["period_oiw"].Value = myElement.period; rs.Fields["order"].Value = myElement.order; rs.Fields["batch"].Value = myElement.batch; rs.Fields["item"].Value = myElement.item; rs.Fields["amount"].Value = myElement.amount; rs.Fields["timeneed"].Value = myElement.timeneed; } rs.Update(); } catch (Exception) { } finally { rs.Close(); } //Tabelle completedorders try { rs.Open("Select * From completedorders", cn, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockOptimistic, -1); foreach (resultsOrder2 myElement in resultingMessage.completedorders) { foreach (resultsOrderBatch myUnterelement in myElement.batch) { rs.AddNew(); rs.Fields["period"].Value = resultingMessage.period; rs.Fields["o_period"].Value = myElement.period; rs.Fields["o_id"].Value = myElement.id; rs.Fields["o_item"].Value = myElement.item; rs.Fields["o_quantity"].Value = myElement.quantity; rs.Fields["o_cost"].Value = myElement.cost; rs.Fields["o_averageunitcosts"].Value = myElement.averageunitcosts; rs.Fields["b_id"].Value = myUnterelement.id; rs.Fields["b_amount"].Value = myUnterelement.amount; rs.Fields["b_cycletime"].Value = myUnterelement.cycletime; rs.Fields["b_cost"].Value = myUnterelement.cost; } } rs.Update(); } catch (Exception) { } finally { rs.Close(); } //Tabelle cycletimes try { rs.Open("Select * From cycletimes", cn, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockOptimistic, -1); rs.AddNew(); rs.Fields["period"].Value = resultingMessage.period; rs.Fields["startedorders"].Value = resultingMessage.cycletimes.startedorders; rs.Fields["waitingorders"].Value = resultingMessage.cycletimes.waitingorders; rs.Update(); } catch (Exception) { } finally { rs.Close(); } //Tabelle cycletimes_order try { rs.Open("Select * From cycletimes_order", cn, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockOptimistic, -1); foreach (resultsCycletimesOrder myElement in resultingMessage.cycletimes.order) { rs.AddNew(); rs.Fields["period"].Value = resultingMessage.period; rs.Fields["id"].Value = myElement.id; rs.Fields["period_order"].Value = myElement.period; rs.Fields["starttime"].Value = myElement.starttime; rs.Fields["finishtime"].Value = myElement.finishtime; rs.Fields["cycletimemin"].Value = myElement.cycletimemin; rs.Fields["cycletimefactor"].Value = myElement.cycletimefactor; } rs.Update(); } catch (Exception) { } finally { rs.Close(); } //Tabelle general try { rs.Open("Select * From tbl_general", cn, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockOptimistic, -1); rs.AddNew(); rs.Fields["period"].Value = resultingMessage.period; rs.Fields["capacity_current"].Value = resultingMessage.result.general.capacity.current; rs.Fields["capacity_average"].Value = resultingMessage.result.general.capacity.average; rs.Fields["capacity_all"].Value = resultingMessage.result.general.capacity.all; rs.Fields["possiblecapacity_current"].Value = resultingMessage.result.general.possiblecapacity.current; rs.Fields["possiblecapacity_average"].Value = resultingMessage.result.general.possiblecapacity.average; rs.Fields["possiblecapacity_all"].Value = resultingMessage.result.general.possiblecapacity.all; rs.Fields["relpossiblenormalcapacity_current"].Value = resultingMessage.result.general.relpossiblenormalcapacity.current; rs.Fields["relpossiblenormalcapacity_average"].Value = resultingMessage.result.general.relpossiblenormalcapacity.average; rs.Fields["relpossiblenormalcapacity_all"].Value = resultingMessage.result.general.relpossiblenormalcapacity.all; rs.Fields["productivetime_current"].Value = resultingMessage.result.general.productivetime.current; rs.Fields["productivetime_average"].Value = resultingMessage.result.general.productivetime.average; rs.Fields["productivetime_all"].Value = resultingMessage.result.general.productivetime.all; rs.Fields["effiency_current"].Value = resultingMessage.result.general.effiency.current; rs.Fields["effiency_average"].Value = resultingMessage.result.general.effiency.average; rs.Fields["effiency_all"].Value = resultingMessage.result.general.effiency.all; rs.Fields["sellwish_current"].Value = resultingMessage.result.general.sellwish.current; rs.Fields["sellwish_average"].Value = resultingMessage.result.general.sellwish.average; rs.Fields["sellwish_all"].Value = resultingMessage.result.general.sellwish.all; rs.Fields["salesquantity_current"].Value = resultingMessage.result.general.salesquantity.current; rs.Fields["salesquantity_average"].Value = resultingMessage.result.general.salesquantity.average; rs.Fields["salesquantity_all"].Value = resultingMessage.result.general.salesquantity.all; rs.Fields["deliveryreliability_current"].Value = resultingMessage.result.general.deliveryreliability.current; rs.Fields["deliveryreliability_average"].Value = resultingMessage.result.general.deliveryreliability.average; rs.Fields["deliveryreliability_all"].Value = resultingMessage.result.general.deliveryreliability.all; rs.Fields["idletime_current"].Value = resultingMessage.result.general.idletime.current; rs.Fields["idletime_average"].Value = resultingMessage.result.general.idletime.average; rs.Fields["idletime_all"].Value = resultingMessage.result.general.idletime.all; rs.Fields["idletimecosts_current"].Value = resultingMessage.result.general.idletimecosts.current; rs.Fields["idletimecosts_average"].Value = resultingMessage.result.general.idletimecosts.average; rs.Fields["idletimecosts_all"].Value = resultingMessage.result.general.idletimecosts.all; rs.Fields["storevalue_current"].Value = resultingMessage.result.general.storevalue.current; rs.Fields["storevalue_average"].Value = resultingMessage.result.general.storevalue.average; rs.Fields["storevalue_all"].Value = resultingMessage.result.general.storevalue.all; rs.Fields["storagecosts_current"].Value = resultingMessage.result.general.storagecosts.current; rs.Fields["storagecosts_average"].Value = resultingMessage.result.general.storagecosts.average; rs.Fields["storagecosts_all"].Value = resultingMessage.result.general.storagecosts.all; rs.Update(); } catch (Exception) { } finally { rs.Close(); } //Tabelle normalsale try { rs.Open("Select * From normalsale", cn, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockOptimistic, -1); rs.AddNew(); rs.Fields["period"].Value = resultingMessage.period; rs.Fields["salesprice_current"].Value = resultingMessage.result.normalsale.salesprice.current; rs.Fields["salesprice_average"].Value = resultingMessage.result.normalsale.salesprice.average; rs.Fields["salesprice_all"].Value = resultingMessage.result.normalsale.salesprice.all; rs.Fields["profit_current"].Value = resultingMessage.result.normalsale.profit.current; rs.Fields["profit_average"].Value = resultingMessage.result.normalsale.profit.average; rs.Fields["profit_all"].Value = resultingMessage.result.normalsale.profit.all; rs.Fields["profitperunit_current"].Value = resultingMessage.result.normalsale.profitperunit.current; rs.Fields["profitperunit_average"].Value = resultingMessage.result.normalsale.profitperunit.average; rs.Fields["profitperunit_all"].Value = resultingMessage.result.normalsale.profitperunit.all; rs.Update(); } catch (Exception) { } finally { rs.Close(); } //Tabelle directsale try { rs.Open("Select * From directsale", cn, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockOptimistic, -1); rs.AddNew(); rs.Fields["period"].Value = resultingMessage.period; rs.Fields["profit_current"].Value = resultingMessage.result.directsale.profit.current; rs.Fields["profit_average"].Value = resultingMessage.result.directsale.profit.average; rs.Fields["profit_all"].Value = resultingMessage.result.directsale.profit.all; rs.Fields["contractpenalty_current"].Value = resultingMessage.result.directsale.contractpenalty.current; rs.Fields["contractpenalty_average"].Value = resultingMessage.result.directsale.contractpenalty.average; rs.Fields["contractpenalty_all"].Value = resultingMessage.result.directsale.contractpenalty.all; rs.Update(); } catch (Exception) { } finally { rs.Close(); } //Tabelle marketplacesale try { rs.Open("Select * From marketplacesale", cn, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockOptimistic, -1); rs.AddNew(); rs.Fields["period"].Value = resultingMessage.period; rs.Fields["profit_current"].Value = resultingMessage.result.marketplacesale.profit.current; rs.Fields["profit_average"].Value = resultingMessage.result.marketplacesale.profit.average; rs.Fields["profit_all"].Value = resultingMessage.result.marketplacesale.profit.all; rs.Update(); } catch (Exception) { } finally { rs.Close(); } //Tabelle summary try { rs.Open("Select * From summary", cn, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockOptimistic, -1); rs.AddNew(); rs.Fields["period"].Value = resultingMessage.period; rs.Fields["profit_current"].Value = resultingMessage.result.summary.profit.current; rs.Fields["profit_average"].Value = resultingMessage.result.summary.profit.average; rs.Fields["profit_all"].Value = resultingMessage.result.summary.profit.all; rs.Update(); } catch (Exception) { } finally { rs.Close(); } /// <summary> /// Überflüssige Werte aus der DB löschen, wenn Initialer Stand hochgeladen wird /// </summary> try { rs.Open("Select distinct period from warehousestock_article ORDER BY period Desc", cn, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockOptimistic, -1); int periode = Convert.ToInt32(rs.Fields["period"].Value); if (periode == 0) { rsDelete.Open("Delete From inwardstockmovement", cn, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockOptimistic, -1); rsDelete.Open("Delete From futureinwardstockmovement Where period = '0'", cn, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockOptimistic, -1); //rsDelete.Open("Delete From idletimecosts", cn, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockOptimistic, -1); rsDelete.Open("Delete From idletimecosts_workplace where period ='0'", cn, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockOptimistic, -1); rsDelete.Open("Delete From idletimecosts_sum where period = '0'", cn, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockOptimistic, -1); rsDelete.Open("Delete From waitinglistworkstations where period = '0'", cn, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockOptimistic, -1); rsDelete.Open("Delete From waitingliststock where period = 0", cn, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockOptimistic, -1); rsDelete.Open("Delete From ordersinwork where period = '0'", cn, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockOptimistic, -1); rsDelete.Open("Delete From completedorders where period = '0'", cn, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockOptimistic, -1); rsDelete.Open("Delete From cycletimes where period = '0'", cn, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockOptimistic, -1); rsDelete.Open("Delete From cycletimes_order where period = '0'", cn, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockOptimistic, -1); rsDelete.Open("Delete From tbl_general where period = '0'", cn, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockOptimistic, -1); rsDelete.Open("Delete From normalsale where period = '0'", cn, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockOptimistic, -1); rsDelete.Open("Delete From directsale where period = '0'", cn, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockOptimistic, -1); rsDelete.Open("Delete From marketplacesale where period = '0'", cn, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockOptimistic, -1); rsDelete.Open("Delete From summary where period = '0'", cn, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockOptimistic, -1); } } catch (Exception test) { MessageBox.Show(test.Message); } finally { rs.Close(); } MessageBox.Show("XML-File importiert"); cn.Close(); }
private void btnsave_Click(object sender, EventArgs e) { ADODB.Recordset tmp = new ADODB.Recordset(); try { if (!Program.session_valid(dt1.Value.Date.ToString("yyyy-MM-dd"))) { MessageBox.Show("There is no valid Finance Session Found, Please check the Entry Date or Contact Admin ", "Invalid Transaction Date ", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } if (ADOconn.State == 0) { ADOconn.Open("Provider=SQLOLEDB;Initial Catalog= " + decoder.InitialCatalog + ";Data Source=" + decoder.DataSource + ";", decoder.UserID, decoder.Password, 0); } ADODB.Recordset rec = new ADODB.Recordset(); Conn.Close(); // Conn.Open(); bool isempty; isempty = false; if (isedit) { if (txtpriv.Text.Substring(1, 1) == "0") { MessageBox.Show("Insufficient Priveleges ", "Insufficient Priveleges "); return; } } else { if (txtpriv.Text.Substring(0, 1) == "0") { MessageBox.Show("Insufficient Priveleges ", "Insufficient Priveleges "); return; } } //if (isempty) //{ // MessageBox.Show("Entry Not Completed, Please fill all Yellow Marked fileds!!", "Invalid Entry"); // return; //} try { // ADOconn.BeginTrans(); // if (!isedit) // { // if (txtismanual.Text == "0") // { // gen_accno(); // tmp = new ADODB.Recordset(); // sql = "update ACC_TYPE SET CUR_NO = CUR_NO+1 WHERE ACC_TYPE_CODE=" + cmbtype.SelectedValue; // tmp.Open(sql, ADOconn, ADODB.CursorTypeEnum.adOpenDynamic, ADODB.LockTypeEnum.adLockOptimistic, -1); // } // } if (txtsalacno.Text == "") { MessageBox.Show("Invalid Salary Account Number, Please Enter a Valid Number", "Invalid Entry"); return; } if (cmbmonth.SelectedIndex < 0) { MessageBox.Show("Invalid Salary Month, Please Select a Valid Month", "Invalid Entry"); return; } if (txtnet.Text.Trim() == "") { txtnet.Text = "0"; } // //if (txtvalue.Text.Trim() == "") txtvalue.Text = "0"; isini = true; if (txtbasic.Text == "") { txtbasic.Text = "0"; } if (txtempid.Text == "") { txtempid.Text = "0"; } if (txthousing.Text == "") { txthousing.Text = "0"; } if (txttransport.Text == "") { txttransport.Text = "0"; } if (txtother.Text == "") { txtother.Text = "0"; } if (txtdeduction.Text == "") { txtdeduction.Text = "0"; } if (txtloan.Text == "") { txtloan.Text = "0"; } if (txtcontractno.Text == "") { txtcontractno.Text = "0"; } if (txtworkeddays.Text == "") { txtworkeddays.Text = "0"; } if (txtnet.Text == "") { txtnet.Text = "0"; } if (txtsalacno.Text == "") { txtsalacno.Text = "0"; } if (txtempid.Text == "") { txtempid.Text = "0"; } if (txtpaidamt.Text == "") { txtpaidamt.Text = "0"; } if (txtbrncode.Text == "") { txtbrncode.Text = Gvar.brn_code.ToString(); } if (txtcontractno.Text == "0") { MessageBox.Show("Invalid Contract Numebr, Please check and Try Again", "Invalid Entry"); return; } if (Convert.ToDecimal(txtpaidamt.Text) > Convert.ToDecimal(txtnet.Text)) { MessageBox.Show("There is already a higher Paid amount found, Please check and Try Again", "Invalid Entry"); return; } isini = false; find_total(); //rec.Fields["veh_no"].Value = Convert.ToDouble(txtvehno.Text.Trim()); ADOconn.BeginTrans(); int TRN_BY = 13; sql = "select * from TRN_accounts where trn_NO = '" + txtactrnno.Text.Trim() + "' AND TRN_BY = 13 and Sno = 1"; rec = new ADODB.Recordset(); rec.Open(sql, ADOconn, ADODB.CursorTypeEnum.adOpenStatic, ADODB.LockTypeEnum.adLockOptimistic, -1); long trnno = 0; long trnno2 = 0; if (rec.RecordCount == 0) { rec.AddNew(); tmp = new ADODB.Recordset(); sql = "SELECT * FROM TRNNO"; tmp.Open(sql, ADOconn, ADODB.CursorTypeEnum.adOpenDynamic, ADODB.LockTypeEnum.adLockOptimistic, -1); //if (tmp.Fields[0].Value) // txttrn.Text="1"; //else if (tmp.Fields[0].Value == DBNull.Value) { trnno = 1; } else { trnno = Convert.ToInt64(tmp.Fields[0].Value.ToString()); trnno2 = trnno + 1; } rec.Fields["trn_no"].Value = trnno; rec.Fields["trn_no2"].Value = trnno + 1; } trnno = Convert.ToInt64(rec.Fields["trn_no"].Value); double amt = Convert.ToDouble(txtnet.Text); long doc_no = -1 * trnno; string DR_CR = "D"; string DR_CR1 = "C"; rec.Fields["acc_no"].Value = txtempacno.Text; rec.Fields["EntrY_no"].Value = 0; double rate = 1; rec.Fields["PAY_AMOUNT"].Value = Math.Abs(amt * rate); rec.Fields["F_PAY_AMOUNT"].Value = Math.Abs(amt); rec.Fields["F_RATE"].Value = 1; rec.Fields["TRN_BY"].Value = TRN_BY; rec.Fields["DR_CR"].Value = DR_CR; rec.Fields["user_ID"].Value = Gvar.Userid; rec.Fields["PAYBY"].Value = txtsalacno.Text; //rec.Fields["RQTY"].Value = 0; rec.Fields["SNO"].Value = 1; // rec.Fields["FRACTION"].Value = dgv1["fraction", i].Value; rec.Fields["NARRATION"].Value = "Salary Process of " + cmbmonth.Text; rec.Fields["Voucher_No"].Value = 0; rec.Fields["cost_code"].Value = 0; rec.Fields["dept_code"].Value = 0; rec.Fields["pay_date"].Value = dt1.Value; rec.Fields["doc_no"].Value = doc_no; rec.Fields["NYEAR"].Value = dt1.Value.Year; rec.Fields["brn_code"].Value = Gvar.brn_code; rec.Fields["currency"].Value = "SR"; rec.Fields["brn_code"].Value = txtbrncode.Text; rec.Fields["trn_type"].Value = TRN_BY; rec.Update(); sql = "select * from TRN_accounts where trn_NO2 = '" + txtactrnno.Text.Trim() + "' AND TRN_BY = 13 and Sno = 2"; rec = new ADODB.Recordset(); rec.Open(sql, ADOconn, ADODB.CursorTypeEnum.adOpenStatic, ADODB.LockTypeEnum.adLockOptimistic, -1); if (rec.RecordCount == 0) { rec.AddNew(); tmp = new ADODB.Recordset(); sql = "SELECT * FROM TRNNO"; tmp.Open(sql, ADOconn, ADODB.CursorTypeEnum.adOpenDynamic, ADODB.LockTypeEnum.adLockOptimistic, -1); //if (tmp.Fields[0].Value) // txttrn.Text="1"; //else if (tmp.Fields[0].Value == DBNull.Value) { trnno2 = 1; } else { trnno2 = Convert.ToInt64(tmp.Fields[0].Value.ToString()); } rec.Fields["trn_no"].Value = trnno2; rec.Fields["trn_no2"].Value = trnno; } trnno2 = Convert.ToInt64(rec.Fields["trn_no"].Value); rec.Fields["acc_no"].Value = txtsalacno.Text; rec.Fields["EntrY_no"].Value = 0; rec.Fields["PAY_AMOUNT"].Value = Math.Abs(amt * rate); rec.Fields["F_PAY_AMOUNT"].Value = Math.Abs(amt); rec.Fields["F_RATE"].Value = 1; rec.Fields["TRN_BY"].Value = TRN_BY; rec.Fields["DR_CR"].Value = DR_CR1; rec.Fields["user_ID"].Value = Gvar.Userid; rec.Fields["PAYBY"].Value = txtempacno.Text; //rec.Fields["RQTY"].Value = 0; rec.Fields["SNO"].Value = 2; // rec.Fields["FRACTION"].Value = dgv1["fraction", i].Value; rec.Fields["NARRATION"].Value = "Salary Process of " + cmbmonth.Text + " for " + lblname.Text; rec.Fields["Voucher_No"].Value = 0; rec.Fields["cost_code"].Value = 0; rec.Fields["dept_code"].Value = 0; rec.Fields["pay_date"].Value = dt1.Value; rec.Fields["doc_no"].Value = doc_no; rec.Fields["NYEAR"].Value = dt1.Value.Year; rec.Fields["brn_code"].Value = txtbrncode.Text; rec.Fields["trn_type"].Value = TRN_BY; rec.Fields["currency"].Value = "SR"; rec.Update(); rec = new ADODB.Recordset(); sql = "SELECT * FROM salary_det where salary_month = '" + cmbmonth.Text + "' and emp_id =" + txtempid.Text; // sql = "SELECT * FROM Accounts where Acc_no ='" + txtaccno.Text.Trim() + "'"; rec.Open(sql, ADOconn, ADODB.CursorTypeEnum.adOpenStatic, ADODB.LockTypeEnum.adLockOptimistic, -1); if (rec.RecordCount == 0) { rec.AddNew(); } rec.Fields["EMP_ID"].Value = txtempid.Text.Trim(); rec.Fields["SALARY_MONTH"].Value = cmbmonth.Text.Trim(); rec.Fields["EFFECT_DATE"].Value = dt1.Value.Date.ToString("yyyy-MM-dd"); rec.Fields["FULLNAME"].Value = lblname.Text; rec.Fields["BASIC"].Value = txtbasic.Text; rec.Fields["HOUSING"].Value = txthousing.Text.Trim(); rec.Fields["TRANSPORTATION"].Value = txttransport.Text.Trim(); rec.Fields["OTHER"].Value = txtother.Text.Trim(); rec.Fields["DEDUCTION"].Value = txtdeduction.Text.Trim(); rec.Fields["LOAN_AMT"].Value = txtloan.Text.Trim(); rec.Fields["REMARKS"].Value = txtremarks.Text.Trim(); rec.Fields["NET_AMOUNT"].Value = txtnet.Text.Trim(); rec.Fields["SAL_ACNO"].Value = txtsalacno.Text.Trim(); rec.Fields["EMP_ACNO"].Value = txtempacno.Text.Trim(); rec.Fields["worked_days"].Value = txtworkeddays.Text.Trim(); rec.Fields["CONTRACT_ID"].Value = txtcontractno.Text.Trim(); rec.Fields["NYEAR"].Value = dt1.Value.Year.ToString(); rec.Fields["TRN_NO1"].Value = trnno; rec.Fields["TRN_NO2"].Value = trnno2; rec.Fields["EMP_BraNCH"].Value = txtbrncode.Text.Trim(); rec.Update(); ADOconn.CommitTrans(); populate_empdet(); //DataGridViewRow row = dgv1.CurrentRow; //if (txtempid.Text.ToString() == dgv1[1, dgv1.CurrentRow.Index].Value.ToString()) //{ // dgv1.Rows.Remove(row); //} isedit = true; MessageBox.Show("Successfully Saved"); } catch (Exception ex) { ADOconn.RollbackTrans(); MessageBox.Show(ex.Message); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }