public Int32 InsertEvent_Visitor(Event_Visitor 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 = "[AddEvent_Visitor]"; objCmd.Parameters.Add(new SqlParameter("@Event_Visitor_ID", objRecord.Event_Visitor_ID)); objCmd.Parameters.Add(new SqlParameter("@Event_ID", objRecord.Event_ID)); objCmd.Parameters.Add(new SqlParameter("@Visitor_ID", objRecord.Visitor_ID)); objCmd.Parameters.Add(new SqlParameter("@Registration_Date", objRecord.Registration_Date)); objCmd.Parameters.Add(new SqlParameter("@USER_ID", objRecord.USER_ID)); objCmd.Parameters.Add(new SqlParameter("@Created_Date", objRecord.Created_Date)); objCmd.Parameters.Add(new SqlParameter("@Isdelete", objRecord.Isdelete)); object obj = objCmd.ExecuteScalar(); if (obj != null) { objRet = Convert.ToInt32(obj); } } } return(objRet); }
public void DeleteEvent_Visitor(Event_Visitor 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 = "[DeleteEvent_Visitor]"; objCmd.Parameters.Add(new SqlParameter("@Event_Visitor_ID", objRecord.Event_Visitor_ID)); objCmd.ExecuteNonQuery(); } } }
public List <Event_Visitor> GetEvent_Visitors() { List <Event_Visitor> objRet = new List <Event_Visitor>(); 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 = "[GetAllEvent_Visitor]"; using (SqlDataReader objDR = objCmd.ExecuteReader()) { while (objDR.Read()) { Event_Visitor objRec = new Event_Visitor(); if (objDR.IsDBNull(objDR.GetOrdinal("Event_Visitor_ID"))) { objRec.Event_Visitor_ID = 0; } else { objRec.Event_Visitor_ID = objDR.GetInt64(objDR.GetOrdinal("Event_Visitor_ID")); } if (objDR.IsDBNull(objDR.GetOrdinal("Event_ID"))) { objRec.Event_ID = 0; } else { objRec.Event_ID = objDR.GetInt64(objDR.GetOrdinal("Event_ID")); } if (objDR.IsDBNull(objDR.GetOrdinal("Visitor_ID"))) { objRec.Visitor_ID = 0; } else { objRec.Visitor_ID = objDR.GetInt64(objDR.GetOrdinal("Visitor_ID")); } if (objDR.IsDBNull(objDR.GetOrdinal("Registration_Date"))) { objRec.Registration_Date = DateTime.Now; } else { objRec.Registration_Date = objDR.GetDateTime(objDR.GetOrdinal("Registration_Date")); } if (objDR.IsDBNull(objDR.GetOrdinal("USER_ID"))) { objRec.USER_ID = 0; } else { objRec.USER_ID = objDR.GetInt32(objDR.GetOrdinal("USER_ID")); } if (objDR.IsDBNull(objDR.GetOrdinal("Created_Date"))) { objRec.Created_Date = DateTime.Now; } else { objRec.Created_Date = objDR.GetDateTime(objDR.GetOrdinal("Created_Date")); } if (objDR.IsDBNull(objDR.GetOrdinal("Isdelete"))) { objRec.Isdelete = false; } else { objRec.Isdelete = objDR.GetBoolean(objDR.GetOrdinal("Isdelete")); } objRet.Add(objRec); } } } } return(objRet); }