private VendorContactCustomFieldsInfo Get_Vendor_Contact_Custom_Field_values(DataRow dr)
{
VendorContactCustomFieldsInfo vendor_Custom_Field = new VendorContactCustomFieldsInfo();
vendor_Custom_Field.Contact_Custom_Field_Id = Convert.ToInt32(dr["Contact_Custom_Field_Id"]);
vendor_Custom_Field.Contact_Id = Convert.ToInt32(dr["Contact_Id"]);
vendor_Custom_Field.Field_Name = Convert.ToString(dr["Field_Name"]);
vendor_Custom_Field.Field_Value = Convert.ToString(dr["Field_Value"]);
vendor_Custom_Field.Is_Active = Convert.ToBoolean(dr["Is_Active"]);
vendor_Custom_Field.CreatedOn = Convert.ToDateTime(dr["CreatedOn"]);
vendor_Custom_Field.CreatedBy = Convert.ToInt32(dr["CreatedBy"]);
vendor_Custom_Field.UpdatedOn = Convert.ToDateTime(dr["UpdatedOn"]);
vendor_Custom_Field.UpdatedBy = Convert.ToInt32(dr["UpdatedBy"]);
return(vendor_Custom_Field);
}
private List <SqlParameter> Set_Values_In_Vendor_Contact_Custom_Field(VendorContactCustomFieldsInfo vendor_Custom_Field)
{
List <SqlParameter> sqlparam = new List <SqlParameter>();
if (vendor_Custom_Field.Contact_Custom_Field_Id != 0)
{
sqlparam.Add(new SqlParameter("@Contact_Custom_Field_Id", vendor_Custom_Field.Contact_Custom_Field_Id));
}
sqlparam.Add(new SqlParameter("@Contact_Id", vendor_Custom_Field.Contact_Id));
sqlparam.Add(new SqlParameter("@Field_Name", vendor_Custom_Field.Field_Name));
sqlparam.Add(new SqlParameter("@Field_Value", vendor_Custom_Field.Field_Value));
sqlparam.Add(new SqlParameter("@Is_Active", vendor_Custom_Field.Is_Active));
if (vendor_Custom_Field.Contact_Custom_Field_Id == 0)
{
sqlparam.Add(new SqlParameter("@CreatedOn", vendor_Custom_Field.CreatedOn));
sqlparam.Add(new SqlParameter("@CreatedBy", vendor_Custom_Field.CreatedBy));
}
sqlparam.Add(new SqlParameter("@UpdatedOn", vendor_Custom_Field.UpdatedOn));
sqlparam.Add(new SqlParameter("@UpdatedBy", vendor_Custom_Field.UpdatedBy));
return(sqlparam);
}
public void Update_Vendor_Contact_Custom_Field(VendorContactCustomFieldsInfo vendor_Custom_Field)
{
_vendorcontactRepo.Update_Vendor_Contact_Custom_Field(vendor_Custom_Field);
}
public void Insert_Vendor_Contact_Custom_Field(VendorContactCustomFieldsInfo vendor_Custom_Field)
{
_vendorcontactRepo.Insert_Vendor_Contact_Custom_Field(vendor_Custom_Field);
}
public void Update_Vendor_Contact_Custom_Field(VendorContactCustomFieldsInfo vendor_Custom_Field)
{
_sqlRepo.ExecuteNonQuery(Set_Values_In_Vendor_Contact_Custom_Field(vendor_Custom_Field), StoredProcedures.Update_Contact_Custom_Fields_Sp.ToString(), CommandType.StoredProcedure);
}
