public void Create(Picture item)
{
var parameters = new List <SqlParameter>
{
helper.CreateParameter("@Path", item.Path, DbType.String)
};
helper.Insert("CreatePicture", CommandType.StoredProcedure, parameters.ToArray());
}
public void Create(Category item)
{
var parameters = new List <SqlParameter>
{
helper.CreateParameter("@Name", item.Name, DbType.String)
};
helper.Insert("CreateCategory", CommandType.StoredProcedure, parameters.ToArray());
}
public void Create(Email item)
{
var parameters = new List <SqlParameter>
{
helper.CreateParameter("@Adress", item.Address, DbType.String)
};
helper.Insert("CreateEmail", CommandType.StoredProcedure, parameters.ToArray());
}
public void Create(User item)
{
var parameters = new SqlParameter[]
{
helper.CreateParameter("@Name", item.Name, DbType.String),
helper.CreateParameter("@Password", item.Password, DbType.String),
helper.CreateParameter("@RoleId", item.RoleId, DbType.Int32),
helper.CreateParameter("@EmailId", item.EmailId, DbType.Int32)
};
helper.Insert("CreateUser", CommandType.StoredProcedure, parameters);
}
public void AddEvent(int recordId, int eventId)
{
var parameters = new List <SqlParameter>
{
helper.CreateParameter("@RecordId", recordId, DbType.Int32),
helper.CreateParameter("@EventId", eventId, DbType.Int32)
};
helper.Insert("CreateRecordEventRelation", CommandType.StoredProcedure, parameters.ToArray());
}