protected void uiLinkButtonDelete_Click(object sender, EventArgs e) { BLL.Exchange objData = new BLL.Exchange(); objData.LoadAll(); objData.DeleteAll(); objData.Save(); BindData(); }
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(); } }