public Int32 InsertEvents_workshops(Events_workshops objRecord)
{
Int32 objRet = 0;
ConnectionStringSettings objCSS = ConfigurationManager.ConnectionStrings["EventRegConnectionString"];
using (SqlConnection objCnn = new SqlConnection(objCSS.ConnectionString))
{
objCnn.Open();
using (SqlCommand objCmd = objCnn.CreateCommand())
{
objCmd.CommandType = System.Data.CommandType.StoredProcedure;
objCmd.CommandText = "[AddEvents_workshops]";
objCmd.Parameters.Add(new SqlParameter("@Workshop_Name", objRecord.Workshop_Name));
objCmd.Parameters.Add(new SqlParameter("@Isdelete", objRecord.Isdelete));
objCmd.Parameters.Add(new SqlParameter("@Event_Id", objRecord.Event_Id));
object obj = objCmd.ExecuteScalar();
if (obj != null)
{
objRet = Convert.ToInt32(obj);
}
}
}
return(objRet);
}
public void DeleteEvents_workshops(Events_workshops objRecord)
{
ConnectionStringSettings objCSS = ConfigurationManager.ConnectionStrings["EventRegConnectionString"];
using (SqlConnection objCnn = new SqlConnection(objCSS.ConnectionString))
{
objCnn.Open();
using (SqlCommand objCmd = objCnn.CreateCommand())
{
objCmd.CommandType = System.Data.CommandType.StoredProcedure;
objCmd.CommandText = "[DeleteEvents_workshops]";
objCmd.Parameters.Add(new SqlParameter("@Workshop_ID", objRecord.Workshop_ID));
objCmd.ExecuteNonQuery();
}
}
}
