private ContactCustomFieldsInfo Get_Contact_Custom_Fields_values(DataRow dr)
{
ContactCustomFieldsInfo customfields = new ContactCustomFieldsInfo();
customfields.Contact_Custom_Field_Id = Convert.ToInt32(dr["Contact_Custom_Field_Id"]);
customfields.Contact_Id = Convert.ToInt32(dr["Contact_Id"]);
customfields.Field_Name = Convert.ToString(dr["Field_Name"]);
customfields.Field_Value = Convert.ToString(dr["Field_Value"]);
customfields.Is_Active = Convert.ToBoolean(dr["Is_Active"]);
customfields.CreatedOn = Convert.ToDateTime(dr["CreatedOn"]);
customfields.CreatedBy = Convert.ToInt32(dr["CreatedBy"]);
customfields.UpdatedOn = Convert.ToDateTime(dr["UpdatedOn"]);
customfields.UpdatedBy = Convert.ToInt32(dr["UpdatedBy"]);
return(customfields);
}
private List <SqlParameter> Set_Values_In_Contact_Custom_Fields(ContactCustomFieldsInfo custom_Fields)
{
List <SqlParameter> sqlparam = new List <SqlParameter>();
if (custom_Fields.Contact_Custom_Field_Id != 0)
{
sqlparam.Add(new SqlParameter("@Contact_Custom_Field_Id", custom_Fields.Contact_Custom_Field_Id));
}
sqlparam.Add(new SqlParameter("@Contact_Id", custom_Fields.Contact_Id));
sqlparam.Add(new SqlParameter("@Field_Name", custom_Fields.Field_Name));
sqlparam.Add(new SqlParameter("@Field_Value", custom_Fields.Field_Value));
sqlparam.Add(new SqlParameter("@Is_Active", custom_Fields.Is_Active));
if (custom_Fields.Contact_Custom_Field_Id == 0)
{
sqlparam.Add(new SqlParameter("@CreatedBy", custom_Fields.CreatedBy));
sqlparam.Add(new SqlParameter("@CreatedOn", custom_Fields.CreatedOn));
}
sqlparam.Add(new SqlParameter("@UpdatedBy", custom_Fields.UpdatedBy));
sqlparam.Add(new SqlParameter("@UpdatedOn", custom_Fields.UpdatedOn));
return(sqlparam);
}
public void Update_Contact_Custom_Fields(ContactCustomFieldsInfo custom_Fields)
{
_sqlRepo.ExecuteNonQuery(Set_Values_In_Contact_Custom_Fields(custom_Fields), StoredProcedures.Update_Contact_Custom_Fields_Sp.ToString(), CommandType.StoredProcedure);
}
public void Update_Contact_Custom_Fields(ContactCustomFieldsInfo custom_Fields)
{
_contactRepo.Update_Contact_Custom_Fields(custom_Fields);
}
public void Insert_Contact_Custom_Fields(ContactCustomFieldsInfo custom_Fields)
{
_contactRepo.Insert_Contact_Custom_Fields(custom_Fields);
}
