protected virtual ElementTypeAttribute GetElementTypeAttributeFromReader(IDataReader reader)
{
ElementTypeAttribute elementTypeAttribute = new ElementTypeAttribute()
{
AttributeId = (Guid)reader["AttributeId"],
ElementTypeId = (Guid)reader["ElementTypeId"],
Mandatory = (bool)reader["Mandatory"],
Visibility = (bool)reader["UnVisible"]
};
return(elementTypeAttribute);
}
public override bool UpdateElementTypeAttribute(ElementTypeAttribute elementTypeAttribute)
{
using (SqlConnection cn = new SqlConnection(LayerObjectsConnection))
{
SqlCommand cmd = new SqlCommand("ElementTypeAttributes_UpdateElementTypeAttribute", cn);
//cmd.Parameters.Add("@Id", SqlDbType.NVarChar).Value = elementTypeAttribute.Id;
//cmd.Parameters.Add("@Name", SqlDbType.NVarChar).Value = elementTypeAttribute.Name;
//cmd.Parameters.Add("@Phone", SqlDbType.NVarChar).Value = elementTypeAttribute.Phone;
//cmd.Parameters.Add("@StateId", SqlDbType.Int).Value = elementTypeAttribute.ItemState;
cn.Open();
int ret = ExecuteNonQuery(cmd);
return(ret == 1);
}
}
public override int InsertElementTypeAttribute(ElementTypeAttribute elementTypeAttribute)
{
using (SqlConnection cn = new SqlConnection(LayerObjectsConnection))
{
SqlCommand cmd = new SqlCommand("ElementTypeAttributes_InsertElementTypeAttribute", cn);
cmd.CommandType = CommandType.Text;
//cmd.Parameters.Add("@Name", SqlDbType.NVarChar).Value = elementTypeAttribute.Name;
//cmd.Parameters.Add("@Phone", SqlDbType.NVarChar).Value = elementTypeAttribute.Phone;
//cmd.Parameters.Add("@StateId", SqlDbType.Int).Value = elementTypeAttribute.ItemState;
cmd.Parameters.Add("@Id", SqlDbType.Int).Direction = ParameterDirection.Output;
cn.Open();
int ret = ExecuteNonQuery(cmd);
return((int)cmd.Parameters["@Id"].Value);
}
}
public HomeData GenerateHomeData <T>(T enumType)
{
var homeData = new HomeData();
foreach (int i in Enum.GetValues(enumType.GetType()))
{
var vehicleMetaData = new VehicleMetaData();
vehicleMetaData.VehicleTypeName = Enum.GetName(enumType.GetType(), i);
vehicleMetaData.VehicleTypeValue = i;
try
{
var myPropertyInfo = Type.GetType($"MiniCarSales.Model.{vehicleMetaData.VehicleTypeName}").GetProperties();
foreach (var prop in myPropertyInfo)
{
var attrs = System.Attribute.GetCustomAttributes(prop);
foreach (var attr in attrs)
{
if (attr is ElementTypeAttribute)
{
ElementTypeAttribute a = (ElementTypeAttribute)attr;
vehicleMetaData.PropertiesData.Add(new PropertyData
{
PropertyName = prop.Name,
PropertyFormatName = a.Format,
PropertyValidationTypeName = a.ValidationName,
PropertyElementName = a.Element,
PropertySortOrder = a.SortOrder
});
}
}
}
}
catch (NullReferenceException ex)
{
Console.WriteLine($"Type is null ${ex.StackTrace}");
}
homeData.vehiclesMetaData.Add(vehicleMetaData);
}
return(homeData);
}
protected virtual ElementTypeAttribute GetAttributeFromReader(IDataReader reader)
{
ElementTypeAttribute elementTypeAttribute = new ElementTypeAttribute()
{
AttributeId = (Guid)reader["AttributeId"],
ElementTypeId = (Guid)reader["ElementTypeId"],
Mandatory = (bool)reader["Mandatory"],
Visibility = (bool)reader["UnVisible"],
Id = (Guid)reader["Id"],
AttributeTypeId = (Guid)reader["AttributeTypeId"],
Description = reader["Description"].ToString(),
Caption = reader["Caption"].ToString(),
Title = reader["Title"].ToString(),
AttributeType = reader["AttributeType"].ToString(),
Searchable = (bool)reader["Searchable"]
};
if (reader["Code"] != DBNull.Value)
{
elementTypeAttribute.Code = reader["Code"].ToString();
}
return(elementTypeAttribute);
}
//public static ElementTypeAttribute InsertElementTypeAttribute(ElementTypeAttribute elementTypeAttribute)
//{
// RemoveFromCache("ElementTypeAttributes_");
// int elementTypeAttributeId = DataAccess.ElementTypeAttributes.InsertElementTypeAttribute(elementTypeAttribute);
// elementTypeAttribute = DataAccess.ElementTypeAttributes.GetElementTypeAttributeByElementTypeAttributeId(elementTypeAttributeId);
// return elementTypeAttribute;
//}
public static bool UpdateElementTypeAttribute(ElementTypeAttribute elementTypeAttribute)
{
RemoveFromCache("ElementTypeAttributes_");
return(DataAccess.ElementTypeAttributes.UpdateElementTypeAttribute(elementTypeAttribute));
}
public abstract bool UpdateElementTypeAttribute(ElementTypeAttribute elementTypeAttribute);
public abstract int InsertElementTypeAttribute(ElementTypeAttribute elementTypeAttribute);
