// **************** ADD NEW Even ********************* public bool AddEventDetailStatus(EventDetailStatusModels Emodel) { int EventID = Convert.ToInt16(Emodel.EventDetailstatusID); connection(); SqlCommand cmd = new SqlCommand("ProcEventDetailsStatus", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@EventDetailsStatusID", EventID); cmd.Parameters.AddWithValue("@EventDetailstatusName", Emodel.EventDetailstatus.ToString()); try { con.Open(); cmd.ExecuteNonQuery(); } catch (Exception Ex) { throw Ex; } finally { con.Close(); con.Dispose(); } return(true); }
// ***************** UPDATE Event DETAILS ********************* public bool UpdateDetails(EventDetailStatusModels Emodel) { connection(); SqlCommand cmd = new SqlCommand("UpdateProcEventDetailsStatus", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@EventDetailstatusID", Emodel.EventDetailstatusID); cmd.Parameters.AddWithValue("@EventDetailstatusName", Emodel.EventDetailstatus); con.Open(); int i = cmd.ExecuteNonQuery(); con.Close(); if (i >= 1) { return(true); } else { return(false); } }