c# - How to calculate a formula and add a row in data table -


i have data database in datatable object , performing row calculation based on formula defined in list of string unfortunately ending wrong calculation because sequence of rows value not match given formula calculations going wrong e.x ( income before pipeline, depr/amort , msr )= net production income - total personal cost - other cost + service fee income

for in loop first value coming datatable total personal cost , second other cost third service fee income , in last net production income. form formula
income before pipeline, depr/amort , msr = total personal cost - other cost + service fee income + net production income.

please give me solution , in particular below code code performing row calculation given formula

for (int p = 0; p < dt.rows.count; p++) {                                         rowname = dt.rows[p]["gldescription"].tostring();          addcolume[0] = "";         if (addcolume.contains(rowname))         {             int l = 1;              var drvalue = dt.rows[p][j];              if (!(drvalue == null || drvalue == dbnull.value))             {                      if (expression[index] == "+")                     {                         totalrow += convert.todecimal(drvalue);                     }                     else if (expression[index] == "-")                     {                         totalrow -= convert.todecimal(drvalue);                     }                  index++;                                                         }         }         else if (addcolume.contains(rowname) && addcolume.contains("self"))         {             var drvalue = dt.rows[p][j];             if (!(drvalue == null || drvalue == dbnull.value))             {                 decimal currentvalue = convert.todecimal(drvalue);                 dt.rows[p][j] = currentvalue * -1;             }         }   }

for support have code

list<string> lstgrouping = new list<string>(); lstgrouping.add("volume↔volume↔volume↔sigular"); lstgrouping.add("units↔units↔units↔sigular"); lstgrouping.add("blank↔blank↔sigular"); lstgrouping.add("total production revenue↔secondary-net (sell - buy +/- hedge)↔branch brokered loan income↔add"); lstgrouping.add("total direct costs↔deed recording↔provisions loan losses↔add"); lstgrouping.add("net production income↔total production revenue↔total direct costs↔+$-"); lstgrouping.add("total personnel costs↔accounting dept↔employer payroll tax exp↔add"); lstgrouping.add("total g&a costs , other↔bank fees↔provisions branch losses↔add"); lstgrouping.add("servicing fee income↔servicing fee income , net of expenses↔servicing fee income , net of expenses↔sigular"); lstgrouping.add("income before pipeline, depr/amort , msr↔net production income↔total personnel costs↔total g&a costs , other↔servicing fee income↔+$+$-$-"); lstgrouping.add("other items total↔servicing fee income , net of expenses↔depreciation expense↔add"); lstgrouping.add("net income↔income before pipeline, depr/amort , msr↔other items total↔+$+"); (int = 0; < lstgrouping.count; i++) {      var addcolume = lstgrouping[i].split('↔');      var expression = addcolume[(addcolume.length) - 1].split('$');     int startindex = 0;     int endindex = 0;      foreach (datarow dr in dt.rows)     {         string gldescription = dr["gldescription"].tostring();         if (gldescription.trim() == addcolume[1].trim())             startindex = dt.rows.indexof(dr);         else if (gldescription.trim() == addcolume[2].trim())             endindex = dt.rows.indexof(dr);     }     datarow newdr = dt.newrow();     if (expression[0] == "add")         dt.rows.insertat(newdr, endindex + 1);     else if (expression[0] == "sigular")     {         endindex = 1;     }     else         dt.rows.add(newdr);     datarow level1row = dtlevel1.newrow();     dtlevel1.rows.add(level1row);     if (startindex != null && endindex != null)     {         (int j = 0; j < dt.columns.count; j++)         {             string colname = dt.columns[j].columnname;             if (colname != "gldescription" && colname != "gldescriptionid")             {                 decimal totalrow = 0;                 if (expression[0] == "add")                 {                     (int k = startindex; k <= endindex; k++)                     {                         var drvalue = dt.rows[k][j];                         if (drvalue == null || drvalue == dbnull.value)                             drvalue = 0;                         if (expression[0].contains("add"))                             totalrow += convert.todecimal(drvalue);                     }                 }                 else if (expression[0] == "sigular")                 {                     int keyvalue = startindex;                     var drvalue = dt.rows[keyvalue][j];                     if (drvalue == null || drvalue == dbnull.value)                         drvalue = 0;                     totalrow += convert.todecimal(drvalue);                 }                 else                 {                      int index = 0;                     int paraindex = 0;                     string rowname;                     (int p = 0; p < dt.rows.count; p++)                     {                                                             rowname = dt.rows[p]["gldescription"].tostring();                              addcolume[0] = "";                             if (addcolume.contains(rowname))                             {                                 int l = 1;                                  var drvalue = dt.rows[p][j];                                  if (!(drvalue == null || drvalue == dbnull.value))                                 {                                          if (expression[index] == "+")                                         {                                             totalrow += convert.todecimal(drvalue);                                         }                                         else if (expression[index] == "-")                                         {                                             totalrow -= convert.todecimal(drvalue);                                         }                                      index++;                                                                             }                             }                             else if (addcolume.contains(rowname) && addcolume.contains("self"))                             {                                 var drvalue = dt.rows[p][j];                                 if (!(drvalue == null || drvalue == dbnull.value))                                 {                                     decimal currentvalue = convert.todecimal(drvalue);                                     dt.rows[p][j] = currentvalue * -1;                                 }                             }                       }                  }                  newdr[colname] = totalrow;                 level1row[colname] = totalrow;             }             else if (colname == "gldescription")             {                 newdr[colname] = addcolume[0];                 level1row[colname] = addcolume[0];             }         }     } } dtlevel2 = dt;  if (level == "lev1")     return dtlevel1; else if (level == "lev2")     return dt; else     return null;


