private List <SqlParameter> Set_Values_In_Member_Event_Mapping(MemberEventMappingInfo membereventmapping)
{
List <SqlParameter> sqlParams = new List <SqlParameter>();
if (membereventmapping.Member_Event_Mapping_Id != 0)
{
sqlParams.Add(new SqlParameter("@Member_Event_Mapping_Id", membereventmapping.Member_Event_Mapping_Id));
}
sqlParams.Add(new SqlParameter("@Event_Id", membereventmapping.Event_Id));
sqlParams.Add(new SqlParameter("@Member_Id", membereventmapping.Member_Id));
sqlParams.Add(new SqlParameter("@Is_Remind", membereventmapping.Is_Remind));
sqlParams.Add(new SqlParameter("@Is_Active", membereventmapping.Is_Active));
if (membereventmapping.Member_Event_Mapping_Id == 0)
{
sqlParams.Add(new SqlParameter("@Created_By", membereventmapping.Created_By));
sqlParams.Add(new SqlParameter("@Created_On", membereventmapping.Created_On));
}
sqlParams.Add(new SqlParameter("@Updated_By", membereventmapping.Updated_By));
sqlParams.Add(new SqlParameter("@Updated_On", membereventmapping.Updated_On));
return(sqlParams);
}
private MemberEventMappingInfo Get_Member_Event_Mapping_Values(DataRow dr)
{
MemberEventMappingInfo membereventmapping = new MemberEventMappingInfo();
membereventmapping.Member_Id = Convert.ToInt32(dr["Member_Id"]);
membereventmapping.Member_Name = Convert.ToString(dr["Member_Name"]);
membereventmapping.Contact = Convert.ToString(dr["Contact"]);
if ((dr["Member_Event_Mapping_Id"]) != DBNull.Value)
{
membereventmapping.Member_Event_Mapping_Id = Convert.ToInt32(dr["Member_Event_Mapping_Id"]);
}
return(membereventmapping);
}
