public static ItemInCustomSmallType CreateInstance(bool isInitDefaultValue)
{
ItemInCustomSmallType model = new ItemInCustomSmallType();
if (isInitDefaultValue)
{
model.ItemInCustomSmallTypeId = Guid.NewGuid();
}
return model;
}
public override bool CreateItemInCustomSmallType(ItemInCustomSmallType itemInCustomSmallType)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("Insert Into ItemInCustomSmallType(");
strSql.Append("ItemInCustomSmallTypeId,ItemId,CustomSmallTypeId");
strSql.Append(") Values (");
strSql.Append("@ItemInCustomSmallTypeId,@ItemId,@CustomSmallTypeId");
strSql.Append(")");
SqlParameter[] parameters = {
new SqlParameter("@ItemInCustomSmallTypeId", SqlDbType.UniqueIdentifier),
new SqlParameter("@ItemId", SqlDbType.UniqueIdentifier),
new SqlParameter("@CustomSmallTypeId", SqlDbType.UniqueIdentifier)
};
parameters[0].Value = itemInCustomSmallType.ItemInCustomSmallTypeId;
parameters[1].Value = itemInCustomSmallType.ItemId;
parameters[2].Value = itemInCustomSmallType.CustomSmallTypeId;
int rows;
try
{
rows = DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
}
catch (SqlException ex)
{
throw ex;
}
return (rows > 0);
}
public override bool UpdateItemInCustomSmallType(ItemInCustomSmallType itemInCustomSmallType)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("Update ItemInCustomSmallType Set ");
strSql.Append(@"ItemId = @ItemId,
CustomSmallTypeId = @CustomSmallTypeId");
strSql.Append(" Where ItemInCustomSmallTypeId = @ItemInCustomSmallTypeId");
SqlParameter[] paramArray = {
new SqlParameter("@ItemInCustomSmallTypeId", SqlDbType.UniqueIdentifier),
new SqlParameter("@ItemId", SqlDbType.UniqueIdentifier),
new SqlParameter("@CustomSmallTypeId", SqlDbType.UniqueIdentifier)
};
paramArray[0].Value = itemInCustomSmallType.ItemInCustomSmallTypeId;
paramArray[1].Value = itemInCustomSmallType.ItemId;
paramArray[2].Value = itemInCustomSmallType.CustomSmallTypeId;
List<SqlParameter> parameters = new List<SqlParameter>();
parameters.AddRange(paramArray);
int rows;
try
{
rows = DbHelperSQL.ExecuteSql(strSql.ToString(),parameters.ToArray());
}
catch (SqlException ex)
{
throw ex;
}
return (rows > 0);
}
public abstract bool UpdateItemInCustomSmallType(ItemInCustomSmallType itemInCustomSmallType);
public ItemInCustomSmallType PopulateItemInCustomSmallTypeFromIDataReader(IDataReader dr)
{
ItemInCustomSmallType model = null;
if (dr != null)
{
model = new ItemInCustomSmallType();
if (dr["ItemInCustomSmallTypeId"] is System.DBNull)
model.ItemInCustomSmallTypeId = null;
else
model.ItemInCustomSmallTypeId = (Guid)dr["ItemInCustomSmallTypeId"];
if (dr["ItemId"] is System.DBNull)
model.ItemId = null;
else
model.ItemId = (Guid)dr["ItemId"];
if (dr["CustomSmallTypeId"] is System.DBNull)
model.CustomSmallTypeId = null;
else
model.CustomSmallTypeId = (Guid)dr["CustomSmallTypeId"];
}
return model;
}
public static bool Update(ItemInCustomSmallType itemInCustomSmallType)
{
CommonDataProvider dp = CommonDataProvider.Instance();
return dp.UpdateItemInCustomSmallType(itemInCustomSmallType);
}
