private EventAttendanceInfo Get_Event_Attendance_Values(DataRow dr)
{
EventAttendanceInfo eventattendance = new EventAttendanceInfo();
eventattendance.Event_Id = Convert.ToInt32(dr["Event_Id"]);
eventattendance.Customer_Id = Convert.ToInt32(dr["Customer_Id"]);
eventattendance.Member_Id = Convert.ToInt32(dr["Member_Id"]);
eventattendance.Member_Name = Convert.ToString(dr["Member_Name"]);
eventattendance.Date = Convert.ToDateTime(dr["Date"]);
if ((dr["Event_Attendance_Id"]) != DBNull.Value)
{
eventattendance.Event_Attendance_Id = Convert.ToInt32(dr["Event_Attendance_Id"]);
}
return(eventattendance);
}
private List <SqlParameter> Set_Values_In_Event_Attendance(EventAttendanceInfo eventattendance)
{
List <SqlParameter> sqlParams = new List <SqlParameter>();
if (eventattendance.Event_Attendance_Id != 0)
{
sqlParams.Add(new SqlParameter("@Event_Attendance_Id", eventattendance.Event_Attendance_Id));
}
sqlParams.Add(new SqlParameter("@Event_Id", eventattendance.Event_Id));
sqlParams.Add(new SqlParameter("@Member_Id", eventattendance.Member_Id));
sqlParams.Add(new SqlParameter("@Date", eventattendance.Date));
sqlParams.Add(new SqlParameter("@Is_Active", eventattendance.Is_Active));
if (eventattendance.Event_Attendance_Id == 0)
{
sqlParams.Add(new SqlParameter("@Created_By", eventattendance.Created_By));
sqlParams.Add(new SqlParameter("@Created_On", eventattendance.Created_On));
}
sqlParams.Add(new SqlParameter("@Updated_By", eventattendance.Updated_By));
sqlParams.Add(new SqlParameter("@Updated_On", eventattendance.Updated_On));
return(sqlParams);
}
