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