protected void uiLinkButtonAdd_Click(object sender, EventArgs e) { AirLines objData = new AirLines(); objData.AddNew(); objData.CompanyID = Convert.ToInt32(uiDropDownListCompanies.SelectedValue); objData.FromAirPortID = Convert.ToInt32(uiDropDownListFromCity.SelectedValue); objData.ToAirPortID = Convert.ToInt32(uiDropDownListToCity.SelectedValue); objData.Save(); BindData(); }
protected void uiGridViewAirLines_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "DeleteAirLine") { AirLines objData = new AirLines(); objData.LoadByPrimaryKey(Convert.ToInt32(e.CommandArgument.ToString())); objData.MarkAsDeleted(); objData.Save(); BindData(); } }
protected void uiLinkButtonUpload_Click(object sender, EventArgs e) { if (uiFileUploadAirLines.HasFile) { ArrayList nonUploaded = new ArrayList(); uiFileUploadAirLines.SaveAs(Server.MapPath("~/FileUploads/" + uiFileUploadAirLines.FileName)); string connectionString = string.Format(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties=""Excel 12.0;HDR=NO;""", Server.MapPath("~/FileUploads/" + uiFileUploadAirLines.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); AirLines objData = new AirLines(); if (uiDropDownListUploadType.SelectedValue == "1") { foreach (DataRow item in dTable.Rows) { AirPorts Fcity = new AirPorts(); Fcity.GetAirPortByCode(item[0].ToString()); AirPorts Tcity = new AirPorts(); Tcity.GetAirPortByCode(item[1].ToString()); if (Fcity.RowCount == 0 || Tcity.RowCount == 0) { nonUploaded.Add("From : " + item[0].ToString() + " - To : " + item[1].ToString()); continue; } else { objData.AddNew(); objData.CompanyID = Convert.ToInt32(uiDropDownListCompanyUpload.SelectedValue); objData.FromAirPortID = Fcity.AirPortID; objData.ToAirPortID = Tcity.AirPortID; } } } else if (uiDropDownListUploadType.SelectedValue == "2") { foreach (DataRow item in dTable.Rows) { AirPorts Fcity = new AirPorts(); Fcity.GetAirPortByName(item[0].ToString()); AirPorts Tcity = new AirPorts(); Tcity.GetAirPortByName(item[1].ToString()); if (Fcity.RowCount == 0 || Tcity.RowCount == 0) { nonUploaded.Add("From : " + item[0].ToString() + " - To : " + item[1].ToString()); continue; } else { objData.AddNew(); objData.CompanyID = Convert.ToInt32(uiDropDownListCompanyUpload.SelectedValue); objData.FromAirPortID = Fcity.AirPortID; objData.ToAirPortID = Tcity.AirPortID; } } } objData.Save(); BindData(); uiGridViewLog.DataSource = nonUploaded; //uiGridViewLog.Columns[1].HeaderText = "These items faild to insert"; uiGridViewLog.DataBind(); } }