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