private List <SqlParameter> Set_Values_In_Customer_Event_Mapping(CustomerEventMappingInfo customereventmapping)
{
List <SqlParameter> sqlParams = new List <SqlParameter>();
//sqlParams.Add(new SqlParameter("@Customer_Event_Mapping_Id", customereventmapping.Customer_Event_Mapping_Id));
sqlParams.Add(new SqlParameter("@Event_Id", customereventmapping.Event_Id));
sqlParams.Add(new SqlParameter("@Customer_Id", customereventmapping.Customer_Id));
sqlParams.Add(new SqlParameter("@Is_Active", customereventmapping.Is_Active));
sqlParams.Add(new SqlParameter("@Created_By", customereventmapping.Created_By));
sqlParams.Add(new SqlParameter("@Updated_By", customereventmapping.Updated_By));
sqlParams.Add(new SqlParameter("@Created_On", customereventmapping.Created_On));
sqlParams.Add(new SqlParameter("@Updated_On", customereventmapping.Updated_On));
return(sqlParams);
}
private CustomerEventMappingInfo Get_Customer_Event_Mapping_Values(DataRow dr)
{
CustomerEventMappingInfo customereventmapping = new CustomerEventMappingInfo();
customereventmapping.Customer_Event_Mapping_Id = Convert.ToInt32(dr["Customer_Event_Mapping_Id"]);
customereventmapping.Event_Id = Convert.ToInt32(dr["Event_Id"]);
customereventmapping.Customer_Id = Convert.ToInt32(dr["Customer_Id"]);
customereventmapping.Is_Active = Convert.ToBoolean(dr["Is_Active"]);
customereventmapping.Created_By = Convert.ToInt32(dr["Created_By"]);
customereventmapping.Updated_By = Convert.ToInt32(dr["Updated_By"]);
customereventmapping.Created_On = Convert.ToDateTime(dr["Created_On"]);
customereventmapping.Updated_On = Convert.ToDateTime(dr["Updated_On"]);
customereventmapping.Customer_Name = Convert.ToString(dr["Customer_Name"]);
return(customereventmapping);
}
public void Insert_Customer_Event_Mapping(CustomerEventMappingInfo customereventmapping)
{
_eventRepo.Insert_Customer_Event_Mapping(customereventmapping);
}
//customer event mapping
public void Insert_Customer_Event_Mapping(CustomerEventMappingInfo customereventmapping)
{
_sqlRepo.ExecuteNonQuery(Set_Values_In_Customer_Event_Mapping(customereventmapping), StoredProcedures.Insert_Customer_Event_Mapping_Sp.ToString(), CommandType.StoredProcedure);
}
