//To show data in popup for editing public CountryEntity GetCountry(Int32 M_Country_Code) { String selectQuery = @"select *from [M_Country] where [M_Country_Code]=@M_Country_Code"; using (SqlConnection conn = new SqlConnection()) { conn.ConnectionString = _ConnStr; SqlCommand cmd = conn.CreateCommand(); cmd.CommandText = selectQuery; cmd.CommandType = System.Data.CommandType.Text; cmd.Parameters.AddWithValue("@M_Country_Code", M_Country_Code); if (conn.State == ConnectionState.Closed) { conn.Open(); } SqlDataReader dataReader = cmd.ExecuteReader(CommandBehavior.CloseConnection); DataTable dataTable = new DataTable(); dataTable.Load(dataReader); CountryEntity existingcountry = new CountryEntity(); foreach (DataRow row in dataTable.Rows) { existingcountry.M_Country_Code = Convert.ToInt32(row["M_Country_Code"]); existingcountry.M_Country_Name = Convert.ToString(row["M_Country_Name"]); existingcountry.M_Country_Sname = Convert.ToString(row["M_Country_Sname"]); existingcountry.M_Country_Currency = Convert.ToInt32(row["M_Country_Currency"]); existingcountry.M_Country_ISD = Convert.ToInt32(row["M_Country_Isd"]); } conn.Close(); return(existingcountry); } }
// Update country data in database public bool UpdateCountry(CountryEntity country) { String updateQuery = @"UPDATE [M_Country] SET [M_Country_Name]=@M_Country_Name , [M_Country_Sname] = @M_Country_Sname, [M_Country_Currency] = @M_Country_Currency ,[M_Country_Isd] = @M_Country_Isd Where [M_Country_Code]=@M_Country_Code"; using (SqlConnection conn = new SqlConnection()) { conn.ConnectionString = _ConnStr; SqlCommand cmd = conn.CreateCommand(); cmd.CommandText = updateQuery; cmd.CommandType = System.Data.CommandType.Text; cmd.Parameters.AddWithValue("@M_Country_Code", country.M_Country_Code); cmd.Parameters.AddWithValue("@M_Country_Name", country.M_Country_Name); cmd.Parameters.AddWithValue("@M_Country_Sname", country.M_Country_Sname); cmd.Parameters.AddWithValue("@M_Country_Currency", currencydropdownlistEditpopup.SelectedItem.Value); cmd.Parameters.AddWithValue("@M_Country_Isd", country.M_Country_ISD); if (conn.State == ConnectionState.Closed) { conn.Open(); } cmd.ExecuteNonQuery(); conn.Close(); return(true); } }
//Adding country data to database public bool AddNewCountry(CountryEntity country) { String insertQuery = @"INSERT INTO [M_Country]([M_Country_Name],[M_Country_Sname],[M_Country_Currency],[M_Country_Isd]) VALUES(@M_Country_Name,@M_Country_Sname,@M_Country_Currency,@M_Country_Isd)"; using (SqlConnection conn = new SqlConnection()) { conn.ConnectionString = _ConnStr; SqlCommand cmd = conn.CreateCommand(); cmd.CommandText = insertQuery; cmd.CommandType = System.Data.CommandType.Text; cmd.Parameters.AddWithValue("@M_Country_Name", country.M_Country_Name); cmd.Parameters.AddWithValue("@M_Country_Sname", country.M_Country_Sname); cmd.Parameters.AddWithValue("@M_Country_Currency", currencydropdownlistAddpopup.SelectedItem.Value); cmd.Parameters.AddWithValue("@M_Country_Isd", @country.M_Country_ISD); if (conn.State == ConnectionState.Closed) { conn.Open(); } cmd.ExecuteNonQuery(); conn.Close(); return(true); } }
//View button click event protected void ibtnView_Click(object sender, ImageClickEventArgs e) { GridViewRow gvRow = (GridViewRow)((ImageButton)sender).NamingContainer; Int32 M_Country_Code = Convert.ToInt32(gvCountry.DataKeys[gvRow.RowIndex].Value); CountryEntity country = GetCountry(M_Country_Code); countryidAddpopup.Value = country.M_Country_Code.ToString(); txtcountrynameViewpopup.Text = country.M_Country_Name; txtcountryshortnameViewpopup.Text = country.M_Country_Sname; if (country.M_Country_ISD != null) { txtcountryisdViewpopup.Text = country.M_Country_ISD.ToString(); } mpeCountryView.Show(); }
protected void EditpopupSaveButton_Click(object sender, EventArgs e) { if (Page.IsValid) { CountryEntity country = new CountryEntity(); country.M_Country_Code = Convert.ToInt32(countryidEditpopup.Value); country.M_Country_Name = txtcountrynameEditpopup.Text.Trim(); country.M_Country_Sname = txtcountryshortnameEditpopup.Text.Trim(); country.M_Country_Currency = Convert.ToInt32(currencydropdownlistEditpopup.SelectedItem.Value); country.M_Country_ISD = Convert.ToInt32(txtcountryisdEditpopup.Text.Trim()); if (country.M_Country_Code != 0) { UpdateCountry(country); } LoadData(); } }
protected void AddpopupSaveButton_Click(object sender, EventArgs e) { // ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Sorry there are no attachments');", true); if (Page.IsValid) { CountryEntity country = new CountryEntity(); country.M_Country_Code = Convert.ToInt32(countryidAddpopup.Value); country.M_Country_Name = txtcountrynameAddpopup.Text.Trim(); country.M_Country_Sname = txtcountryshortnameAddpopup.Text.Trim(); country.M_Country_Currency = Convert.ToInt32(currencydropdownlistAddpopup.SelectedItem.Value); country.M_Country_ISD = Convert.ToInt32(txtcountryisdAddpopup.Text.Trim()); if (country.M_Country_Code == 0) { AddNewCountry(country); } LoadData(); } }