public void Update(Picture item)
{
var parameters = new List <SqlParameter>
{
helper.CreateParameter("@Id", item.Id, DbType.Int32),
helper.CreateParameter("@Path", item.Path, DbType.String)
};
helper.Update("UpdatePicture", CommandType.StoredProcedure, parameters.ToArray());
}
public void Update(Email item)
{
var parameters = new List <SqlParameter>
{
helper.CreateParameter("@Id", item.Id, DbType.Int32),
helper.CreateParameter("@Address", item.Address, DbType.String)
};
helper.Update("UpdateEmail", CommandType.StoredProcedure, parameters.ToArray());
}
public void Update(Category item)
{
var parameters = new List <SqlParameter>
{
helper.CreateParameter("@Id", item.Id, DbType.Int32),
helper.CreateParameter("@Name", item.Name, DbType.String)
};
helper.Update("UpdateCategory", CommandType.StoredProcedure, parameters.ToArray());
}
public void Update(Role item)
{
var parameters = new SqlParameter[]
{
helper.CreateParameter("@Id", item.Id, DbType.Int32),
helper.CreateParameter("@Name", item.Name, DbType.String)
};
helper.Update("UpdateRole", CommandType.StoredProcedure, parameters);
}
public void Update(User item)
{
var parameters = new SqlParameter[]
{
helper.CreateParameter("@Id", item.Id, DbType.Int32),
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.Update("UpdateUser", CommandType.StoredProcedure, parameters);
}
public void Update(Record item)
{
var parameters = new List <SqlParameter>
{
helper.CreateParameter("@Id", item.Id, DbType.Int32),
helper.CreateParameter("@Name", item.Name, DbType.String),
helper.CreateParameter("@CreateDate", item.CreateDate, DbType.DateTime),
helper.CreateParameter("@Description", item.Description, DbType.String),
helper.CreateParameter("@CategoryId", item.CategoryId, DbType.Int32),
helper.CreateParameter("@PictureId", item.PictureId, DbType.Int32)
};
helper.Update("UpdateRecord", CommandType.StoredProcedure, parameters.ToArray());
}