Comments

Post a Comment

Popular posts from this blog

c# - Update a combobox from a presenter (MVP) -

i using mvp in project, new in mvp. have 2 comboboxes. when select option in combobox, combobox should filled new data. this action in presenter. view 'view1' in presenter, , introduced combobox1 , combobox2 properties in 'view1', because need 'datasource', 'displaymember', 'valuemember' , 'refresh()' in method below. but, when using pattern, enough send property like public string combobox2 { { return combobox1.selectedvalue.tosstring(); } } into presenter not whole combobox. how can solve problem? public void onselectedindexchangedcombobox1() { if (view1.combobox1.selectedindex == -1) { return; } datatable dt = tools.getdatatable("a path"); var query = (from o in dt.asenumerable() o.field<string>("afield") == farmerview.combobox1.selectedvalue.tostring() orderby o.field<string>("anotherfield") select...
Read more

How to understand 2 main() functions after using uftrace to profile the C++ program? -

i trying uftrace profile following simple c++ program: #include <iostream> class { public: a() {std::cout << "a created" << std::endl;} ~a() {std::cout << "a destroyed" << std::endl;} }; int main() { a; return 0; } the profile result this: # uftrace a.out created destroyed # duration tid function 2.026 [ 4828] | __cxa_atexit(); [ 4828] | main() { [ 4828] | __static_initialization_and_destruction_0() { 89.397 [ 4828] | std::ios_base::init::init(); 0.768 [ 4828] | __cxa_atexit(); 93.029 [ 4828] | } /* __static_initialization_and_destruction_0 */ 94.425 [ 4828] | } /* main */ [ 4828] | main() { [ 4828] | a::a() { 11.104 [ 4828] | std::operator <<(); 10.825 [ 4828] | std::basic_ostream::operator <<(); 24.514 [ 4828] | } /* a::a */ [ 4828] | a::~a() { 0.978 [ 4828] | ...
Read more

How to put a lock and transaction on table using spring 4 or above using jdbcTemplate and annotations like @Transactional? -

i trying put lock on table while writing on table , if happened in between roll-back . trying convert below code lock table test_g1 read; lock table test_g write; -- begin; start transaction; insert test_g1 values(143); insert test_g values(145); select * test_g1; select * test_g; rollback; select * test_g; unlock tables; how convert above code @transactional spring jdbctemplate code? @transactional(rollbackfor={dataaccessexception.class}) public void test(){ jdbctemplate.execute("insert test1 (id, nam) values (4, 'a')"); throw new dataaccessexception("error") { }; } here trying throw error, insert statement should rollback it's not happening . thanks edit-1 attaching code , doing in jdbcdaoimpl.java , mentioned problem comment above test() . app.java package com.cgiri.javabrains.spring4; import org.springframework.beans.factory.annotation.autowired; import org.springframework.context.applic...
Read more