internal int IUDBundle(BOBundleExam _bobndlexm)
{
int returnvalue = default(int);
using (SqlConnection _sqlcon = ConnectionInfo.GetConnection())
{
_sqlcommond = new SqlCommand();
_sqlcommond.CommandText = "SP_IUDBundle";
_sqlcommond.CommandType = CommandType.StoredProcedure;
_sqlcommond.Connection = _sqlcon;
_sqlcon.Open();
_sqlcommond.Parameters.AddWithValue("@BundleId", _bobndlexm.BundleId);
_sqlcommond.Parameters.AddWithValue("@BundleContent", _bobndlexm.BundleContent);
_sqlcommond.Parameters.AddWithValue("@Price", _bobndlexm.Price);
_sqlcommond.Parameters.AddWithValue("@FeaturedSelfsEstore", _bobndlexm.FeaturedSelfsEstore);
_sqlcommond.Parameters.AddWithValue("@MerchantId", _bobndlexm.MerchantId);
_sqlcommond.Parameters.AddWithValue("@IsActive", _bobndlexm.IsActive);
_sqlcommond.Parameters.AddWithValue("@IsDelete", _bobndlexm.IsDelete);
_sqlcommond.Parameters.AddWithValue("@CreatedBy", _bobndlexm.CreatedBy);
_sqlcommond.Parameters.AddWithValue("@CreatedDate", _bobndlexm.CreatedDate);
_sqlcommond.Parameters.AddWithValue("@UpdatedBy", _bobndlexm.UpdatedBy);
_sqlcommond.Parameters.AddWithValue("@UpdatedDate", _bobndlexm.UpdatedDate);
_sqlcommond.Parameters.AddWithValue("@Event", _bobndlexm.Event);
_sqlcommond.Parameters.AddWithValue("@returnValue", 0).Direction = System.Data.ParameterDirection.InputOutput;
try
{
_sqlcommond.ExecuteNonQuery();
returnvalue = Convert.ToInt32(_sqlcommond.Parameters["@returnValue"].Value);
}
catch (SqlException sqlex)
{
Common.LogError(sqlex);
}
catch (StackOverflowException stackex)
{
Common.LogError(stackex);
}
catch (Exception ex)
{
Common.LogError(ex);
}
finally
{
_sqlcon.Close();
_sqlcommond.Dispose();
}
}
return(returnvalue);
}
internal int Delete(BOBundleExam _bobndlexm)
{
return(_dabndlexm.IUDBundle(_bobndlexm));
}
internal int Insert(BOBundleExam _bobndlexm)
{
return(_dabndlexm.IUDBundle(_bobndlexm));
}