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);
}
}
