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();
}
