protected void BtnSave_Click(object sender, EventArgs e)
{
GiftCertificate objcreate = new GiftCertificate();
string stringstatus =objcreate.Creategiftcode(TxtCouponCode.Text.Trim(),Convert.ToInt32(TxtCouponValue.Text.Trim()),Txtremark.Text.Trim());
LblErrorMessage.Text = stringstatus;
GridView1.DataBind();
// SqlConnection con = new SqlConnection(ConnectionStrig);
// SqlCommand cmd = new SqlCommand();
// cmd.Connection = con;
// cmd.CommandText = "insert into certificatecode(CouponCode,ValueUSD,Dateissued) values(@CouponCode,@ValueUSD,@Dateissued)";
// cmd.CommandType = CommandType.Text;
// /* Passing parameters for L
// * ot Information*/
// cmd.Parameters.AddWithValue("@CouponCode", TxtCouponCode.Text.Trim());
// cmd.Parameters.AddWithValue("@ValueUSD", TxtCouponValue.Text.Trim());
// cmd.Parameters.AddWithValue("@Dateissued",couponcrtime);
// // cmd.Parameters.AddWithValue("@DateUsed", "");
// try
// {
// cmd.Connection.Open();
// int result = cmd.ExecuteNonQuery();
// if (result > 0)
// {
// string message = "Successfully inserted.";
// LblErrorMessage.Text = message;
// }
// }
// catch (SqlException ex)
// {
// string message = "Sql Error :" + ex.Message;
// LblErrorMessage.Text = message;
// }
// finally
// {
// cmd.Connection.Close();
// GridView1.DataBind();
// }
//}
//protected void BtnReset_Click(object sender, EventArgs e)
//{
// TxtCouponCode.Text = "";
// TxtCouponValue.Text = "";
//}
}
