//Startup checker public static bool StartupDataBaseChecker(DBQueres DataWriter, DatabaseRead DataReader, MysqlRowCounter TableRowCounter) { try { DataTable errorCodeDataTable = new DataTable(); errorCodeDataTable = DataReader(string.Format("SELECT * FROM {0} WHERE {1}={2} AND {3}='Profit'", thisDataSet.ThisTables[16][0], thisDataSet.ThisColumn[0][0],AccountingVariables.PETUNIA_DATE, thisDataSet.ThisColumn[1][0])); if (errorCodeDataTable.Rows.Count.Equals(0)) { DataWriter(string.Format("INSERT INRO {0} VALUES('{1}','Profit',0,0,0,0", thisDataSet.ThisTables[16][0], AccountingVariables.PETUNIA_DATE)); } errorCodeDataTable.Clear(); errorCodeDataTable = DataReader(string.Format("SELECT * FROM {0} WHERE {1}={2} AND {3}='Salary'", thisDataSet.ThisTables[16][0], thisDataSet.ThisColumn[0][0], AccountingVariables.PETUNIA_DATE, thisDataSet.ThisColumn[1][0])); if (errorCodeDataTable.Rows.Count.Equals(0)) { DataWriter(string.Format("INSERT INRO {0} VALUES('{1}','Salary',0,0,0,0", thisDataSet.ThisTables[16][0], AccountingVariables.PETUNIA_DATE)); } errorCodeDataTable.Clear(); errorCodeDataTable = DataReader(string.Format("SELECT * FROM {0} WHERE {1}={2} AND {3}='Rent'", thisDataSet.ThisTables[16][0], thisDataSet.ThisColumn[0][0], AccountingVariables.PETUNIA_DATE, thisDataSet.ThisColumn[1][0])); if (errorCodeDataTable.Rows.Count.Equals(0)) { DataWriter(string.Format("INSERT INRO {0} VALUES('{1}','Rent',0,0,0,0", thisDataSet.ThisTables[16][0], AccountingVariables.PETUNIA_DATE)); } errorCodeDataTable.Clear(); errorCodeDataTable = DataReader(string.Format("SELECT * FROM {0} WHERE {1}={2} AND {3}='OfficeExpance'", thisDataSet.ThisTables[16][0], thisDataSet.ThisColumn[0][0], AccountingVariables.PETUNIA_DATE, thisDataSet.ThisColumn[1][0])); if (errorCodeDataTable.Rows.Count.Equals(0)) { DataWriter(string.Format("INSERT INRO {0} VALUES('{1}','OfficeExpance',0,0,0,0", thisDataSet.ThisTables[16][0], AccountingVariables.PETUNIA_DATE)); } errorCodeDataTable.Clear(); errorCodeDataTable = DataReader(string.Format("SELECT * FROM {0} WHERE {1}='{2}' AND {3}='Stationary'", thisDataSet.ThisTables[16][0], thisDataSet.ThisColumn[0][0], AccountingVariables.PETUNIA_DATE, thisDataSet.ThisColumn[1][0])); if (errorCodeDataTable.Rows.Count.Equals(0)) { DataWriter(string.Format("INSERT INRO {0} VALUES('{1}','Stationary',0,0,0,0", thisDataSet.ThisTables[16][0], AccountingVariables.PETUNIA_DATE)); } errorCodeDataTable.Clear(); errorCodeDataTable = DataReader(string.Format("SELECT * FROM {0} WHERE {1}={2} AND {3}='Others'", thisDataSet.ThisTables[16][0], thisDataSet.ThisColumn[0][0], AccountingVariables.PETUNIA_DATE, thisDataSet.ThisColumn[1][0])); if (errorCodeDataTable.Rows.Count.Equals(0)) { DataWriter(string.Format("INSERT INRO {0} VALUES('{1}','Others',0,0,0,0", thisDataSet.ThisTables[16][0], AccountingVariables.PETUNIA_DATE)); } errorCodeDataTable.Clear(); errorCodeDataTable = DataReader(string.Format("SELECT * FROM {0} WHERE {1}='{2}'", thisDataSet.ThisTables[6][0], thisDataSet.ThisColumn[0][0], AccountingVariables.PETUNIA_DATE)); if (errorCodeDataTable.Rows.Count.Equals(0)) { DataWriter(string.Format("INSERT INTO {0} VALUES ('{1}',0,0,0,0,0)", thisDataSet.ThisTables[6][0], AccountingVariables.PETUNIA_DATE)); } return true; } catch (Exception) { return false; } }
//Trading Account//Need To Call private bool TradingAccount(DataTable transfarData, TransactionType transactionType, DatabaseRead DataReder, DBQueres DataWriter, MysqlRowCounter TableRowCounter) { try { DataRow transfarDataRow = transfarData.Rows[0]; if (Convert.ToDouble(transfarDataRow[2])>Convert.ToDouble(transfarDataRow[3])) { double profit = Convert.ToDouble(transfarDataRow[2]) - Convert.ToDouble(transfarDataRow[3]); DataWriter(string.Format("INSERT INTO {0} VALUES('{1}','{2}',{3},{4},0,{5},0,0)", thisDataSet.ThisTables[25][0], transfarDataRow[0], transfarDataRow[1], transfarDataRow[2], transfarDataRow[3], profit)); //Column : 0 Petunia_Date return DataWriter(string.Format("UPDATE {0} SET {1}={1}+{2} WHERE {3}='{4}' AND {5}='Profit'", thisDataSet.ThisTables[16][0], thisDataSet.ThisColumn[7][0], profit, thisDataSet.ThisColumn[0][0], transfarDataRow[0], thisDataSet.ThisColumn[1][0])); //Column : 1 Description } //Column : 2 Purchase_Rate else if (Convert.ToDouble(transfarDataRow[2]) < Convert.ToDouble(transfarDataRow[3])) //Column : 3 Sales_Rate { double profit = Convert.ToDouble(transfarDataRow[3]) - Convert.ToDouble(transfarDataRow[2]); DataWriter(string.Format("INSERT INTO {0} VALUES('{1}','{2}',{3},{4},{5},0,0,0)", thisDataSet.ThisTables[25][0], transfarDataRow[0], transfarDataRow[1], transfarDataRow[2], transfarDataRow[3], profit)); return DataWriter(string.Format("UPDATE {0} SET {1}={1}+{2} WHERE {3}='{4}' AND {5}='Profit'", thisDataSet.ThisTables[16][0], thisDataSet.ThisColumn[6][0], profit, thisDataSet.ThisColumn[0][0], transfarDataRow[0], thisDataSet.ThisColumn[1][0])); } else if (Convert.ToDouble(transfarDataRow[2]).Equals(Convert.ToDouble(transfarDataRow[3]))) { DataWriter(string.Format("INSERT INTO {0} VALUES('{1}','{2}',{3},{4},0,0,0,0)", thisDataSet.ThisTables[25][0], transfarDataRow[0], transfarDataRow[1], transfarDataRow[2], transfarDataRow[3])); return DataWriter(string.Format("UPDATE {0} SET {1}={1}+0 WHERE {3}='{4}' AND {5}='Profit'", thisDataSet.ThisTables[16][0], thisDataSet.ThisColumn[6][0], thisDataSet.ThisColumn[0][0], transfarDataRow[0], thisDataSet.ThisColumn[1][0])); } else { return false; } } catch (Exception) { return false; } }
//Return Last Rows Value private double LastRowVaue(string columnName, string tableName,DatabaseRead DataReader,MysqlRowCounter Tablerowcount) { DataTable getDataTable = new DataTable(); decimal rownumbers = Tablerowcount(tableName); if (rownumbers.Equals(0)) { rownumbers = 1; } getDataTable= DataReader(string.Format("SELECT {0} FROM {1} LIMIT {2},{3}",columnName,tableName,rownumbers-1,rownumbers)); if (getDataTable.Rows.Count > 0) { return Convert.ToDouble(getDataTable.Rows[0][getDataTable.Columns[0].ToString()]); } else { return 0.00; } }
//Update Stock private bool StockOperation(DataTable transfarData, ProductOperationType operationType, DBQueres DataWriter,DatabaseRead DataReder,MysqlRowCounter TableRowCounter) { try { DataRow tranfarDataRow=transfarData.Rows[0]; if (operationType.Equals(ProductOperationType.Purchase)) { //Column :0 Petunia_Date DataWriter(string.Format("INSERT INTO {0} VALUES ('{1}','{2}','{3}','{4}',{5},{6},'{7}',{8},{9},0,{10}+{9},0)", thisDataSet.ThisTables[23][0], tranfarDataRow[0],tranfarDataRow[8], tranfarDataRow[1], tranfarDataRow[2], tranfarDataRow[3], tranfarDataRow[4], tranfarDataRow[5], tranfarDataRow[6],tranfarDataRow[7], LastRowVaue(thisDataSet.ThisColumn[8][0].ToString(), thisDataSet.ThisTables[23][0].ToString(), new DatabaseRead(DataReder), new MysqlRowCounter(TableRowCounter))));//Column :1 Description return DataWriter(string.Format("UPDATE {0} SET {1}={1}+{2}, {3}={3}+{4},{5}={3}/{1} WHERE {6}='{7}'", thisDataSet.ThisTables[22][0], thisDataSet.ThisColumn[2][0], tranfarDataRow[3], thisDataSet.ThisColumn[3][0].ToString(), tranfarDataRow[4], thisDataSet.ThisColumn[4][0].ToString(), thisDataSet.ThisColumn[10][0].ToString(),tranfarDataRow[8])); //Column :2 Particulars } //Column :3 Quantity else if (operationType.Equals(ProductOperationType.Sales)) //Column :4 Rate//Amount { //Column :5 AVERAGE_RATE DataWriter(string.Format("INSERT INTO {0} VALUES ('{1}','{2}','{3}','{4}',{5},{6},{7},{8},0,{9},{10}-{9},0)", thisDataSet.ThisTables[23][0], tranfarDataRow[0], tranfarDataRow[8], tranfarDataRow[1], tranfarDataRow[2], tranfarDataRow[3], tranfarDataRow[4], "0.00", tranfarDataRow[6], tranfarDataRow[7], LastRowVaue(thisDataSet.ThisColumn[8][0].ToString(), thisDataSet.ThisTables[23][0].ToString(), new DatabaseRead(DataReder), new MysqlRowCounter(TableRowCounter))));//Column :6 INVOICE_NUMBER return DataWriter(string.Format("UPDATE {0} SET {1}={1}-{2}, {3}={3}-{4},{5}={3}/{1} WHERE {6}='{7}'", thisDataSet.ThisTables[22][0], thisDataSet.ThisColumn[2][0], tranfarDataRow[3], thisDataSet.ThisColumn[3][0].ToString(), tranfarDataRow[4], thisDataSet.ThisColumn[4][0].ToString(), thisDataSet.ThisColumn[10][0].ToString(), tranfarDataRow[8])); //Column :7 Debt_Tk or Credit_tk } //Column :8 Product_ID else { return false; } } catch { return false; } }
//Insert into Bank private bool BankAccount(DataTable transfarData,TransactionType transactionType,DatabaseRead DataReder, DBQueres DataWriter, MysqlRowCounter TableRowCounter) { try { DataRow transfarDataRow = transfarData.Rows[0]; if (transactionType.Equals(TransactionType.debt)) //Max Column 3 { //Column : PETUNIA_DATE return DataWriter(string.Format("INSERT INTO {0} VALUES('{1}','{2}',0,{3},{4}-{3},0)", thisDataSet.ThisTables[1][0].ToString(), transfarDataRow[0], transfarDataRow[1], transfarDataRow[2], LastRowVaue(thisDataSet.ThisColumn[9][0].ToString(), thisDataSet.ThisTables[1][0].ToString(), new DatabaseRead(DataReder), new MysqlRowCounter(TableRowCounter)))); //Column : DESCRIPTION } //Column : DEBIT_TK or CREDIT_TK else if (transactionType.Equals(TransactionType.Credit)) { return DataWriter(string.Format("INSERT INTO {0} VALUES('{1}','{2}',{3},0,{4}+{3},0)", thisDataSet.ThisTables[1][0].ToString(), transfarDataRow[0], transfarDataRow[1], transfarDataRow[2], LastRowVaue(thisDataSet.ThisColumn[9][0].ToString(), thisDataSet.ThisTables[1][0].ToString(), new DatabaseRead(DataReder), new MysqlRowCounter(TableRowCounter)))); } else { return false; } } catch (Exception) { return false; } }
//Column : 0 Petunia_Date //Insert & Update Cash debt or credits private bool CashOperation(DataTable transfarData, TransactionType transactionType, DBQueres DataWriter, DatabaseRead DataReader, MysqlRowCounter TableRowCounter) { //Column : 1 Description try //Column : 2 Credit Taka or Debt Taka { //Column : DataRow transfarDataRow = transfarData.Rows[0]; if (transactionType.Equals(TransactionType.debt)) { DataWriter(string.Format("INSERT INTO {0} VALUES ('{1}','{2}',{3},0,{4}+{3},0)", thisDataSet.ThisTables[2][0].ToString(), transfarDataRow[0], transfarDataRow[1], transfarDataRow[2], LastRowVaue(thisDataSet.ThisColumn[8][0].ToString(), thisDataSet.ThisTables[2][0].ToString(), new DatabaseRead(DataReader), new MysqlRowCounter(TableRowCounter)))); return DataWriter(string.Format("UPDATE {0} SET {1}={1}+{2}, {3}={3}+{2} WHERE {4}='{5}'", thisDataSet.ThisTables[6][0].ToString(), thisDataSet.ThisColumn[6][0], transfarDataRow[2], thisDataSet.ThisColumn[8][0], thisDataSet.ThisColumn[0][0].ToString(), transfarDataRow[0])); } else if(transactionType.Equals(TransactionType.Credit)) { DataWriter(string.Format("INSERT INTO {0} VALUES ('{1}','{2}',0,{3},{4}-{3},0)", thisDataSet.ThisTables[2][0].ToString(), transfarDataRow[0], transfarDataRow[1], transfarDataRow[2], LastRowVaue(thisDataSet.ThisColumn[8][0].ToString(), thisDataSet.ThisTables[2][0].ToString(), new DatabaseRead(DataReader), new MysqlRowCounter(TableRowCounter)))); return DataWriter(string.Format("UPDATE {0} SET {1}={1}-{2}, {3}={3}-{2} WHERE {4}='{5}'", thisDataSet.ThisTables[6][0].ToString(), thisDataSet.ThisColumn[7][0], transfarDataRow[2], thisDataSet.ThisColumn[8][0], thisDataSet.ThisColumn[0][0].ToString(), transfarDataRow[0])); } else { return false; } } catch { return false; } }
//Sales Ledger public bool SalesLedger(DataTable transfarData, TransactionType transactionType, DBQueres DataWriter, DatabaseRead DataReadr, MysqlRowCounter TableRowCounter) { try { AccountingDataSet commonDataSet = new AccountingDataSet(); DataRow transfarDataRow=transfarData.Rows[0]; DataWriter(string.Format("INSERT INTO {0} VALUES ('{1}','{2}','{3}','{4}','{5}','{6}',{7},0,{8},0,{9}+{8})", thisDataSet.ThisTables[20][0], transfarDataRow[0],transfarDataRow[6],transfarDataRow[1], transactionType, transfarDataRow[2], transfarDataRow[3], transfarDataRow[4], transfarDataRow[5],LastRowVaue(thisDataSet.ThisColumn[9][0].ToString(),thisDataSet.ThisTables[20][0].ToString(),new DatabaseRead(DataReadr),new MysqlRowCounter(TableRowCounter)))); commonDataSet.ThisCommonUse.Rows.Add(transfarDataRow[0], transfarDataRow[1], ProductOperationType.Sales, transfarDataRow[2],Convert.ToDouble(transfarDataRow[2]) * Convert.ToDouble(transfarDataRow[8]),transfarDataRow[8], transfarDataRow[4], transfarDataRow[5], transfarDataRow[6]); StockOperation(commonDataSet.ThisCommonUse, ProductOperationType.Sales, new DBQueres(DataWriter), new DatabaseRead(DataReadr), new MysqlRowCounter(TableRowCounter)); if (transactionType.Equals(TransactionType.Cash)) { commonDataSet.ThisCommonUse.Clear(); //Column :0 Petunia_Date commonDataSet.ThisCommonUse.Dispose(); //Column :1 Description commonDataSet.ThisCommonUse.Rows.Add(transfarDataRow[0], transfarDataRow[1],transfarDataRow[5]); //Column :2 Transaction //should be remove return CashOperation(commonDataSet.ThisCommonUse, TransactionType.debt, new DBQueres(DataWriter), new DatabaseRead(DataReadr), new MysqlRowCounter(TableRowCounter)); //Column :2 Quantity } //Column :3 Rate else if (transactionType.Equals(TransactionType.Credit)) //Column :4 Invoice_Number { //Column :5 Debt_Tk or Credit_tk commonDataSet.ThisCommonUse.Clear(); //Column :6 Product_ID commonDataSet.ThisCommonUse.Dispose(); //Column :7 User_ID commonDataSet.ThisCommonUse.Rows.Add(transfarDataRow[0], transfarDataRow[1], transfarDataRow[10]); //Column :8 Average_Rate CashOperation(commonDataSet.ThisCommonUse, TransactionType.debt, new DBQueres(DataWriter), new DatabaseRead(DataReadr), new MysqlRowCounter(TableRowCounter)); //Column :9 Credit Balance commonDataSet.ThisCommonUse.Clear(); //Column :10 Payment Balance commonDataSet.ThisCommonUse.Dispose(); commonDataSet.ThisCommonUse.Rows.Add(transfarDataRow[0], transfarDataRow[1], transfarDataRow[9], transfarDataRow[7], transfarDataRow[6]); return CreditorsAndDebitorsAccount(commonDataSet.ThisCommonUse, TransactionType.debt, new DatabaseRead(DataReadr), new DBQueres(DataWriter), new MysqlRowCounter(TableRowCounter)); } else if (transactionType.Equals(TransactionType.check)) { commonDataSet.ThisCommonUse.Clear(); commonDataSet.ThisCommonUse.Dispose(); commonDataSet.ThisCommonUse.Rows.Add(transfarDataRow[0], transfarDataRow[1], transfarDataRow[5]); return BankAccount(commonDataSet.ThisCommonUse, TransactionType.Credit, new DatabaseRead(DataReadr), new DBQueres(DataWriter), new MysqlRowCounter(TableRowCounter)); } else { return false; } } catch { return false; } }
//Sales Return public bool SalesReturn(DataTable transfarData, TransactionType transactionType, DBQueres DataWriter, DatabaseRead DataReader, MysqlRowCounter TableRowCounter) { try { DataRow transfarDataRow = transfarData.Rows[0]; AccountingDataSet commonDataSet = new AccountingDataSet(); DataWriter(string.Format("INSERT INTO {0} VALUES('{1}','{2}','{3}','{4}',{5},{6},{7},{8},0,0,{9}-{8})",thisDataSet.ThisTables[20][0],transfarDataRow[0],transfarDataRow[2],transfarDataRow[1],transactionType.Equals(TransactionType.Cash) ? TransactionType.Cash : TransactionType.Credit, transfarDataRow[3],transfarDataRow[4],transfarDataRow[5],transfarDataRow[6],LastRowVaue(thisDataSet.ThisColumn[9][0].ToString(),thisDataSet.ThisTables[20][0].ToString(),new DatabaseRead(DataReader),new MysqlRowCounter(TableRowCounter)))); commonDataSet.ThisCommonUse.Rows.Add(transfarDataRow[0],transfarDataRow[1],transfarDataRow[2],transfarDataRow[3],transfarDataRow[4],transfarDataRow[5],transfarDataRow[6],transfarDataRow[7]); StockOperation(commonDataSet.ThisCommonUse, ProductOperationType.Purchase, new DBQueres(DataWriter), new DatabaseRead(DataReader), new MysqlRowCounter(TableRowCounter)); if (transactionType.Equals(TransactionType.Cash)) { commonDataSet.ThisCommonUse.Clear(); commonDataSet.ThisCommonUse.Dispose(); //Column : 0 Petunia_Date commonDataSet.ThisCommonUse.Rows.Add(transfarDataRow[0], transfarDataRow[1], transfarDataRow[7]); //Column : 1 Description return CashOperation(commonDataSet.ThisCommonUse, TransactionType.Credit, new DBQueres(DataWriter), new DatabaseRead(DataReader), new MysqlRowCounter(TableRowCounter)); //Column : 2 Transaction /\ Product_ID } //Column : 3 Quantity else if (transactionType.Equals(TransactionType.debt)) //Column : 4 Rate { //Column : 5 Average_Rate commonDataSet.ThisCommonUse.Clear(); //Column : 6 Invoice_Number commonDataSet.ThisCommonUse.Dispose(); //Column : 7 Debt_Tk Or credit_Tk commonDataSet.ThisCommonUse.Rows.Add(transfarDataRow[0], transfarDataRow[1], transfarDataRow[7], transfarDataRow[8],transfarDataRow[9]); //Column : 8 User_ID return CreditorsAndDebitorsAccount(commonDataSet.ThisCommonUse, TransactionType.debt, new DatabaseRead(DataReader), new DBQueres(DataWriter), new MysqlRowCounter(TableRowCounter)); //Column :9 Product_ID } else { return false; } } catch { return false; } }
//Office Instrument public bool OfficeInstrumentLedger(DataTable transfarData, TransactionType transactionType, DBQueres DataWriter, DatabaseRead DataReader, MysqlRowCounter TableRowCounter) { try { AccountingDataSet commonDataSet = new AccountingDataSet(); DataRow transfarDataRow = transfarData.Rows[0]; DataWriter(string.Format("INSERT INTO {0} VALUES ('{1}','{2}',{3},0,{4}+{3},0)",thisDataSet.ThisTables[14][0], transfarDataRow[0], transfarDataRow[1], transfarDataRow[3], LastRowVaue(thisDataSet.ThisColumn[8][0].ToString(), thisDataSet.ThisTables[10][0].ToString(), new DatabaseRead(DataReader), new MysqlRowCounter(TableRowCounter)))); if (transactionType.Equals(TransactionType.Cash)) { commonDataSet.ThisCommonUse.Clear(); commonDataSet.ThisCommonUse.Dispose(); //Column : 0 Petunia_Date commonDataSet.ThisCommonUse.Rows.Add(transfarDataRow[0], transfarDataRow[1], transfarDataRow[3]); //Column : 1 Description return CashOperation(commonDataSet.ThisCommonUse, TransactionType.Credit, new DBQueres(DataWriter), new DatabaseRead(DataReader), new MysqlRowCounter(TableRowCounter)); //Column : 2 Debt_Tk Or credit_Tk } else if (transactionType.Equals(TransactionType.check)) { commonDataSet.ThisCommonUse.Clear(); commonDataSet.ThisCommonUse.Dispose(); commonDataSet.ThisCommonUse.Rows.Add(transfarDataRow[0], transfarDataRow[1], transfarDataRow[3]); return BankAccount(commonDataSet.ThisCommonUse, TransactionType.debt, new DatabaseRead(DataReader), new DBQueres(DataWriter), new MysqlRowCounter(TableRowCounter)); } else if (transactionType.Equals(TransactionType.Credit)) { commonDataSet.ThisCommonUse.Clear(); commonDataSet.ThisCommonUse.Dispose(); commonDataSet.ThisCommonUse.Rows.Add(transfarDataRow[0], transfarDataRow[1], transfarDataRow[3], transfarDataRow[4]); return CreditorsAndDebitorsAccount(commonDataSet.ThisCommonUse, TransactionType.Credit, new DatabaseRead(DataReader), new DBQueres(DataWriter), new MysqlRowCounter(TableRowCounter)); } else { return false; } } catch { return false; } }
//Purchase Ledger public bool PurchaseLedger(DataTable transfarData, TransactionType transactionType, DBQueres DataWrite, DatabaseRead DataRader, MysqlRowCounter TableRowCounter) { try { AccountingDataSet commonDataSat = new AccountingDataSet(); DataRow transfarDataRow = transfarData.Rows[0]; //string tableStockLedger = thisDataSet.ThisTables.Rows[0][thisDataSet.ThisTables.Columns[0].ToString()].ToString(); DataWrite(string.Format("INSERT INTO {0} VALUES('{1}','{2}','{3}','{4}',{5},{6},'{7}','{8}',{9},0,{10}+{9},0)", thisDataSet.ThisTables[17][0], transfarDataRow[0],transfarDataRow[8], transfarDataRow[1], transactionType, transfarDataRow[2], transfarDataRow[3], transfarDataRow[4], transfarDataRow[5], transfarDataRow[6], LastRowVaue(thisDataSet.ThisColumn[8][0].ToString(), thisDataSet.ThisTables[17][0].ToString(), new DatabaseRead(DataRader), new MysqlRowCounter(TableRowCounter)))); //PurchaseLedger commonDataSat.ThisCommonUse.Rows.Add(transfarDataRow[0], transfarDataRow[1],ProductOperationType.Purchase, transfarDataRow[2],transfarDataRow[6],transfarDataRow[4],transfarDataRow[5],transfarDataRow[6],transfarDataRow[8]); StockOperation(commonDataSat.ThisCommonUse, ProductOperationType.Purchase, new DBQueres(DataWrite),new DatabaseRead(DataRader),new MysqlRowCounter(TableRowCounter)); if (transactionType.Equals(TransactionType.Cash)) //Column : 0 Petunia_Date { //Column : 1 Description commonDataSat.ThisCommonUse.Clear(); //Column : 2 Transaction="";\\Should be Remove commonDataSat.ThisCommonUse.Dispose(); //Column : 2 Quantity commonDataSat.ThisCommonUse.Rows.Add(transfarDataRow[0],transfarDataRow[1],transfarDataRow[6]); //Column : 3 Rate return CashOperation(commonDataSat.ThisCommonUse, TransactionType.Credit, new DBQueres(DataWrite), new DatabaseRead(DataRader), new MysqlRowCounter(TableRowCounter)); //Column : 4 Average_Rate } //Column : 5 Invoice_Number else if (transactionType.Equals(TransactionType.check)) //Column : 6 Debt_Tk or Credit_Tk { //Column : 7 User_ID commonDataSat.ThisCommonUse.Clear(); //Column : 8 ProductID commonDataSat.ThisCommonUse.Dispose(); //Column : 9 Credit Balance commonDataSat.ThisCommonUse.Rows.Add(transfarDataRow[0], transfarDataRow[1], transfarDataRow[6]); //Column :10 Payment Balance return BankAccount(commonDataSat.ThisCommonUse, TransactionType.Credit, new DatabaseRead(DataRader), new DBQueres(DataWrite), new MysqlRowCounter(TableRowCounter)); } else if (transactionType.Equals(TransactionType.Credit)) { commonDataSat.ThisCommonUse.Clear(); commonDataSat.ThisCommonUse.Dispose(); commonDataSat.ThisCommonUse.Rows.Add(transfarDataRow[0], transfarDataRow[1], transfarDataRow[10]); CashOperation(commonDataSat.ThisCommonUse, TransactionType.Credit, new DBQueres(DataWrite), new DatabaseRead(DataRader), new MysqlRowCounter(TableRowCounter)); commonDataSat.ThisCommonUse.Clear(); commonDataSat.ThisCommonUse.Dispose(); commonDataSat.ThisCommonUse.Rows.Add(transfarDataRow[0],transactionType,transfarDataRow[9],transfarDataRow[7],transfarDataRow[8]); return CreditorsAndDebitorsAccount(commonDataSat.ThisCommonUse, TransactionType.Credit, new DatabaseRead(DataRader), new DBQueres(DataWrite), new MysqlRowCounter(TableRowCounter)); } else { return false; } } catch { return false; } }
//Initial Balance Insert public bool InitialBalanceInsert(string amount ,TransactionType transactionType, DBQueres DataWriter, DatabaseRead DataReader, MysqlRowCounter TableRowCounter) { try { if (transactionType.Equals(TransactionType.Cash)) { DataWriter(string.Format("INSERT INFO {0} VALUES('{1}','0',{2},0,{3}+{2},0)",thisDataSet.ThisTables[2][0],AccountingVariables.PETUNIA_DATE,amount,LastRowVaue(thisDataSet.ThisColumn[8][0].ToString(),thisDataSet.ThisTables[2][0].ToString(),new DatabaseRead(DataReader),new MysqlRowCounter(TableRowCounter)))); return true; } else if (transactionType.Equals(TransactionType.bank)) { DataWriter(string.Format("INSERT INFO {0} VALUES('{1}','{2}',0,{3}+{2},0,0)", thisDataSet.ThisTables[1][0], AccountingVariables.PETUNIA_DATE, amount, LastRowVaue(thisDataSet.ThisColumn[8][0].ToString(), thisDataSet.ThisTables[1][0].ToString(), new DatabaseRead(DataReader), new MysqlRowCounter(TableRowCounter)))); return true; } else { return false; } } catch { return false; } }
//Income And Expanse public bool ExpanseS(DataTable transfarData, ExpanceType expanceType, DBQueres DataWriter, DatabaseRead DataReader, MysqlRowCounter TableRowCounter) { try { DataRow transfarDataRow = transfarData.Rows[0]; if (expanceType.Equals(ExpanceType.Salary)) { AccountingDataSet commonDataSet = new AccountingDataSet(); commonDataSet.ThisCommonUse.Rows.Add(transfarDataRow[0],ExpanceType.OfficeExpance,transfarDataRow[3]); DataWriter(string.Format("INSERT INTO {0} VALUES('{1}','{2}','{3}','{4}',{5},0,{6}+{5},0)",thisDataSet.ThisTables[19][0],transfarDataRow[0],transfarDataRow[4],transfarDataRow[1],transfarDataRow[2],transfarDataRow[3],LastRowVaue(thisDataSet.ThisColumn[6][0].ToString(),thisDataSet.ThisTables[19][0].ToString(),new DatabaseRead(DataReader),new MysqlRowCounter(TableRowCounter)))); DataWriter(string.Format("UPDATE {0} SET {1}={1}+{2} WHERE {3}='{4}' AND {5}='Salary'",thisDataSet.ThisTables[16][0],thisDataSet.ThisColumn[6][0],transfarDataRow[3],thisDataSet.ThisColumn[0][0],transfarDataRow[0],thisDataSet.ThisColumn[1][0])); CashOperation(commonDataSet.ThisCommonUse, TransactionType.Credit, new DBQueres(DataWriter), new DatabaseRead(DataReader), new MysqlRowCounter(TableRowCounter)); DataWriter(string.Format("UPDATE {0} SET {1}={2} WHERE {3}='{4}'", thisDataSet.ThisTables[3][0], thisDataSet.ThisColumn[6][0], transfarDataRow[3],thisDataSet.ThisColumn[12][0],transfarDataRow[4])); //Column : 0 Petunia_Date return DataWriter(string.Format("INSERT INTO {0} VALUES('{1}','Salary','{2}','{3}',{4},0,0,0)", thisDataSet.ThisTables[24][0], transfarDataRow[0], transfarDataRow[4], transfarDataRow[1], transfarDataRow[3])); //Column : 1 Description } //Column : 2 Transaction else if (expanceType.Equals(ExpanceType.Rent)) //Column : 3 Debt_Tk Or credit_Tk { //Column : 4 User_ID DataWriter(string.Format("INSERT INTO {0} VALUES('{1}','{2}','{3}',{4},0,{5}+{4},0)", thisDataSet.ThisTables[18][0], transfarDataRow[0], transfarDataRow[1], transfarDataRow[2], transfarDataRow[3], LastRowVaue(thisDataSet.ThisColumn[6][0].ToString(),thisDataSet.ThisTables[19][0].ToString(), new DatabaseRead(DataReader), new MysqlRowCounter(TableRowCounter)))); return DataWriter(string.Format("UPDATE {0} SET {1}={1}+{2} WHERE {3}='{4}' AND {5}='Rent'",thisDataSet.ThisTables[16][0],thisDataSet.ThisColumn[6][0],transfarDataRow[3],thisDataSet.ThisColumn[0][0],transfarDataRow[0],thisDataSet.ThisColumn[1][0])); } else if (expanceType.Equals(ExpanceType.OfficeExpance)) { DataWriter(string.Format("INSERT INTO {0} VALUES('{1}','{2}','{3}',{4},0,{5}+{4},0)",thisDataSet.ThisTables[13][0],transfarDataRow[0],transfarDataRow[1],transfarDataRow[2],transfarDataRow[3],LastRowVaue(thisDataSet.ThisColumn[6][0].ToString(),thisDataSet.ThisTables[19][0].ToString(),new DatabaseRead(DataReader),new MysqlRowCounter(TableRowCounter)))); return DataWriter(string.Format("UPDATE {0} SET {1}={1}+{2} WHERE {3}='{4}' AND {5}='OfficeExpance'",thisDataSet.ThisTables[16][0],thisDataSet.ThisColumn[6][0],transfarDataRow[3],thisDataSet.ThisColumn[0][0],transfarDataRow[0],thisDataSet.ThisColumn[1][0])); } else if (expanceType.Equals(ExpanceType.Stationary)) { DataWriter(string.Format("INSERT INTO {0} VALUES('{1}','{2}','{3}',{4},0,{5}+{4},0)", thisDataSet.ThisTables[21][0], transfarDataRow[0], transfarDataRow[1], transfarDataRow[2], transfarDataRow[3], LastRowVaue(thisDataSet.ThisColumn[6][0].ToString(), thisDataSet.ThisTables[19][0].ToString(), new DatabaseRead(DataReader), new MysqlRowCounter(TableRowCounter)))); return DataWriter(string.Format("UPDATE {0} SET {1}={1}+{2} WHERE {3}='{4}' AND {5}='Stationary'",thisDataSet.ThisTables[16][0],thisDataSet.ThisColumn[6][0],transfarDataRow[3],thisDataSet.ThisColumn[0][0],transfarDataRow[0],thisDataSet.ThisColumn[1][0])); } else if (expanceType.Equals(ExpanceType.Others)) { DataWriter(string.Format("INSERT INTO {0} VALUES('{1}','{2}','{3}',{4},0,{5}+{4},0)", thisDataSet.ThisTables[9][0], transfarDataRow[0], transfarDataRow[1], transfarDataRow[2], transfarDataRow[3], LastRowVaue(thisDataSet.ThisColumn[6][0].ToString(), thisDataSet.ThisTables[19][0].ToString(), new DatabaseRead(DataReader), new MysqlRowCounter(TableRowCounter)))); return DataWriter(string.Format("UPDATE {0} SET {1}={1}+{2} WHERE {3}='{4}' AND {5}='Others'",thisDataSet.ThisTables[16][0],thisDataSet.ThisColumn[6][0],transfarDataRow[3],thisDataSet.ThisColumn[0][0],transfarDataRow[0],thisDataSet.ThisColumn[1][0])); } else { return false; } } catch { return false; } }
//Depreciation Furniture And Office Instrument public bool DepreciationFurnitureAndOfficeInstrument(DBQueres DataWriter, DatabaseRead DataReader, MysqlRowCounter TableRowCounter) { try { AccountOtherFunctions otherAccountingFunctions = new AccountOtherFunctions(); double Depreciation= LastRowVaue(thisDataSet.ThisColumn[8][0].ToString(),thisDataSet.ThisTables[10][0].ToString(),new DatabaseRead(DataReader),new MysqlRowCounter(TableRowCounter)); DataWriter(string.Format("INSERT INTO {0} VALUES('{1}','Depreciation (15%)',0,{2},{3}-{2},0)", thisDataSet.ThisTables[10][0], AccountingVariables.PETUNIA_DATE,otherAccountingFunctions.PersentIs(Depreciation),Depreciation)); DataWriter(string.Format("INSERT INTO {0} VALUES ('{1}','Furniture Depreciation (15%)',{2},0,0,0)", thisDataSet.ThisTables[16][0], AccountingVariables.PETUNIA_DATE, otherAccountingFunctions.PersentIs(Depreciation))); Depreciation = LastRowVaue(thisDataSet.ThisColumn[8][0].ToString(), thisDataSet.ThisTables[14][0].ToString(), new DatabaseRead(DataReader), new MysqlRowCounter(TableRowCounter)); DataWriter(string.Format("INSERT INTO {0} VALUES('{1}','Depreciation (15%)',0,{2},{3}-{2},0)", thisDataSet.ThisTables[14][0], AccountingVariables.PETUNIA_DATE, otherAccountingFunctions.PersentIs(Depreciation), Depreciation)); return DataWriter(string.Format("INSERT INTO {0} VALUES ('{1}','Office Instrutement Depreciation (15%)',{2},0,0,0)", thisDataSet.ThisTables[16][0], AccountingVariables.PETUNIA_DATE, otherAccountingFunctions.PersentIs(Depreciation))); } catch (Exception) { return false; } }
//Insert Creditors Account public bool CreditorsAndDebitorsAccount(DataTable transfarData,TransactionType transactionType,DatabaseRead DataReder,DBQueres DataWriter,MysqlRowCounter TableRowCounter) { try { DataRow transfarDataRow = transfarData.Rows[0]; // column :0 PETUNIA_DATE if (transactionType.Equals(TransactionType.Credit)) // column :1 DESCRIPTION { // column :2 CREDIT_TK or DEBIT_TK DataWriter(string.Format("INSERT INTO {0} VALUES ('{1}','{2}','{3}','{4}',0,{5},0,{6}+{5})", thisDataSet.ThisTables[5][0], transfarDataRow[0], transfarDataRow[3], transfarDataRow[4], transfarDataRow[1], transfarDataRow[2], LastRowVaue(thisDataSet.ThisColumn[9][0].ToString(), thisDataSet.ThisTables[5][0].ToString(), new DatabaseRead(DataReder), new MysqlRowCounter(TableRowCounter)))); DataWriter(string.Format("UPDATE {0} SET {1}={1}+{2} WHERE {3}='{4}'",thisDataSet.ThisTables[3][0],thisDataSet.ThisColumn[6][0],transfarDataRow[2],thisDataSet.ThisColumn[12][0],transfarDataRow[3])); // column :3 User_ID return DataWriter(string.Format("INSERT INTO {0} VALUES ('{1}','{2}','{3}','{4}',0,{5},0,0)",thisDataSet.ThisTables[24][0],transfarDataRow[0],transfarDataRow[3],transfarDataRow[4],transfarDataRow[1],transfarDataRow[2]));//need update Credit_Balance_Tk //Column : 4 Product ID } else if (transactionType.Equals(TransactionType.debt)) { DataWriter(string.Format("INSERT INTO {0} VALUES ('{1}','{2}','{3}','{4}',{5},0,{6}-{5},0)", thisDataSet.ThisTables[7][0], transfarDataRow[0], transfarDataRow[3], transfarDataRow[4], transfarDataRow[1], transfarDataRow[2], LastRowVaue(thisDataSet.ThisColumn[9][0].ToString(), thisDataSet.ThisTables[7][0].ToString(), new DatabaseRead(DataReder), new MysqlRowCounter(TableRowCounter)))); DataWriter(string.Format("UPDATE {0} SET {1}={1}-{2} WHERE {3}='{4}'", thisDataSet.ThisTables[3][0], thisDataSet.ThisColumn[7][0], transfarDataRow[2], thisDataSet.ThisColumn[12][0], transfarDataRow[3])); return DataWriter(string.Format("INSERT INTO {0} VALUES ('{1}','{2}','{3}','{4}',{5},0,0,0)", thisDataSet.ThisTables[24][0], transfarDataRow[0],transfarDataRow[3], transfarDataRow[4], transfarDataRow[1], transfarDataRow[2]));//need update Credit_Balance_Tk } else { return false; } } catch (Exception) { return false; } }
//Cash Received public bool CashReceived(DataTable transfarData, DBQueres DataWriter,DatabaseRead DataReader, MysqlRowCounter TableRowCounter) { try { AccountingDataSet commonDataSet = new AccountingDataSet(); DataRow transfarDataRow = transfarData.Rows[0]; commonDataSet.ThisCommonUse.Rows.Add(transfarDataRow[0],"Cash Receive",transfarDataRow[1]); return CashOperation(commonDataSet.ThisCommonUse, TransactionType.debt, new DBQueres(DataWriter), new DatabaseRead(DataReader), new MysqlRowCounter(TableRowCounter)); } catch //Column : Petunia_Date { //Column : Debt_Tk Or credit_Tk return false; } }