protected void Save() { BusinessLayer.PotatoRate ObjRate = new BusinessLayer.PotatoRate(); string Date = ddlMonth.SelectedValue.Trim() + "/" + ddlDay.SelectedValue.Trim() + "/" + ddlYear.SelectedValue.Trim() + " 00:00:00.000"; DataTable dt = new DataTable(); dt.Columns.Add("BlockId"); dt.Columns.Add("Bond"); dt.Columns.Add("Avg"); dt.Columns.Add("Dala"); DataRow dr; foreach (GridViewRow row in dgvBlock.Rows) { if (row.RowType == DataControlRowType.DataRow) { string BlockId = dgvBlock.DataKeys[row.RowIndex].Value.ToString(); string Bond = FitRate(((TextBox)row.FindControl("txtBond")).Text.Trim()); string Avg = FitRate(((TextBox)row.FindControl("txtAvg")).Text.Trim()); string Dala = FitRate(((TextBox)row.FindControl("txtDala")).Text.Trim()); dr = dt.NewRow(); dr["BlockId"] = BlockId; dr["Bond"] = Bond; dr["Avg"] = Avg; dr["Dala"] = Dala; dt.Rows.Add(dr); dt.AcceptChanges(); } } ObjRate.Save(Date, dt); trMsg.Visible = true; }
protected void LoadDailyRate() { BusinessLayer.PotatoRate ObjRate = new BusinessLayer.PotatoRate(); string Date = ddlMonth.SelectedValue.Trim() + "/" + ddlDay.SelectedValue.Trim() + "/" + ddlYear.SelectedValue.Trim() + " 00:00:00.000"; DataTable dt = ObjRate.GetRateByDate(Date); if (dt != null) { dgvBlock.DataSource = dt; dgvBlock.DataBind(); } }
protected void LoadDailyRate() { BusinessLayer.PotatoRate ObjRate = new BusinessLayer.PotatoRate(); string Date = ddlDay.SelectedValue.Trim() + "/" + ddlMonth.SelectedValue.Trim() + "/" + ddlYear.SelectedValue.Trim() + " 00:00:00.000"; string PotatoType = dd2PotatoType.SelectedValue.Trim(); int PotatoTypeId = Convert.ToInt32(PotatoType); string d = Date; DataTable dt = ObjRate.GetUpRateByDate(Date, PotatoTypeId); if (dt != null) { dgvBlock.DataSource = dt; dgvBlock.DataBind(); } }
protected void LoadMsg() { BusinessLayer.PotatoRate ObjRate = new BusinessLayer.PotatoRate(); string Date = ddlDay.SelectedValue.Trim() + "/" + ddlMonth.SelectedValue.Trim() + "/" + ddlYear.SelectedValue.Trim() + " 00:00:00"; DataTable dt = ObjRate.GetRateByDate(Date); string day = ddlDay.SelectedValue.Trim(); day = (day.Length == 1) ? "0" + day : day; string month = ddlMonth.SelectedValue.Trim(); month = (month.Length == 1) ? "0" + month : month; string year = ddlYear.SelectedValue.Trim(); //year = year.Substring(2); StringBuilder sb = new StringBuilder(); sb.Append("Date "); sb.Append(day + "/" + month + "/" + year + " : Low/High\n"); for (int i = 0; i < dt.Rows.Count; i++) { sb.Append(dt.Rows[i][1].ToString().Trim() + " "); sb.Append(FitRate(dt.Rows[i][2].ToString().Trim()) + "/"); sb.Append(FitRate(dt.Rows[i][3].ToString().Trim())); //sb.Append(FitRate(dt.Rows[i][4].ToString().Trim()) + ","); if (i != dt.Rows.Count - 1) { sb.Append("\n"); } } txtMsg.Text = sb.ToString(); txtMsgPreview.Text = txtMsg.Text; }
protected void LoadRateChartHorizontally() { DataTable dt = new DataTable(); BusinessLayer.PotatoRate ObjRate = new BusinessLayer.PotatoRate(); string StartDate = ddlMonth.SelectedValue.Trim() + "/01/" + ddlYear.SelectedValue.Trim() + " 00:00:00"; string EndDate = ddlMonth.SelectedValue.Trim() + "/" + ReturnEndDay() + "/" + ddlYear.SelectedValue.Trim() + " 00:00:00"; DataSet ds = ObjRate.GetAll(StartDate, EndDate); int count = 0; int day = 1; int i = 0; DataRow dr; foreach (DataTable table in ds.Tables) { if (count == 0) { dt.Columns.Add("Block"); foreach (DataRow row in table.Rows) { dr = dt.NewRow(); dr[0] = row[0].ToString(); dt.Rows.Add(dr); dt.AcceptChanges(); } count = 1; } dt.Columns.Add(day.ToString() + "/" + ddlMonth.SelectedValue.Trim() + "/" + ddlYear.SelectedValue.Trim()); i = 0; foreach (DataRow row in table.Rows) { dt.Rows[i][dt.Columns.Count - 1] = row[1].ToString(); dt.AcceptChanges(); i += 1; } day += 1; } StringBuilder sb = new StringBuilder(); sb.Append(@"<table cellspacing='0' rules='all' border='0' style='border-color:#1398ED;border-width:1px;border-style:Solid;width:100%;border-collapse:collapse;'>"); sb.Append(@"<tr class='HeaderStyle'>"); foreach (DataColumn col in dt.Columns) { sb.Append(@"<th scope='col'>" + col.ColumnName + "</th>"); } sb.Append(@"</tr>"); foreach (DataRow row in dt.Rows) { sb.Append(@"<tr class='RowStyle'>"); for (int colindex = 0; colindex < dt.Columns.Count; colindex++) { sb.Append(@"<td>" + row[colindex].ToString() + "</td>"); } sb.Append(@"</tr>"); } sb.Append(@"</table>"); ltrChart.Text = sb.ToString(); }