private void UpdateData(UserRight userRight)
{
using (SqlConnection connection = new SqlConnection(this._connString))
{
string updateSql = @"UPDATE dbo.posTbUserRight SET Name = @URGName, Rights = @URGRights, Status = @URGStatus WHERE IdUserRight = @URGIdUserRight;";
SqlCommand command = new SqlCommand(updateSql, connection);
command.Parameters.Add("@URGIdUserRight", SqlDbType.Char).Value = userRight.Id;
command.Parameters.Add("@URGName", SqlDbType.VarChar).Value = userRight.Name;
command.Parameters.Add("@URGRights", SqlDbType.VarChar).Value = RightsHelper.ToVarchar(userRight.Rights);
command.Parameters.Add("@URGStatus", SqlDbType.Bit).Value = userRight.Status;
connection.Open();
command.ExecuteNonQuery();
}
}
private void InsertData(UserRight userRight)
{
using (SqlConnection connection = new SqlConnection(this._connString))
{
string insertIntoSql = @"INSERT INTO dbo.posTbUserRight (IdUserRight, Name, Rights, Status) VALUES (@URGIdUserRight, @URGName, @URGRights, @URGStatus);";
SqlCommand command = new SqlCommand(insertIntoSql, connection);
command.Parameters.Add("@URGIdUserRight", SqlDbType.Char).Value = userRight.Id;
command.Parameters.Add("@URGName", SqlDbType.VarChar).Value = userRight.Name;
command.Parameters.Add("@URGRights", SqlDbType.VarChar).Value = RightsHelper.ToVarchar(userRight.Rights);
command.Parameters.Add("@URGStatus", SqlDbType.Bit).Value = userRight.Status;
connection.Open();
command.ExecuteNonQuery();
}
}
