protected void ibtnEdit_Click(object sender, ImageClickEventArgs e) { GridViewRow gvRow = (GridViewRow)((ImageButton)sender).NamingContainer; Int32 M_Currency_Code = Convert.ToInt32(gvCurrency.DataKeys[gvRow.RowIndex].Value); CurrencyEntity currency = GetUserByCurrency(M_Currency_Code); // Now set value to modal popup currencyid1.Value = currency.M_Currency_Code.ToString(); txtcurrencyname1.Text = currency.M_Currency_Name; txtcurrencyshortname1.Text = currency.M_Currency_Sname; mpeCurrency1.Show(); }
protected void ibtnView_Click(object sender, ImageClickEventArgs e) { //ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Successfully')", true); GridViewRow gvRow = (GridViewRow)((ImageButton)sender).NamingContainer; Int32 M_Currency_Code = Convert.ToInt32(gvCurrency.DataKeys[gvRow.RowIndex].Value); CurrencyEntity currency = GetUserByCurrency(M_Currency_Code); // Now set value to modal popup currencyid2.Value = currency.M_Currency_Code.ToString(); viewcurrencyname.Text = currency.M_Currency_Name; viewcurrencyshortname.Text = currency.M_Currency_Sname; mpeCurrency2.Show(); }
protected void btnSave_Click1(object sender, EventArgs e) { if (Page.IsValid) { CurrencyEntity currency = new CurrencyEntity(); currency.M_Currency_Code = Convert.ToInt32(currencyid1.Value); currency.M_Currency_Name = txtcurrencyname1.Text.Trim(); currency.M_Currency_Sname = txtcurrencyshortname1.Text.Trim(); if (currency.M_Currency_Code != 0) { UpdateCurrency(currency); } LoadData(); } }
public bool AddNewCurrency(CurrencyEntity user) { String insertQuery = @"INSERT INTO [M_Currency] ([M_Currency_Name],[M_Currency_Sname]) VALUES(@M_Currency_Name, @M_Currency_Sname)"; 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_Currency_Name", user.M_Currency_Name); cmd.Parameters.AddWithValue("@M_Currency_Sname", user.M_Currency_Sname); if (conn.State == ConnectionState.Closed) { conn.Open(); } cmd.ExecuteNonQuery(); return(true); } }
public bool UpdateCurrency(CurrencyEntity user) { String updateQuery = @"UPDATE [M_Currency] SET [M_Currency_Name] = @M_Currency_Name ,[M_Currency_Sname] = @M_Currency_Sname Where [M_Currency_Code] = @M_Currency_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_Currency_Code", user.M_Currency_Code); cmd.Parameters.AddWithValue("@M_Currency_Name", user.M_Currency_Name); cmd.Parameters.AddWithValue("@M_Currency_Sname", user.M_Currency_Sname); if (conn.State == ConnectionState.Closed) { conn.Open(); } cmd.ExecuteNonQuery(); return(true); } }