private void BindData()
{
BLL.Exchange objEx = new BLL.Exchange();
objEx.GetTopExchange();
uiRepeaterExchange.DataSource = objEx.DefaultView;
uiRepeaterExchange.DataBind();
}
protected void uiLinkButtonDelete_Click(object sender, EventArgs e)
{
BLL.Exchange objData = new BLL.Exchange();
objData.LoadAll();
objData.DeleteAll();
objData.Save();
BindData();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BLL.Exchange ex = new BLL.Exchange();
ex.GetTopExchange();
UIGridViewExchange.DataSource = ex.DefaultView;
UIGridViewExchange.DataBind();
}
}
protected void uiGridViewExchange_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "DeleteExchange")
{
BLL.Exchange objData = new BLL.Exchange();
objData.LoadByPrimaryKey(Convert.ToInt32(e.CommandArgument.ToString()));
objData.MarkAsDeleted();
objData.Save();
BindData();
}
}
protected void uiLinkButtonAdd_Click(object sender, EventArgs e)
{
BLL.Exchange objData = new BLL.Exchange();
objData.AddNew();
objData.CurrencyID = Convert.ToInt32(uiDropDownListCurrencies.SelectedValue);
objData.CellPrice = decimal.Parse(uiTextBoxCellPrice.Text);
objData.BuyPrice = decimal.Parse(uiTextBoxBuyPrice.Text);
objData.LastCellPrice = decimal.Parse(uiTextBoxLastCellPrice.Text);
objData.CreatedDate = DateTime.Now.AddHours(7);
objData.Save();
BindData();
}
protected void uiLinkButtonUpload_Click(object sender, EventArgs e)
{
if (uiFileUploadExchange.HasFile)
{
uiFileUploadExchange.SaveAs(Server.MapPath("~/FileUploads/" + uiFileUploadExchange.FileName));
string connectionString = string.Format(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties=""Excel 12.0;HDR=NO;""", Server.MapPath("~/FileUploads/" + uiFileUploadExchange.FileName));
string strSQL = "SELECT * FROM [sheet1$]";
OleDbConnection excelConnection = new OleDbConnection(connectionString);
excelConnection.Open();
OleDbCommand dbCommand = new OleDbCommand(strSQL, excelConnection);
OleDbDataAdapter dataAdapter = new OleDbDataAdapter(dbCommand);
DataTable dTable = new DataTable();
dataAdapter.Fill(dTable);
BLL.Exchange objData = new BLL.Exchange();
foreach (DataRow item in dTable.Rows)
{
objData.AddNew();
objData.CurrencyID = Convert.ToInt32(item[0].ToString());
objData.CellPrice = decimal.Parse(item[1].ToString());
objData.LastCellPrice = decimal.Parse(item[2].ToString());
objData.CreatedDate = DateTime.Now.AddHours(7);
}
objData.Save();
BindData();
}
}
private void BindData()
{
BLL.Exchange objData = new BLL.Exchange();
objData.LoadAll();
uiGridViewExchange.DataSource = objData.DefaultView;
uiGridViewExchange.DataBind();
}
