private string PopulateCounter() { counter_Prop counterprop = new counter_Prop(); counterprop.CounterName = ""; counter_bal counterbal = new counter_bal(); DataTable dt = counterbal.CounterSearch(counterprop); if (counterbal.ErrMessage != "" && counterbal.ErrMessage != null) { return("0#" + counterbal.ErrMessage + "$"); } else { if (dt.Rows.Count > 0) { StringBuilder sb = new StringBuilder(); for (int i = 0; i < dt.Rows.Count; i++) { sb.Append(dt.Rows[i]["counterid"].ToString() + "#" + dt.Rows[i]["countername"].ToString() + "$"); } return(sb.ToString()); } else { return("0#No Data Found$"); } } }
private string CounterSearch(string countername) { counter_Prop counterprop = new counter_Prop(); counterprop.CounterName = countername; counter_bal CounterBal = new counter_bal(); DataTable dt = CounterBal.CounterSearch(counterprop); StringBuilder sb = new StringBuilder(); if (CounterBal.ErrMessage != "" && CounterBal.ErrMessage != null) { { sb.Append("<tr><td>" + CounterBal.ErrMessage + "</td><td></td><td></td><td></td><td></td><td></td></tr>"); } } else { if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { sb.Append("<tr>"); sb.Append("<td>" + dt.Rows[i]["CounterID"].ToString() + "</td>"); sb.Append("<td>" + dt.Rows[i]["CounterName"].ToString() + "</td>"); sb.Append("<td>" + dt.Rows[i]["Address"].ToString() + "</td>"); sb.Append("<td>" + dt.Rows[i]["ContactPerson"].ToString() + "</td>"); sb.Append("<td>" + dt.Rows[i]["ContactNo"].ToString() + "</td>"); sb.Append("<td ><img src='images/editrec.png' alt='block' onclick='EditRecord(" + dt.Rows[i]["CounterID"].ToString() + ")'>"); sb.Append("<img src='images/icon_delete.png' alt='reset' onclick='DeleteRecord(" + dt.Rows[i]["CounterID"].ToString() + ")'></td>"); sb.Append("</tr>"); } } else { sb.Append("<tr><td>No Record Found</td><td></td><td></td><td></td><td></td><td></td></tr>"); } } return(sb.ToString()); }